Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a requirement when there are no values selected , need to popup a error message saying that 'no values are selected when we click on a button.
when i click on Go to step3 button, if there are no values selected in Person Id,Agent it should not go to next step and popup a message saying no values are selected.
Hi Harini,
You have to add condition in action tab of button,
=if(GetSelectedCount([Your Filter])>0,'SHEET_ID','Please Select a Value')
Similarly you can display a message in button as
=if(GetSelectedCount([Your Filter])>0,'Next','Please Select a Value')
Also attaching a sample file for your reference. Hope this helps you
Thanks,
Partha Kulkarni
Hi Harini,
You have to add condition in action tab of button,
=if(GetSelectedCount([Your Filter])>0,'SHEET_ID','Please Select a Value')
Similarly you can display a message in button as
=if(GetSelectedCount([Your Filter])>0,'Next','Please Select a Value')
Also attaching a sample file for your reference. Hope this helps you
Thanks,
Partha Kulkarni
Hi Harini,
take a look at my attachment.
The two buttons might be place one on the other to seem one unique button.
Let us know.
S.
Harini,
did one of the solution solve your issue?
If yes, remember to mark an answer as correct.
S.