Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
4 years ago

API Edit Record, Mailto, and a rdr or nexturl?

Hi everyone, I am trying to create a button via rich text field that will process an API call to update a record, open an email via a mailto, and redirect back to the record page I was on in one cl...
APIs and custom code
Buttons
FraidyJacoby's avatar
FraidyJacoby
Qrew Trainee
3 years ago

Hi Ivan,

I'm currently looking to achieve the same goal as you. When the button is pressed:
1. Edit the current record and update a certain field with the current date
2. Open the Send to Outlook feature in outlook
3. Return the user back to the record after the change in #1

I was not able to decipher which part of your code gets the user back to the record they were on. Can you please help me understand your code so I can replicate it and get it working on my end?

Thank you for your time.

​

------------------------------
Fraidy Jacoby
------------------------------
IvanWeiss's avatar
IvanWeiss
Qrew Captain
3 years ago
To make this easier to work with all of the early on code is just setting the variables with portions of the button functionality and styling so that later on I can make its such simpler.  This is the section of code that actually executes the work.  It obviously references those variables earlier on.

href='"
& $baseURL & $editRecord &
"&_fid_40=" & Today() & "&rdr=" &
URLEncode($mailto) &
//URLEncode("&rdr=" &
//URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) &
"'>Submit PO</a></div>"))//)

To try to step through it:

The baseURL is my app URL
Edit Records performs the edit
It processes the mailto.

I honestly do not remember why I commented out those two bottom sections (shame on me for not documenting where I left off).  I think the button just stays on the current record so I never got it working with a refresh.

------------------------------
Ivan Weiss
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    @Fraidy Jacoby
    I know it's hard to prove a negative but I'm pretty sure it's not possible to do what you're asking. Quickbase can do quite a large number of successive actions in a URL button but that assumes that at each step in the action you're running an API and then the last step typically is to land user on a record or a report for a page. 

    But in this case once you go to an external URL or open up some kind of mailto: command,  then that is going to be the end of the successive actions.  ​

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