In the “Reset on edit?”, what does the initial value refer to? Is it the first value that was entered when the row was created? or what is set in the initial value?
I need the “Reset on edit?” to be triggered only when a specific column changes(not row change)
You can use the initial value of “” if you want the cell to be reset to blank, and then within the Reset on Edit formula you can then create a trigger.
For instance, if you want the cell to reset to blank when column A has the value of ABC then try the following within the formula field:
This will then trigger the reset.
Hope this helps.
This definitely helps in setting the initial value, but on the trigger part - it is not exactly what I want
Case Scenario - I have like 5 dependent dropdowns all dependent on the main column. now, I want to reset the the “minor” columns after I change the value of the main/first column.
I was hopping to trigger the reset if only if the first column changes to a different value
I would expect Reset on edit to take effect when the app user enters a form, not as the user makes changes within the form.
I would expect Reset on edit to apply the Initial value expression to the column when the user enters the form.
Normal behavior for the Initial value expression is that it will be continuously reevaluated as the user interacts with the form, until and unless the user interacts with that column itself. Once the user interacts with a column subject to an initial value, the initial value expression will no longer be reevaluated, leaving the user’s input to the column unmodified.
In that case, I don’t really see the benefit of having an expression to trigger the “reset on edit” function. unless I didn’t understand how it exactly works
To solve the same issue, how can I have an action trigger immediately a specific column changes? - Is there a specific expression I can use to record change in a specific column?
Actions cannot be applied to forms at all. The best you can do within a form is make use of initial values and app formulas.
Not an expression, but you can use a Change column to track changes to specific columns.
Actually you can do that with a couple of tricks. Please take a look at my sample app below. Scroll down on the home menu untill you see the deck item Maurice Whelan. Click on it and you will see a table menu with one record. Edit that record and change the DATE_FOR_TREATMENT field. You will notice that, the new value will be added to the list of CHANGED_DATES. This was a community query by @MauriceWhelan who was asking if he can keep track of date changes in a particular table of his app.
You are free to download this app from my portfolio > https://www.appsheet.com/portfolio/245151
@Jeremy_F I believe you are looking something like this.
Write a formula into the “Reset on edit”…
It will reset your column’s value as you had it in the beginning every time when you change SpecificCol’s value. If the initial value is set as blank, it will clear that column when you modify SpecificCol’s value.
This is almost the exact expression that I need, but I have set the “reset on edit” with the expression more than 10 times, and saved the new changes. When I open the column, the expression isn’t there
Basically, it seems “reset on edit” behavior doesn’t support expressions
N.B - I am viewing this data on a detail view and I have set initial value as blank
Kindly check if the “reset on edit” behavior actually supports expressions or it is a bug
What was the expression you tried? I tested the functionality and it’s working correctly.
I derived my repression from your example, and used LOOKUP([_THISROW].[Uniqa],Filter,Uniqa,Analyze_Data)<>[Analyze_Data]
However, when I save and check the column again, the “reset on edit” is ON, but there is no expression
When you save the formula and it resets the field, you can check the reason from Info > Errors > Warnings.
Thanks for that tip, but there are no errors
The column is a enum type, and the view is detail.
To be sure that the problem is not with the other “update behavior” functions, I used a condition “False” on both “require” and the “reset on edit”.
The “require” maintained its expression, but the “reset on edit” shows ON, but without the “False” expression
Would you please take a printscreen…
I have tested it again, and still same issue - it resets to a universal “reset on edit”
When I use the expression on a text type column, it retains the expression
In my ideal case, it an enum type column with select function on the validif - When I use the same expression, it resets to the universal “reset on edit”
I was able to reproduce the same behavior. It seems that it won’t work with Enum field. You can though use the text field with a Valid_If formula as a workaround. I will check what could be the reason for this behavior.
It should work but for some reason it’s not doing this in a correct way. I asked our developers to check this one.
Thanks, I almost thought I am doing something wrong