Solved: Dynamic product variants in choice component

[kyleheney]

I guess I didn’t realize it, but I’ve been doing this (or something very similar) for a while in some of my apps. By using the same basic logic of moving all options to a separate sheet using “UNIQUE” formulas, I can then create a relation to the User Profile and then lookup the user’s specific choices so that only the ones that they’ve added to their profile are available. I use this for employees’ jobs… people at my organization can have more than one job title, so they’re able to add multiple jobs to their profile, then when they’re filling out a form, they have a choice component that only displays their jobs as choices.

User Profile columns in conditions and columns

Figured it out! Created a new sheet with all Jobs listed (used a Unique function that combines and sorts the Jobs columns in the User Profile sheet ---- =sort(UNIQUE(PROPER({‘User Profile’!G2:G;‘User Profile’!H2:H})))). This gives me a column I can use to create a relation from the array of job titles to the UNIQUE column in the Jobs sheet. Once I have that relation done, I can add a Lookup in my other sheet that pulls in the Jobs Relation values. It’s hard to explain but it works!