Hello! Is there a way that i can have an app create a record with a variable but if the record already exists create another record with the same variable with a counted number? For example: If my variable is Red but it already exists as an ID then the app would create a new record, Red (1) or Red(2) if Red(1) exists and so on.

Hey Cole, we are releasing a feature in the next 4 weeks that would enable this functionality. Would you like to be added to the beta group?

@kevin.kononenko Was there ever a solution to this? I am trying to do the same thing. Thanks! Neil

Hey Neil, we just launched a new feature called “Table Aggregations” that will solve this. It went out in release 204. Do you have that release?

Table Record Counter

General

pte April 2, 2021, 10:35am 7

Hi, I think you will find some answers in this post : Increment table ID field from the app

Topic		Replies	Views
How to prevent user from entering same number again (How to increment more complex table ID's) General tulip-tables	8	1720	March 10, 2023
Can't Create Table Record Via App Support, Troubleshooting, & Help apps	2	972	March 16, 2023
Handling record creation error Support, Troubleshooting, & Help	7	681	May 11, 2021
Issues with auto-Incremental Id General tables , query , aggregation	1	107	May 20, 2025
Automations Action Type : Create Table Record Product Suggestions automations	1	228	April 3, 2024