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
Sorry, bothced it in the copy. 

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

"&rdr="&

URLRoot() & "db/" & [_DBID_APPOINTED_LEADS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([Agency Name])& "&z=" & Rurl())
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    You just need to use a "URLEncode()" for the RDR portion.

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &    "&AppToken=buawcnbd5pjszvdimycfs3jdpzd"&
    "&rid="&[Record ID#]&
    "&_fid_107="&URLEncode(User())&
    "&rdr="&
    URLEncode(URLRoot() & "db/" & [_DBID_APPOINTED_LEADS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([Agency Name])& "&z=" & Rurl())

    That should do it for you.
  • MannyCruz's avatar
    MannyCruz
    Qrew Assistant Captain
    9 years ago
    Yes! Thank you so much, it worked!