When using select multiple in a choice component I’d like to lookup all the names associated to the underlying values being submitted.
So my flow is I have a choice component on a details screen where the display is a list of names and the values are pre-assigned UUIDS. If I use a split text column and then a relation match multiple I can see all the values I want but don’t know where to go from there. The end goal is to pass the values (both names and UUIDS) in the most elegant way through a webhook.
As it stands now I could submit my column holding the comma separated values through a webhook and that works for my purpose. But I also need all the names tied to those values, even if it was another comma separated list, that would work.
Here thinking fast:
1- Create a Template column using “UUID - Name” format in your “Names” table
2- Using the values saved by your Choice component (separated by comma, slash, etc) create a new array as a column. Let’s call it “UUID[ ]” column.
3- Create a multiple relation between “UUID[ ]” and your “UUID” column (belonging to “Names” table) and later a new Lookup ColumnJoined List to retrieve the “UUID - Name” values already created above.
This should be enough to get what you want… I think
I think this is exactly how I have it set up. When you say create a new array column am I correct to use a ‘split text’ column? (Forgive me I am new to using split text)
I like yours and @Uzo suggestion of using a template column in the Names table because I can paste them both together, so I’m doing that now,
But the problem is I still can’t figure out how to use that lookup column as a value in a webhook action. Could it be because it comes from a multiple relation? Perhaps I am overlooking something simple so I will keep at it.
lookup works with single and multiple relations…you cannot use multiple lookups as a value … what exactly is the problem?
if you need multiple values in one cell… use if else columns to find related values and join them
no, create a workaround for relation using IF-ELSE columns and JOIN column… it is a lot of work… but if I understand better your app, I can come up with some easy solution…
the main idea is to check if values are from the user or have specific criteria, isolate them and join…
Hmmm I want to try to avoid app bloat… this feature is something I want but don’t necessarily need.
Let me ask you, If you had a choice component (select multiple) on a details screen how would you submit both the ‘display as’ and the values in a webhook. I’m open to reorganizing my data a bit if it saves columns.
That sounds like exactly what I’m looking for and also above my pay grade hehe. Do you have an example of a simple JSON being used? I will start doing my homework and run with your advice.
@Uzo you were right all along. I should just use the template column as the values in my choice component Then I could submit the comma separated list in the webhook… that will do just fine.
@Darren_Murphy thanks for jumping in. I will do some research on using JSON because I’m sure it will be useful.
I am humbled to have so many experts come to my help. Ty all.
It’s pretty simple really, a bit like building an HTML table with several rows. You just have a template for each row, and then you combine them all together using another template.