Most Recent Value of specific parameters

Alex_Tashlykov · 08-30-2019 12:18 PM

Hi! Hello! I’m new, help please! Can i add the last value of the row of specific parameters? For example., I have the table:

Date People fruits vegetables

25.06.2019 Stanley 5 55
28.09.2019 Ivan 6 44

I need this - Ivan will decide to add a new fruit. in the row will be - 6. Stanley will add vegetables - the value “55” will be suggested in the row of vegetables.

In this link author says simply how to add the last value of a row
https://www.appsheet.com/samples/Initialize-forms-with-most-recent-value?appGuidString=18b39921-b8a8...

please, help me)) sorry for my English))

MultiTech

Welcome!!!

Did you check out the “Look under the hood” link? If you click this you can see how the app is put together; under Data>Columns you can see there’s a virtual column that’s using the MAXROW() formula to find the last row entered.

You can read more about maxrow() here:

Then in the initial value space, they used a de-reference formula to pull values from the maxrow() result.

You can read more about de-reference formulas here: