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

Kolbi_Christian · 01-16-2018 04:00 PM

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_Christian

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.

tony1

@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-increme... Most Recent Value - Initialize forms with most recent value appsheet.com

AIZUDDIN_ABD_AZ

hi, do you have sample apps for this? im not familiar with [most recent row] expression. is it the same as select expression?

Kolbi_Christian

This is perfect thanks!!

Kolbi_Christian

Got it to work!

Ksenia1

Hi! Is there an update to this question as the linked pages don’t exist anymore?
@tony

Thx in advance!

Steve

What are you looking for?

Ksenia1

I am looking for a way how to auto fill a ref-type column in a form with the previous entry’s information.

To give you more background info: I am working on an employee evaluation tool. After an employee has evaluated his performance, the information will pop up at the manager’s deck view (with all of his employees who have filled out their forms). Afterwards, the manager shall give his answer to each evaluation. When I click on the action icon next to one of the employees in that manager view, I still have to choose the employee in my answer form. It would be nice if that field was auto filled depending on my chosen person.

Steve

Auto-filled with what?