I’m having the app collect some data and then run it through a formula for an end result. I need to run the formula six times for each set of data. It’s a long formula and just want to swap out the specific database value for each formula.
I have already copied the text field that contains the formula once, but can’t seem to place a new variable in place of the current one. It places it at the end. The pencil icon doesn’t seem to do anything other than let me delete the value.
How can I do this without rebuilding the whole formula each time?