Joined JSON workaround for big tables

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!