Solved: Auto fill field with data from last form submitted - Page 2

Peter_Razenberg · 10-19-2019 01:59 PM

I would like to prefill a form field with an address from the last submitted form entry. I would like to know what formula to use to get the address text from the previous submission and preferably and example how to use the formula.

Fernando_Lopez1

You need to have a “DateTime_Column” to determine wich data is the last submitted, Then create a virtual column “Last_Item”, and set this FORMULA:
=MAXROW(“Your_Table”, “DateTime_Column”)

In the INITIAL_VALUE of the ADDRESS column, set:
=[Last_Item].[Address]

P.D. Don’t forget to set Initial_Value of DateTime_Column to NOW()

View solution in original post