You’re offline. This is a read only version of the page.
178
Hi Guys,
I have a dropdown list pointing to a column within my collection.
My collection for example has columns models, ID's, and Row Numbers.
When a user selects a model I would like to know the Id for that particular model.
Now I know I can use a lookup formula although the problem is there are duplicate model numbers with different ID's.
A lookup will only give me the first match. I have added in a row counter to try and get the row of the selected model so then I can match it back to the ID.
A gallery will allow me to get the correct value although I don't want to use one in this instance. I need to use a dropdown.
Is there anyway to get row information on the selected dropdown model item ?
Any help is greatly appreciated.
Thanks
Ok I thought so. thanks for your help
It appears that you are using a Distinct() function in your dropdown. This eliminates all of the other columns so they cannot be referenced. If the dropdown Items property is a table with multiple columns, you can reference them.
Thank you although my dropdown is stored in results.
Example: 'ColorSelection'.Selected.Result
How would I get the other column names ? I have tried to add the column name at the end although doesn't work.
Dropdown.Selected.othercolumname
A dropdown contains an entire record but only shows one column in the window. The others can be referenced as above.
Share
Report
All responses (
Answers (
