Anyone know how to auto fill a form with the ...

(Kolbi Christianson) #1

Anyone know how to auto fill a form with the previous entry’s information as a formula for the Initial Value column of the Columns tab? I’m sure it’s out there, just haven’t figured it out yet.

(Kolbi Christianson) #2

Also, can I auto-increment a number compared to the previous row’s number in the same column? In other words, when I submit a form, the initial value of the form the next time I open it is, for some columns, the same value as the previous record, and, for other columns, the previous value + 1.

(Tony Fader) #3

@Kolbi_Christianson Check this example: appsheet.com - Most Recent Value - Initialize forms with most recent value

You should be able to extend that example to put a [Most Recent Row].[Some Column] + 1 formula either in the App Formula or Initial Value.

But beware of the limitations of that approach: https://help.appsheet.com/app-design/modeling-tables-and-columns/is-it-possible-to-create-an-incrementing-number-for-each-record Most Recent Value - Initialize forms with most recent value appsheet.com

(Kolbi Christianson) #4

This is perfect thanks!!

(Kolbi Christianson) #5

Got it to work!