App maintenance/Clutter clean-up

I often use the users table as the source for my screens when I want to store selections or temporary values that I need to access in other tables.

Example 1: Temporarily storing a rowID from another table so I can reference it in a relation, if-then-else column, or in a form submission.

Example 2: Storing choice component values that need to be referenced in another table for filtering purposes

The only time this differs is when I DON’T need to reference these values in other sheets. In this case, I’ll create a new table that uses user specific values to build out the functionality I need (aka a “Work table”).

Example:

3 Likes