topic Re: Changing Variable Value When Field Is Cleared Of Selections in App Development

Changing Variable Value When Field Is Cleared Of Selections

cgT — Mon, 24 Apr 2023 13:43:12 GMT

Hi everyone,

I have a field called 'TransactionDate' which, when I clear it, needs to change the value of a variable, vLastWeekTrans, to 0.

I'm trying to use the current expression in the variable's 'Definition' box and am not getting any result:

=if(GetSelectedCount(TransactionDate)<1, 0,1)

Thanks in advance for any help.

Re: Changing Variable Value When Field Is Cleared Of Selections

Sabrina_V — Mon, 24 Apr 2023 14:16:37 GMT

It works for me

Definition of the variable if(GetSelectedCount(TransactionDate)<1, 0,1) (without the equal sign)

Re: Changing Variable Value When Field Is Cleared Of Selections

cgT — Mon, 24 Apr 2023 14:47:52 GMT

Thanks Sabrina,

I've tried this and, once I've updated the definition, it works (i.e. it changes the variable value). I click the button again and then clear the selection and it doesn't work.

Could there be anything that overrules the definition of a variable?

Re: Changing Variable Value When Field Is Cleared Of Selections

Sabrina_V — Mon, 24 Apr 2023 14:51:25 GMT

I try multiple times and it works fine for me. Could you add your app ?

Re: Changing Variable Value When Field Is Cleared Of Selections

cgT — Mon, 24 Apr 2023 15:51:47 GMT

I can add without data if that's ok?

Re: Changing Variable Value When Field Is Cleared Of Selections

cgT — Mon, 24 Apr 2023 15:57:29 GMT

Here is the app. The variable is acting on the background and font colours in the first button on the left underneath the blue banner.

Re: Changing Variable Value When Field Is Cleared Of Selections

Sabrina_V — Tue, 25 Apr 2023 06:34:40 GMT

In your buttons you force the value of your variable vLastWeekTrans to 1 => It's clear th definition.

Two solutions :

1. In the definition of the variable put the formula if(GetSelectedCount(TransactionDate)<1, 0,1) (without the equal sign) and nothing in the button

2. If you absolutely want the action on the button : create the variable without definition and then in each button on the action on the variable put the formula if(GetSelectedCount(TransactionDate)<1, 0,1) (without the equal sign)

Re: Changing Variable Value When Field Is Cleared Of Selections

cgT — Tue, 25 Apr 2023 08:53:48 GMT

This is working really well, thank you Sabrina!

I have one button that's in an alternate state and this method isn't working for that button. Is there an adjustment I need to make when dealing with variables in alternate states?

Many thanks once again.

Re: Changing Variable Value When Field Is Cleared Of Selections

Sabrina_V — Tue, 25 Apr 2023 09:06:52 GMT

Please see this issue : LINK

Re: Changing Variable Value When Field Is Cleared Of Selections

cgT — Tue, 25 Apr 2023 12:38:57 GMT

The best solution I can seem to find is the following:

if(GetSelectedCount(TransactionDate, 'WoW')<1, 0,1)

'WoW' being the name of the state. The problem is it doesn't clear when the field is cleared of selections.

Re: Changing Variable Value When Field Is Cleared Of Selections

cgT — Wed, 26 Apr 2023 13:32:02 GMT

Hello,

I'm still unable to get the alternate state to work on the button. But I'm also having another issue. Without changing anything, I'm now seeing the button background and font changing only after a second click of the button. Also, the clearing of the field no longer sets the variable to '0'.

I've attached my app, sans data, for somebody to look at if possible please.

Many thanks for your help.