I am looking to make the initial value formula retrigger when editing a form.
The initial value changes depending on the "number of building supports" value (formula) when entering the form for the first time without issue. The problem is, this form is supposed to be reviewed and edited. When editing the initial Value formula doesn't retrigger (Even when reset on edit has been turned on).
Is there a work around for this?
Solved! Go to Solution.
Thank you for the replies. Reset on edit does work, it was my formula that didn't. I kept altering the formula till it worked. I found that I can't us an if statement that uses conditions:
when the reference column is a number type. Rookie mistakes!
What worked- [column name]<1
If you edit a column's properties, under the section Update behavior there is a checkbox "Reset on edit". If you turn that on the Initial Value formula will be run any time the row is edited.
Reset on edit, as @ali-hussain suggested, should be the solution; but I see you mentioned that didn't work already.
Simply turning that toggle on, SHOULD cause the initial value formula to "kick off" every time someone enters the form - as well as any time other updates are made as well. (Something to keep in mind)
I usually find I have to devise some clever formula inside that reset on edit, to more tightly control when I want things to reset.
You can get really clever here....
AND(
Context("ViewType") = "Form",
IsNotBlank([SOME_COLUMN])
)
------------------------------------------------------------------------------------------------------------------------------
IF(IsNotBlank([_This]),
AND(
Context("ViewType") = "Form",
IsNotBlank([Some_Column]),
NOT(IN([_This], [Some_Column].[Another_Ref].[List_From_Other_Ref_Table]))
),
[Parent_Ref].[Status] = "Open"
)
------------------------------------------------------------------------------------------------------------------------------
IsNotBlank([_this])
------------------------------------------------------------------------------------------------------------------------------
and on... and on... and on... (^_^)
Thank you for the replies. Reset on edit does work, it was my formula that didn't. I kept altering the formula till it worked. I found that I can't us an if statement that uses conditions:
when the reference column is a number type. Rookie mistakes!
What worked- [column name]<1
User | Count |
---|---|
26 | |
25 | |
25 | |
20 | |
19 |