> For me, a 'json:reference attributes' field would basically be like a
"list: string" field but with only one string
> holding a json object of a variable list of attributes with their value
and unit.
Then you can do simply:
db.define_table(... Field("a_list_of_json_objects", "json"))
When you get the db record, it is represented as Python object for
server-side processing. If you stored a json object, then you get a Python
dict
For explicit json export do <rows/row object>.as_json()
> So the enhancement would: use a select widget ...
It seems to me that you could build a custom widget and assign it to the
json field.
> have the ability to assign a grid object for viewing rows where the
column names match the fields in the referenced table
Also consider using contrib.spreadsheet and the data argument (for editing
a db)
--