Append subsequent field value from a column for each new record?

Topic Labels: Automations Data Formulas Sync
244 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I have a client that needs to take a list of passwords and assign the next one off the list to each new record as it is added to Airtable via Zapier. Each new record would get the next password from the list (well, column, really).

New User 1 | Password 1
New User 2 | Password 2
New User 3 | Password 3

If I'm not mistaken, I cannot simply prefill that column in my table, leaving the other columns blank, because new records would just be created as a new row below the final password row, ignoring that the other columns are blank. 

Is what I'm trying to accomplish possible? Thanks for the help!

- Phil

0 Replies 0