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 ...
MannyCruz's avatar
MannyCruz
Qrew Assistant Captain
9 years ago
The first bit, yea! I need it to edit the record I am on first, then go to the new form on a new table. 

Here is what I have so far, 



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

"&rdr="&



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

I am fairly new to QuickBase but I have become knowledgeable enough to be dangerous, but API calls are not my strong suit at all. So this may be a really bad formula