Forum Discussion

MannyCruz's avatar
MannyCruz
Qrew Assistant Captain
9 years ago

Can I string an API call to set a field to current user AND then gen add form in a different table?

I have a formula URL button linked to a different table. I want to string an API call to this so that before it links you over to the new form, it also changes a field (labeld "Marketing Rep") to the ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
i have put an application in the exchange called URL Formuals for Dummies.  It explains who to string URLs together.

But here is what should work for your example.  I like to use "formula variables" as it makes the formuals much easier to read.

var text URLONE = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &    "&AppToken=buawcnbd5pjszvdimycfs3jdpzd" &
    "&rid=" & [Record ID#] &
    "&_fid_107=" & URLEncode(User())

var text URLTWO = URLRoot() & "db/" & [_DBID_APPOINTED_LEADS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([Agency Name])& "&z=" & Rurl())

$URLONE
& "&rdr=" & URLEncode($URLTWO)