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
Right, I'm missing the ending ;

trey this

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)