How can I increment a number field on a table every time I create a new record? Better describing, how can I make Ninox look up the value of a field on a previous record and adjust it for the new record?


I have used max(Field)+1 but it seems not to work.

Ninox Profile


This is just one example of many on the forum.


Thank you, it worked perfectly.