Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a trigger on my sheet (ex: OnActivateSheet - isTestFlag =1 )
When i hit on clear button it clear the trigger. I try adding action on clear button properties as clear other fields - isTestFlag, it gets and 1 and 0 values for this field.
How to handle this, is there any expression in the button action to control this ?
Thank you.
Hi,
Could you please describe what exactly you are doing.
Regards,
Kaushik Solanki
I have field like 'isTestFlag' in my Data model which set that flag = 1 on a condition like region ='US' .
we get all the data to the application but on a selected sheet we want to get only the US data with out using filters, which i have done using the onactivatesheet trigger when isTestFlag = 1.
but when i click on clear button (which has action - clear other fields , field = currency ) it wipesout the trigger filter and gets all the data.
i added the same inselectfield action on the button. that worked.