Expression Help?

[thorsten.langner]

Hi @jasonh,

to Auto-Increment a Table Value (also mixed with text) is an often requested funktionality.

Please have a look if the solution in this thread helps:

How to prevent user from entering same number again (How to increment more complex table ID's)

Create a query with limit 1 and sorting new to old: [image] [image] Create an aggregation with Mode on ID: [image] Extract the string after the “-” (e.g. “01”) make it an Integer, increment it by one Check if you want to add a “0” when the number is lower than 10 and make it a string. Extract the string before “-” (or hardcode “UN-”) and add the new number-string create a record with this one… [image] Result: [Increment_table_ID] The result will be like: UN-01 UN-02 … UN-09 UN…