Forum Discussion

RaymondSakar's avatar
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

  • Here is generic syntax for executing successive API calls is this

    & "&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 = .......;

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

    Mark Shnier (Your Quickbase Coach)