I’m using a form container
with a choice component to select a store name
is there any way i could lookup the selection store id so that when the form is submitted i could add the store name & the store ID in the destination table.
I could create my own custom form, but i wanted to use the form container to save updates (if it actually only costs 1 update?)
Create the relation in the destination table and use lookup columns. Then use a set column in the “on submit action” for the form container. This is the cleanest way to achiever what you’re looking for, but it does have some redundancy because the lookups have the same data as the values you are writing. The only benefit this is that if you’re using a Google sheet, the data will show up there too.
If you’re already using a form container, it adds the row for you.
Am I understanding it right that you have to get the store name and store ID as basic columns? If not, you can just use the choice to select the store ID, and create a relation + lookup to pull back the store name. This would ensure if you ever change your store name, you won’t have to worry about the name being “outdated” in the destination table.