Does anyone know how to add a field to the fo...

(Katie Loving) #1

Does anyone know how to add a field to the form app that allows you to see what you entered the previous date?

Example if I had a reading on 2/14/2019 of 12345, How would I make that appears on my entry for 2/18/2019? I want the users to be able to see what the previous reading was.


(Bellave Jayaram) #2

Assuming there’s one reading for each day, put in initial value this formula : Any(select (Table [Column], [_RowNumber]=Max([_RowNumber])))

(Katie Loving) #3

There is only a reading every 7 days.

(Katie Loving) #4

Any(select(Table Name[Column],[_rownumber]=maxrow(Table Name, Column Name) ))

(Bellave Jayaram) #5

This should work also: Any(select (Table [Column], [_RowNumber]=Max(Table [_RowNumber])))

(Aleksi Alkio) #6

Mr Jayaram, would it better to use Date field instead of RowNumber? Sometimes records are not in correct order in your spreadsheet… for example if the record is created yesterday, but it’s saved today. With the RowNumber you are then reading the wrong record.