Forum Discussion

MiriamKlugman's avatar
MiriamKlugman
Qrew Member
3 years ago

Formula URL question

I have a formula URL that I am displaying in a report.
How can I make it not redirect the user to the record and just stay on the report?

Below is my formula:
If( [End Shift Summary]>0,
"",
URLRoot() & "db/" & [_DBID_TIMECLOCKS] &
"?a=API_AddRecord" &
"&apptoken=b7h5xqhbdtch8uv5fj29dunzfbe" &
"&_fid_9=" & [Record ID#] &

"&_fid_39=" & (Now()) &
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]))

Thank you!

------------------------------
Miriam Klugman
------------------------------
APIs and custom code

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    try this

    If( [End Shift Summary]>0,
    "",
    URLRoot() & "db/" & [_DBID_TIMECLOCKS] &
    "?a=API_AddRecord" &
    "&apptoken=b7h5xqhbdtch8uv5fj29dunzfbe" &
    "&_fid_9=" & [Record ID#] &

    "&_fid_39=" & (Now())
    & "&z=" & Rurl())

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MiriamKlugman's avatar
      MiriamKlugman
      Qrew Member
      3 years ago
      I'm getting this error now

      This XML file does not appear to have any style information associated with it. The document tree is shown below.
      <qdbapi>
      <action>API_AddRecord</action>
      <errcode>0</errcode>
      <errtext>No error</errtext>
      <rid>60928</rid>
      <update_id>1623942725406</update_id>
      </qdbapi>


      ------------------------------
      Miriam Klugman
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        3 years ago
        Ah, OK I did not notice that you were usang API_ADDRecord and not just putting up an add recrd form.

        try this

        var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

        If( [End Shift Summary]>0,
        "",
        URLRoot() & "db/" & [_DBID_TIMECLOCKS] &
        "?a=API_AddRecord" &
        "&apptoken=b7h5xqhbdtch8uv5fj29dunzfbe" &
        "&_fid_9=" & [Record ID#] &

        "&_fid_39=" & (Now())
        & "&rdr=" & URLEncode($RefreshPage))

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------