topic Re: Set variable value when filter is applied. in App Development

Set variable value when filter is applied.

sgagliardi — Thu, 13 Jun 2019 15:06:31 GMT

I have a table of 5 columns, with 5 additional columns that can be toggled on by QS Variable.

The toggles are button objects that just set a variable to 'on' or 'off' and the appropriate column in the table displays when the variable is set to 'on'.

What I would also like to do is set this variable value to 'on' when a specific filter is used. For instance, one of the 5 additional columns is a date field. I would like for it to display (variable set to 'on') when a specific filter is used that pertains to date.

Any advice?

Re: Set variable value when filter is applied.

Lauri — Thu, 13 Jun 2019 20:10:34 GMT

One idea: Use the sheet Navigation extension (https://github.com/stefanwalther/sense-navigation) to put a button on the sheet, and instruct the user to click it. The extension lets you set an action to set a variable value with no navigation behavior.

Re: Set variable value when filter is applied.

ss09 — Wed, 15 Nov 2023 15:20:27 GMT

Can you do it not on a button but on a filter change for example?

Re: Set variable value when filter is applied.

vincent_ardiet_ — Wed, 15 Nov 2023 15:58:47 GMT

If you don't need your button to change but the column to be displayed, just add "Or GetSelectedCount(myField)>0" in your display condition.