Keeping data from the first record , how?

[Soufiane_M]

Hello how to keep some data from the last record to avoid retyping the same data again exemple : I have a (sales table) and these column [date] [client] [product]
1rst record: I type these data [date],[client],[product]
2seconde record: I dont want retyping again [date] and [client ] i want to be kept from the 1rst record

[School_Bus]

I haven’t tried it, but maybe you could use a lookup function, and use [row] - 1. Put it in for the initial value.

[School_Bus]

Lookup([_thisrow]-1, “table name”, “row”,“client”)

Just a guess

[Steve · Accepted solution]

You’ll need to use an Initial value expression:

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

This will get you the value of the Date column from the last row of the My Table table:

LOOKUP(
  MAX(My Table[_ROWNUMBER]),
  "My Table",
  "_ROWNUMBER",
  "Date"
)