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.

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.

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])