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

MeredithMoore2
Qrew Member
3 years ago
Gotta post that working code bro! :)

------------------------------
Meredith Moore
------------------------------
- IvanWeiss
  Qrew Captain
  3 years ago
  That will cost you!
  
  var text baseurl = URLRoot() & "db/"& Dbid();
  var text purchTbl = $baseurl & [_DBID_PURCHASE_ORDERS];
  var text editRecord = "?a=API_EditRecord&apptoken=" & [EliteApptoken] & "&rid=" & [Record ID#];
  var text LABEL = "Executive Approval";
  var text decoration = "text-decoration: none;";
  var text bgColor = "background: #0044cc;";
  var text txtColor = "color: white;";
  var text txtAlign = "text-align: center;";
  var text txtShadow = "text-shadow: none;";
  var text border = "border-radius: 5px;";
  var text padding = "padding: 8px 20px;";
  var text display = "display: inline-block;";
  var text font = "font: normal 700 24px/1 'Calibri', sans-serif;";
  var text styleOptns = List("", $decoration, $bgColor, $txtColor, $txtAlign, $txtShadow, $border, $padding, $display, $font);
  var text mailto = "mailto:" & [Manufacturer - PO Submission Email] &
  If([CC PO Submission Email] != "", "?cc=" & [CC PO Submission Email],"") &
  "?subject=Purchase Order&body=Please review the attached Purchase Order and confirm receipt.";
  
  If([Old PO], "",
  If(IsNull([Executive Review On]) and IsNull([Project Review On]),
  "<span style= 'font-family:Calibri;color:#57a3f0;font-size:14px'><Strong>Requires Executive Approval</Strong><br /></span>",
  "<div><a target='_blank' style='" & $styleOptns & "' class='Vibrant' href='"
  & $baseURL & $editRecord &
  "&_fid_40=" & Today() & "&rdr=" &
  URLEncode($mailto) &
  //URLEncode("&rdr=" &
  //URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) &
  "'>Submit PO</a></div>"))//)
  
  ------------------------------
  Ivan Weiss
  ------------------------------
  - FraidyJacoby
    Qrew Trainee
    2 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
    ------------------------------

Forum Discussion

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