'Locking' a formula in Workflow | XM Community
Solved

'Locking' a formula in Workflow

  • 19 March 2024
  • 2 replies
  • 13 views

Badge +4
  • Level 1 ●
  • 5 replies

I have a matrix table of text entries with numeric values to be entered in each box.  In workflow, I have math operations to sum each row.  Works great thanks to help from the community!

BUT, is it possible to somehow ‘lock’ the math operation so the piped text that indicates the row number does not change every time there is an edit made to the form and published?

Below shows Nominee 2 piped in now as value ‘377’ instead of the original ‘2’ after someone made some edits and published. I now have to edit every operation so the correct new value is shown.  

 

icon

Best answer by ahmedA 19 March 2024, 22:14

View original

2 replies

Userlevel 7
Badge +21

If edits are made to the survey, you will have to update the formula. There’s no way of getting around it.

What you can look at is recode values, this will help simplifying things, but the manual update is not avoidable.

Badge +4

I figured that would be the case - I appreciate your time in getting me feedback!

Leave a Reply