Hi,
I hope someone can help with this.
I have 3 dropdown boxes DD1,DD2 and DD3. If i select any of the dropdown the other 2 should show the based on the first selection. there is no order for selecting the dropdown. if i select dd1 then dd2 and dd3 should show values from the table where dd1=dd1.selected.value. Is it possible?
Any help would be appreciated.
Thanks
Solved! Go to Solution.
Hi @kanchankolekar ,
You cannot have "circular references" or controls that are dependant on each other (or in a returning sequence) for their values
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
@Divya_Vishnu Once you filter DD1 that is Dropdown then the result which is produced by DD1 you can use to filter DD2 that is DropDown2 just need to use a formula for DD1 is like - filter(Datasource, Column_name) and for DD2 - filter(Datasource, coulmnname= DD1.Selected.Result).
Please give this a try. Thank you
@kanchankolekar The issue is not always DD1 is selected first, sometimes DD2 is selected and then i need DD1 and DD3 values filter in the dropdown according to that. If DD3 is selected first then DD1 and DD2 should be filtered.
Hi @kanchankolekar ,
You cannot have "circular references" or controls that are dependant on each other (or in a returning sequence) for their values
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.