Increment table ID field from the app

[pte]

Hello All,

I think this topic is great to continue working on and I want to summarize here for future reference what is possible now with Queries and Aggregations (without connectors)
For example if someone wants an id such as : Text-{year 2 digits}-{sequential number per year}, I will share a way to do so :

1. Prepare your table and add a year field for easy queries :
   

2. Create query per year :
   

   

3. Create aggregation (count) :
   

   

4. Load query and aggregation in your app (+ create a record placeholder it will be useful) :
   

5. Format the current date as needed when app is started using Format_Date_TZ :
   

   

6. You have everything for your id (if you want to start from 1 and not 0 you will need one more data manipulation to increment the value from table aggregation) :
   

   

Results :