Hi. When filling out a form is there a way to...

(PDM Business Support) #1

Hi. When filling out a form is there a way to store any of the values from the previous form submission?

(Reza Raoofi) #2

Yes, if several values in the new submission are supposed to be identical to the previous entry, you could use an action button that copies a particular row into a new row; see screenshot below:

(Reza Raoofi) #3

Another more advanced method that gives you more control would be to use MAXROW(…) function in a Virtual Column, and then enter [Virtual Column Name].[RequiredColumn] in initial value of any column that should be pre-filled with previous row’s data.

Check out the document below: https://intercom.help/appsheet/expressions/functions/maxrow

(PDM Business Support) #4

Thank you Reza. I will take a look at both options.