Setting variable from button action requires two clicks

[gs_hillmm]

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

[Nicole-Smith · Accepted solution]

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).

[gs_hillmm]

Thanks for the quick response. That is exactly what I need.