Skip to main content
Question

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.

  • March 14, 2016
  • 0 replies
  • 41 views

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. 

This topic has been closed for replies.

  • ArchiveUser
  • Registered
  • March 16, 2016
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.
  • QBDevelopment
  • Registered
  • February 17, 2018
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/" & & "?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])
Terms & ConditionsAccessibility statement