Appsheet is really good at being used for a relational database with many layers. I’m working on one for a builder where we have the following tables in order:
Customer
Site
Plot
Choices
When I’m adding a new Choice, I need to find the CustomerID Ref. Its a pain (and inefficent) to have to create columns to pull in these Ref ID’s. Can we have an [_THISROW-n] options for formulas?
Sometimes the data structure can end up looking like this if its simply easier to have every table showing the Ref IDs of all senior tables:
Customer
Site | Customer
Plot | Site | Customer
Choices | Plot | Site | Customer