Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want the field 'BU Group' to automatically select a particular value when the 'Ultimate Customer' cyclic group is selected. How do I achieve this? Thanks!
What is that particular value you want the BU Group to select. ?
May be write like in a trigger -> Actions -> Select in Field -> BU Group
= IF(GetCurrentField(YourGroupName) = 'Ultimate Customer', 'YourBUGroupvalue')
Hi.
I tried similar in using one of my cyclic group but going different value in cyclic group is not being treated as select or change so trigger-action is not getting associated.
BR,
Vijay
Where are you selecting the trigger? Sheet properties?
its in document properties
Hi Chandni,
The Cyclic group doesn't show up in fields but I've inline table on which I had created cyclic group. I was using it. Its value does show up in fields section on triggers tab,
Please see screenshots below.
No in document properties. But create a variable first then use variable event trigger on OnChange
LIke create a variable like
Ctrl+Alt+V
vChange = IF(GetCurrentField(Cyclic1) = 'ProblemDetail', 1, 0)
In document properties Triggers tab use like
Change the field names accordingly.
Tried it, not working. What am I doing wrong?
Oh okay, will try with the variable.