Forum Discussion

JamesCarr's avatar
JamesCarr
Qrew Cadet
11 months ago
Solved

API_AddRecord Then Redirec To Dashboard

Greetings,

I have been searching and experimenting for some time now.  I have given up and decided to try posting, as everything I have found is not working so far.  I have a dashboard that I would like to add a button to.  The button is intended to make an API_AddRecord call and then return to the dashboard.  I can get the API_AddRecord URL together and it works as intended.  The desired record will be added successfully.  I have the URL to bring up the dashboard as well.  What I can't get to work putting them both in a formula URL that will return the page to the dashboard after the call is made.  Can someone give me the structure for how this is to work?  Thank you in advance for any input / direction you can provide.

James

api
  • JamesCarr's avatar
    JamesCarr
    2 days ago

    I finally picked this back up and just wanted to advise of the solution:

    Dashboard URL needs to be constructed a particular way, otherwise, you won't be redirected back to it.  As I stated, I was able to come up with the URL for calling the API_AddRecord, but I couldn't get it to navigate back to my dashboard instead of showing the XML result of the API call.  I discovered that I had to use:

    <Your_URL_For_The_API> & "&rdr=" & URLEncode(URLRoot() & "/nav/app/" & DBID() & "/action/showpage?pageID=" & YOUR_PAGE_ID#)

    This works perfectly.  I was already using the suggestion above to put together my URL by using a formula text field to come up with everything.  Then I copied the resulting URL text and pasted into the URL of the button widget I added in my dashboard once I saw the resulting link worked.  I hope this helps anyone else who needs it in the future.  Let me know if I can help in anyway. 

9 Replies

  • JamesCarr's avatar
    JamesCarr
    Qrew Cadet
    2 days ago

    I finally picked this back up and just wanted to advise of the solution:

    Dashboard URL needs to be constructed a particular way, otherwise, you won't be redirected back to it.  As I stated, I was able to come up with the URL for calling the API_AddRecord, but I couldn't get it to navigate back to my dashboard instead of showing the XML result of the API call.  I discovered that I had to use:

    <Your_URL_For_The_API> & "&rdr=" & URLEncode(URLRoot() & "/nav/app/" & DBID() & "/action/showpage?pageID=" & YOUR_PAGE_ID#)

    This works perfectly.  I was already using the suggestion above to put together my URL by using a formula text field to come up with everything.  Then I copied the resulting URL text and pasted into the URL of the button widget I added in my dashboard once I saw the resulting link worked.  I hope this helps anyone else who needs it in the future.  Let me know if I can help in anyway. 

    • Mez's avatar
      Mez
      Qrew Assistant Captain
      18 hours ago

      With the new navigation url schema, you could also just redirect to the app overview so that if you have different dashboards for users/roles, it will land them on that one. 

      <Your_URL_For_The_API> & "&rdr=" & URLEncode(URLRoot() & "/nav/app/" & AppID() & "/action/appoverview"

  • MarkStrassel's avatar
    MarkStrassel
    Qrew Cadet
    11 months ago

    I use something like this for a Rich Text Button, but you can adapt it for a Formula URL field too.

    var text returnURL = URLRoot()&"db/"&[TABLE_ID]&"?a=er&apptoken=xxxxx&rid=" & [Record ID#];

    var text url = URLRoot() & "db/" & [TABLE_ID] & "?a=API_AddRecord&apptoken=xxxxx&rid="&[Related Record]& "&rdr=" & URLEncode($returnURL);

    var text buttonText = "What the Button Says";

    "<a class='SaveBeforeNavigating' style='"& [Orange Button] & "' href='" & $URL  & "'>" & $buttonText & "</a>"

    • JamesCarr's avatar
      JamesCarr
      Qrew Cadet
      11 months ago

      Hello,

      Thanks for replying and sorry for the delayed response. I can't put this in a button on a dashboard though, right? When I select a button bar, I only see URL as the appropriate option.  Nothing else is for a formula. I did use a formula rich text button from a different table to generate the desired URL, so I could copy and paste it into the dashboard button, the URL doesn't produce the desired result. 

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        11 months ago

        James,

        Can you your current formula for the button you say that works, also explain the business purpose of what the button is supposed to do?

  • JamesCarr's avatar
    JamesCarr
    Qrew Cadet
    9 months ago

    Going through my notifications and see you replied but I never saw it. I had to drop this project due to a host of other business and personal matters. If I continue to have issues when I pick this back up, I can start another thread. Thank you for always following up, and all that you do on these forums. 

  • John_Perkins's avatar
    John_Perkins
    Qrew Member
    2 months ago

    I'm having this same issue and am wondering if anyone has ever figured it out. Button on Dashboard runs the API call, but after it runs it just leaves us on the API page with the results of the call. I've not been able to set up the URL to redirect back to the Dashboard. Can't use any of the functions like RURL() because it's just a link.

    Using rdr=URL_I'm_RedirectingTo doesn't do anything. Neither does using a=doredirect&z=URL_I'm_RedirectingTo. I've tried all sorts of combinations of these and still just land on the XML results. What's the trick to get this working?

      • John_Perkins's avatar
        John_Perkins
        Qrew Member
        2 months ago

        This is a brilliant idea that I didn't even consider. Formula - URL field gives me a usable link. Whether or not it works, this is incredibly helpful! And it definitely gives me a much better method of trial and error than updating the text in Notepad.

        Thank you kind sir.