Hi Gliders,
I’m currently rebuilding an app using big tables and I realized you can’t use JSON objects in joined lists using big tables.
What would be the ideal or best workaround for this?
Thanks!
Couple of questions:
- what’s the maximum number of rows you are wanting to aggregate?
- which column types are used to feed the JSON Objects? Are they all non-computed columns? If there are any computed columns - which types?
- What will you do with the aggregated JSON once you have it?
Depending on answers to the above, I may be able to offer some options.
- Max number of rows is unknown, will usually be a between 2 and 15 but could go up to hundreds.
- Columns will me mostly non computed columns but there might be a need to include computed columns.
- It will be used for line items for invoicing, quotes and contracts.
Okay, so my first thought is to replace the JSON Object column with a regular Template column.
You should be able to use a Joined List with that, with the following caveats:
- I believe you’ll be limited to 100 rows
- It may or may not work depending on which types of computed columns are being referenced by the Template
Be sure that you have the below enabled in Previews:
Ok I’ll try that thank you!