Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

Pass Multiple User via URL to assign on tasks via api

I am trying to create a formula url button so that I can create a task but have majority of the fields auto filled.  One of the fields I want to programmatically set is the assignees.  I have it worki...
APIs and custom code
Forms
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Try using a semicolon as a delimiter

Here is what I have thus far:

URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_12=" & URLEncode ([Record ID#])& 
"&_fid_6=" & URLEncode("Fancy Design Proposal") &
"&_fid_28=" & "Opportunity" &
"&_fid_23=" & "Opportunity" &
"&_fid_31=" & URLEncode("user1@elitestudioe.com;user2@elitestudioe.com") &
"&_fid_8=" & URLEncode(Today()) &
"&z=" & Rurl()
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    6 years ago
    Ah so close and so simple, I should have thought of trying that.  Thanks!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    Under the covers any of those fields that look like bubbles are semi colon delimited.  So that applies to the multi select fields, and the combine text summary fields and the List User fields.