I have 2 tables in my base . Table 1 have multiple records while table 2 only has single record . Table 2 has a field (lets say voucher) with data type number. Whenever a new record is added in Table 1 ,I would like to Increment the value of a field (voucher ) with 1.
How to increment whenver a new record is created in Another table
+25Hi,
Link all table1 records to the table 2 record (fill first by hand, then copy-paste it to the whole column).
Use Count field type in table 2.
Create automation that will trigger in table 1 when record match condition - link is empty.
Set action - fill link field with static value (linking to the record in table2)
If you need to preserve your 'voucher' number field, add second action - copy value from count to voucher.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.