You’re offline. This is a read only version of the page.
I have three drop down boxes with selected values and I want to populate a field based on the values selected. I have a list where all the values are stored/....
example
shelf 1
card 1
port 1
slot = lookup ot the three values.. I have a list that has these values and when this combination is selcted it will return a slot of if any one of the 3 change a differnet value is looked up and returned. this is a seperate list and I have both data sources tied to the app..
Hi @Anonymous ,
Can you describe your requirements in as much detail as possible, including what values you will eventually put into which table and how to get them? It would be better if it included some pictures and captions.
About how to find eligible values, here is a method that I hope will be useful to you. You can use the lookup function to find values that match the criteria, where you want to display the results of the lookup:
Share
Report
All responses (
Answers (
LookUp(DataSource,shelf1=dropdown1.selected.value&& card1=dropdown1.selected.value&& port1=dropdown1.selected.value, slot)It finds eligible records in the data source based on the values in the three dropdown options and returns a value with the column name slot.
Best regards,
Rimmon Li
414
