Forum Discussion

DanielJohnson2's avatar
DanielJohnson2
Qrew Trainee
3 years ago

How to Add Multiple Users in API_AddRecord

Hi All, I've got this in a Formula URL field: URLRoot() & "db/" & [_DBID_CHILD] & "?act=API_AddRecord&apptoken=xxxxxxxxxxxxxxx123456789&_fid_30_=" & [Record ID#] & "&_fid_47_=" & ToText([Associ...
APIs and custom code
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
Try this - we will use a semicolon delimited list to populate the field.

var text People = List(";",  ToText([Associate]), ToText([Dept Head]));

URLRoot() & "db/" & [_DBID_CHILD] & "?act=API_AddRecord&apptoken=xxxxxxxxxxxxxxx123456789&_fid_30_=" & [Record ID#]
& "&_fid_47_=" & URLEncode($People)
& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_PARENT] & "?a=dr&rid=" & [Record ID#])

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------