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!
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:
Depending on answers to the above, I may be able to offer some options.
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:
Be sure that you have the below enabled in Previews:
Ok I’ll try that thank you!
Quick update for new readers:
Joined List of template columns work to list (in my experience) up to 5000+ rows now. I configured a template column to use basic column values and formatted it as a json object. Hacky, but works. Some issues to watch for if you do this. Your columns cannot have any erroneous tabs, newlines, or backslashes, and even quotes can throw it off.
Have been thus far unable to get JSON objects to work, which would be ideal, but might be because I have some computed columns going into the JSON objects in my Big Table.