Hi,
I am trying to use the value from a radio button, as an input (specifically the column variable) within the LookUp function (inside a label). Would anyone be able to provide any guidance?
Context: I am building a simple test app that shows price for a car. Enter the Brand, Model, and select between Base or Full Package and the label will display a price imported from a linked excel sheet. It works fine, except the label needs to consider either "Base" or "Full package" from the radio button. The code for the label is: LookUp(Table1,Model= Dropdown_Model.Selected.Model,'Full Package').
The issue is with the final variable 'Full Package', where I would prefer to keep something like: Text(Radio_Package.Selected.Value). But this just returns "Base" or "Full Package" as the final result in the label box.
Solved! Go to Solution.
You would do this based on the radio selection in your formula:
With(LookUp(Table1,Model= Dropdown_Model.Selected.Model),
Switch(Radio_Package.Selected.Value,
"Full Package", 'Full Package',
"Base", Base
)
)
I hope this is helpful for you.
You would do this based on the radio selection in your formula:
With(LookUp(Table1,Model= Dropdown_Model.Selected.Model),
Switch(Radio_Package.Selected.Value,
"Full Package", 'Full Package',
"Base", Base
)
)
I hope this is helpful for you.
It works, Thanks!
User | Count |
---|---|
168 | |
90 | |
74 | |
68 | |
57 |
User | Count |
---|---|
214 | |
155 | |
97 | |
89 | |
70 |