I do have a problem with calculation and selecting the right values. I tried a lot with relations, lookups but did not achieve what I was looking for. Basically I do have a
- Users table (row owners enabled)
- Child table (row owners enabled and linked by email to the users table)
- Products table (not linked)
Attemp 1 - preffered!
I want users to navigate through products and then do a calculation with the products data on the selected childs row. I guess it’s good illustrated in my demo app.
Attemp 2 - not preffered but working
I think it’s possible to use user-specific columns in the Products table and do a relation with the Childs data (but I do have a 1:n relation). Additionally, I think it’s not performant to do a calculation for each Product (about 500) with thousands of related childs. Therefore I was aiming to store the calculation fields in the Childs table.
The Products data are stored in a Google sheet and I don’t want to blow it up or ran into performance problems like this: App doesn't work with 65k rows of data
Even thought I think user-specific values are stored separately in a glide table.
Or is it possible to store the currently selected product in a global variable and link this later on to the child row?
Thanks for helping out!