Hi Everyone,
I have three Parameters Country, State, City . I want State and city needs to hidden until Country is selected. City needs to show up only after state is selected.
I achieved this. But if I select all country the city is showing up.
I have applied rules.
Kindly please help.
Hi
It’s simple just add your control on the sheet and click on edit control by selecting relevant values only you can achieve your desired output.
Hi,
I have achieved this. I want city parameter needs to be hidden until value from state parameter is selected.
Hi @Vidhya,
After some testing on my end, I found a way to implement this with a limitation. For this implementation, you’ll need to set up in free form. Once you’ve added your parameters and controls and moved them within the sheet, setup a rule in format options for the State and City Controls (See attached screenshot for example).
This works great when filtering down from Country to State to City. You just have to remember to set ‘State’ back to ‘All’ before setting ‘Country’ back to ‘All’.
Conditional rules only allow for OR statements when populating more than one check so you can’t test for both scenarios. Since this is a limitation, I will tag this as a feature request.
Let me know if you have any remaining questions, otherwise I will archive this topic for our support team.
Thank you!
Thanks! @duncan. I just implemented this scenario with the limitation as you mentioned. Thanks for replying back and tagging this as a feature request this would be very helpful.
Regards,
Vidhya.
