Automatic full fill number type field in new record from number type field of previous record in same table
Ninox Profile

Is there aby way (formula) how to automaticly full fill number field with number field from previous record in same table?

I need that one field of new record will be automaticly full filled with value of another field of previous record.  

Ninox Profile

I would use an On Create Trigger..   Assume you have  a table named "Charts".   Assume that you want to copy 'Project Nbr' field of the previous record...  Knowing that IDs are sequential .. you could put the following in the Charts "Trigger on Create" 

let t := this;
t.('Project Nbr' := first((select Charts)[Id = number(t.Id) - 1]).'Project Nbr')

 

Ninox Profile

Thank you, it is exactly what I need.

Reply