Preventing an app formula / InitialValue firing when a row is copied

[Jake_Naude]

Hi,

Please could someone advise if it possible to prevent an app formula and or an InitialValue firing when a row is copied?

I have a VC app formula called max_branch_number that looks for the MAX “branch number” in three columns of the survey table:

MAX(
survey[branch_number]+
survey[branch_A_number]+
survey[branch_B_number]
)

The survey form has two app formulas that say [max_branch_number]+n to give me the next available branch number:

IF(
[branch_A_decision] = “Yes”,
([max_branch_number]+1),[branch_A_number]
)

IF(
[branch_B_decision] = “Yes”,
([max_branch_number]+2),[branch_B_number]
)

An on-form-save action then creates n copies of the form.

Each time the row is copied, the formula fires again and the numbers change.

I’d like just the values to show in the copied rows so that they have the same “branch number” as the ‘parent’ row.

The final twist is that, while rows are being added, the parent row calculations are correct. After the last row is created the action visits the first row again and the formula fires once more and I end up with changed numbers!

Is my issue related to how I’m creating my additional rows?

Grouped action for on-form-save

Action for first row:

Action for last row:

Thanks in advance for any pointers…

Cheers…