Ive been trying to find a way to auto populate some cells on row creation.
For exemple, an user uses a form to fill any data, on that row, I wanted to auto add Row Id(must be sequential), date and time.
I imagine this is simple but I couldnt figure out
Hi @Dr_Leandro , nice to meet you! Welcome to the community
And thanks for chiming in, @justin.stirling , that's the right idea!
For this, you can use automations to write data into cells upon row creation. For your particular ask, I've set up an example button with an automation that will add this data when the row is created. This is how it looks:
I have a table to increment an ID number (for the unique row IDs):
And here's table of orders:
In the app, here's a button with an automation that writes NOW() for the Time Submitted column and adds 1 to the order number (based on the current order count):
There's also a second action on the automation, which increments the order count by 1:
Now every time you add a row by clicking the button, the automation writes the current time/date and a unique ID to the new row, and increases the ID counter by 1.
Hope that helps you out, and let us know if you have any other questions!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.