YES / NO Default value
in the table I am using a yes / no switch. How to do it so that after switching to YES or NO, the value will not be changed for the next days, until it is changed. Each value is set off by the default value until it is changed by switching
Regards
14 replies
-
Can you be a bit more specific? Nothing changes unless you tell it to so a bit more info would be helpful.
-
Heelo Fred
The table uses Local money, dollar, euro and pounds. But they are not always needed, at the beginning of the day it will be determined which currencies are needed today and which ones need to be turned off. In addition, there is a reception of money from Bank cards, Mobile money, deoptions, loans. There are many possibilities for calculation.
As I mentioned earlier, at the beginning of the day, the manager decides which payment functions will be used today, and he turns off the unnecessary ones and turns on the necessary ones.
For this there is a sub table in the table where all this is done.
In order not to do this work every day, I want that when we turn off any payment currency, it should remain off, and for the next days, until it is turned back on.
Use the switch YES/NO
If you need more information, I will gladly share with you
-
So the only way these fields change from On/Off is for someone to manually do it?
There is no formula anywhere that will change their value?
If the above is true then I don't see how the values can change until you do it? Or am I missing something?
-
Each switch has a "default value" if you do not specify which value by default it will always be "off"
-
If you want to set the default value, there is an option when you edit the field.
Does that not work?
-
Heelo Fred, Thanks for ypu time
It works, it works well. But managers do not have access as DB administrators. And they can't get there to switch. Therefore, I am looking for a formula, that makes it possible to repeat yesterday's value, but with the ability to change it.
Regards
-
So managers do not see the form with the switches?
But you want managers to have the ability to change the values on these fields?
Do you make a new record every day and you want to carry over the values from the previous day? What tables are involved? What fields are involved?
-
The manager sees exactly this field, it is they who switch. but you need to leave yesterday's value for today automatically, but with the ability to change it
-
Isn't that the same as having one record which can be updated each day as necessary?
Regards John
-
Hello John
I want, it is necessary to keep yesterday's value. For example, disable the ability to accept credit cards, this value remains by default the next day. But if the manager decides to accept credit cards, then he can turn it on.
Regards
-
Hello John, thanks for your attention and time
Not exactly the same. For example, if I put that constant value "OFF", then when you need to use this currency, you need to turn it "ON" yourself. And when you need it for three or four days in a row, then turn it "OFF" for a couple of days ... this, I want to entrust it to the manager. "OFF"and until needed, it will remain disabled until it is turned "ON", for several days. Turned "ON" and remains turned "ON" for several days until turned "OFF" -
It seems that a new record is created each day, hence the default values. How is it created? Manually, by a script, … ?
-
I also think that there must be a trigger when update function somewhere when you created the switches (did you created it or someone else?). Normally the Yes/No switch choice field won't change if you don't change it manually by clicking. So the value stays the same until you change it.
If it changes how you said regularly, then there must be some trigger with a formula somewhere which does the changes.
-
From the updatepage: 'Fields can now bind to per session memory instead of records, particularly helping you with hiding or showing additional data using Yes/No fields (All)'
Maybe that is the problem. This means that the yes/no field can be set as a temporary switch and return to his original state after leaving.
Steven.
Content aside
- 2 yrs agoLast active
- 14Replies
- 695Views