Hi I'm really new to Appsheet and one of the big questions I have is how to handle large, dynamic lists of data. For example the type of data you may store in an array or JSON.
For example I have a Googlesheet which I use for data. I want to save a House. Then against each House I will record Rooms. Then against each Room I will record Items. Then for each Item we have some standard data (such as Item name, image, condition). So you can see that a House can quickly end up with 100's of Items.
What is the most efficient way to store this much data? As well as Items, a House may have lots of other info against so the sheet is likely to get big quite quickly. In future I'd want to hook it up to Supabase or something like that, but as I'm just learning what do you recommend?
LinkedIn
Twitter
