Can I populate a field with variable

[James_Samuel]

Assuming I can create a variable (in this case the current record’s job number) can I populate the job number field in the next record with it?

[Aleksi]

Yes you can do that for example with thecombination of MAXROW() expression and Initial value. Check this article…

help.appsheet.com

MAXROW()

Row with greatest value in column