Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've searched the forums for a similar thread but haven't found an answer.
A section of my UI allows users to either enter their own 'threshold' through the 'Threshold amount' input box or select one of two buttons that post pre-determined values - 'reversing' (value = 1000000) and 'permanent' (value = 10000). These text values are in a table and the numeric threshold value is in the same row as the text.
_PorRlabel | ThresholdAmt |
---|---|
Permanent | 10000 |
Reversing | 1000000 |
The buttons are text boxes formatted with an image. The actions assigned are:
Actions | Field/Variable | Search string/Value |
---|---|---|
Select In Field | _PorRlabel | ='Reversing' |
Set Variable | vCurrentThreshold | =Only(ThresholdAmt) |
The first time the button is clicked, it selects the correct value in the _PorRlabel field and set analysis in a straight table responds accordingly. However, vCurrentThreshold doesn't get set to the correct number unless the button is clicked a second time.
Thanks in advance..
Dave
All Variables get set before any Select in Fields happen (no matter what order you have them in the actions dialog). To get around this, change your set variable search string to =Only({<_PorRlabel={'Reversing'}>}ThresholdAmt).
All Variables get set before any Select in Fields happen (no matter what order you have them in the actions dialog). To get around this, change your set variable search string to =Only({<_PorRlabel={'Reversing'}>}ThresholdAmt).
Thanks for the quick response. That is exactly what I need.