Re: Default last entry on certain data fields

A_Pay77 · 09-19-2023 01:25 AM

Hi!

I have an app to capture the characteristics of every light fitting in a building. My first 3 fields to collect data are: Inside or Outside?, Building level, Room. If there are 40 lights in that room it would be nice to not have to fill these 3 questions out for every light.

Is there a way that my app can default to the last entry answer for these particular fields? I looked at the initial value expression but this seems to stop working once you change the response.

AleksiAlkio

Something like this with the Initial value for the Room column..
LOOKUP(MAXROW("Table","_ROWNUMBER"),Table,KeyColumn,Room)

A_Pay77

Hi Aleksi,

Sorry, I'm not great at understanding formulas. Could you please explain what this formula is instructing?

AleksiAlkio

First the MAXROW() finds the latest record based on the rownumber from your table. The result is that rows key value. The LOOKUP() then finds that row with the key value as it's unique, and read your room value from that row.

A_Pay77

Room is not my "key" column. Does that mean I have to make it one?

AleksiAlkio

No. The result from the MAXROW() is always the value from the key column.