I have the following scenario: Control Table, different variants of a Data Table, Final Table (with formulas referencing a Data Table)
Since I have different versions of Data Table, every time I want to use a particular variant, I need to update all the formulas in Final Table which lookup at Data Table.
Solution is of course to create in Control Table a place holder for Data Table, and make all the formulas in Final Table to lookup at it instead.
My question is performance related, since Data Table could have thousands of entries, that would show up in the look up field of Control Table and in the look up field of Final Table. Isn’t this double lookup overtaxing the system?
- Is my concern legit?
- Is there any why I can use a single dataTable.url() as placeholder in Control Table, and then work out the table object back from the url in the formulas inside Final Table?
Thanks for any help