Forum Discussion

JeffRohan's avatar
JeffRohan
Qrew Cadet
10 years ago

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.

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. 
Formulas and functions
Tables and fields
Wizards and add-ons
QBDevelopment's avatar
QBDevelopment
Qrew Cadet
8 years ago
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])