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!