Auto populate cells

Hi,
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
thx

What about something like this?

Hi @Dr_Leandro , nice to meet you! :wave: Welcome to the community :slight_smile: :honeybee:

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):

Screen Shot 2021-07-06 at 7.26.56 PM

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! :honey_pot:

frist, @justin.stirling thx for stepping up...
second, to @Alyssa and the specialists team.... AWESOME job and thx for the time u took for that...
case closed

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.