Can I copy User-List field from one record to another? I need to create a Formula URL that will copy a user list field from one record to a new record in the same table.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

I am using the basic "add record" type button that uses the API_GenAddRecordForm call to create a new record in the same table and copy over the List-User field value. 

Photo of Jeff

Jeff

  • 332 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of John Michael

John Michael

  • 20 Points
Hey Jeff,

Unfortunately copying the value of a list-user field with an API won't bring over the value.  What you can do is us the API to create a new child record and relate it to the parent, while bringing down the list-user a lookup field.  This is the closest native functionality we can get with QuickBase.  If you run into any issues with this process feel free to open up a support case and one of our support reps will reach out to you.
Photo of QB Development

QB Development

  • 330 Points 250 badge 2x thumb
I did this by converting the original User-List field to a list of user emails, converting that list of user emails to a text, and importing the text list of emails into the target User-List field in my child record. Formula here:

URLRoot() & "db/" & [TABLE ID HERE] & "?a=API_GenAddRecordForm&_fid_[TARGET FIELD ID HERE]="   &ToText([Assign To User Emails])&   "&_fid_6=" & URLEncode ([Job #])& "&z=" & Rurl()


[CREATE NEW FIELD] = UserListToEmails([YOUR USER LIST FIELD HERE])