Forum Discussion

RaymondSakar's avatar
RaymondSakar
Qrew Cadet
2 years ago

URL button to run import, edit record and then redirect

Hey Quickbase Community!

I'm trying to build one URL button that can:
1. Check a checkbox on a record 
2. Run an import via the Run Import API
3. Redirect to a report in a different table

I can get parts of this workflow to work but can't get all three. For example I can check a box and redirect. I can run the import and redirect.

Will one button allow me to do the both the import and edit? 



------------------------------
Raymond Sakar
------------------------------

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago
    Here is generic syntax for executing successive API calls is this




    $URLONE
    & "&rdr=" & URLEncode($URLTWO)
    & URLEncode("&rdr=" & URLEncode($URLTHREE))
    & URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))
    & URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE))))
    & URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))
    & URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSEVEN))))))

    In your case you want to grab off the first three lines in bold after defining above that, the three URL formula variable API calls to run.

    var text CheckBox = .......;
    var text RunImport = .......;
    var text DisplayReport = .......;


    $CheckBox
    & "&rdr=" & URLEncode($RunImport)
    & URLEncode("&rdr=" & URLEncode($DisplayReport))



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------