Forum Discussion

DanaHauser's avatar
DanaHauser
Qrew Cadet
5 years ago

Automation to create copies of a newly created record for each user in a certain user list field

I have a table that I want to create a record in, and then automatically duplicate the record for each user in a user list field.   So if there's 10 people in the user list field, a total of 11 rec...
Pipelines
Quickbase Automations
JustinTorrence's avatar
JustinTorrence
Qrew Cadet
5 years ago
@Dana Hauser
I would create a table of "Users" where every record has just one field filled that is a reference to the Quickbase user. Then you could uses Automations or Pipelines to trigger on the record in the table you referenced being created, copy the records from the Users table into the "duplicates" table, along with a reference back to the​ monthly drill record that triggered it.

------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------
DanaHauser's avatar
DanaHauser
Qrew Cadet
5 years ago
Thanks Justin!  I'll see what I can come up with that will work.

------------------------------
Dana Hauser
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    The other option aside from making a child table is to create 10 fields which parse out the individual users from that user list field.

    I probably have a formula for that somewhere if you decide to go that route and can't figure out the formula.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • DanaHauser's avatar
      DanaHauser
      Qrew Cadet
      5 years ago
      I ended up creating a new table for the users I want to copy records for.  This worked great.  Thanks for the suggestions.

      ------------------------------
      Dana Hauser
      ------------------------------