Forum Discussion

kheatley's avatar
kheatley
Qrew Member
15 days ago

How should I set up this Formula URL button

I’ve been trying to set up a notification email for approvers, where when a leave request is submitted by a faculty member, approvers receive the email notification that there is a leave request pend...
formulas
kheatley's avatar
kheatley
Qrew Member
15 days ago

Ok so I am now trying to create formula in child...

Formula:
//Adds new DECISION STATUS CHANGES record with status = "Approved"

var text SIGNIN = URLRoot() & "db/main?a=SignIn";
var text apptoken = "b6w3x2vddzcyk3c8upwsnbu5vqbw";

var text APPROVED =
URLRoot() & "db/" & Dbid() &
"?a=API_AddRecord" &
"&rid=" & URLEncode ([Record ID#]) &
"&apptoken="& $apptoken &
"&_fid_25=" & "Approved" &
//"&_fid_42=" & Now() &
//"&_fid_32=" & ToText(User()) & 
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() &
"?a=dbpage&pageID=2");
$SIGNIN &
"&NextURL=" & URLEncode($APPROVED)

Ex:
https://zzz.quickbase.com/db/main?a=SignIn&NextURL=https%3A%2F%2Fzzz.quickbase.com%2Fdb%2Fbuk4s63ek%3Fa%3DAPI_AddRecord%26rid%3D456%26apptoken%3Db6w3x2vddzcyk3c8upwsnbu5vqbw%26_fid_25%3DApproved%26rdr%3Dhttps%253A%252F%252Fzzz.quickbase.com%252Fdb%252Fbuk4s63ek%253Fa%253Ddbpage%2526pageID%253D2

For some reason this is opening in the wrong table altogether, my LEAVE REQUEST table (the parent of REQUEST DECISIONS which is parent of DECISION STATUS CHANGES).  

Table #1FACULTYbuk4s62z5
Table #2LEAVE REQUESTSbuk4s623u
Table #3LEAVE TYPES LISTbuk4s625z
Table #4APPROVERS LISTbuk4s627y
Table #5REQUEST DECISIONSbuk4s629y
Table #6DECISION STATUS LISTbuk4s63bx
Table #7DECISION STATUS CHANGESbuk4s63ek



Can anyone see why it's not accessing DECISION STATUS CHANGES table? 

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    14 days ago

    I think I would do it this way.

     

    var text APPROVED =
    URLRoot() & "db/" & [DECISION STATUS CHANGES] &
    "?a=API_AddRecord" &
    "&rid=" & URLEncode ([Record ID#]) &
    "&apptoken="& $apptoken &
    "&_fid_25=" & "Approved" &
    //"&_fid_42=" & Now() &
    //"&_fid_32=" & ToText(User());

    var text LandingPage = URLRoot() & "db/" & AppID() &
    "?a=dbpage&pageID=2");

    $Approved

    & "&rdr=" & URLEncode($LandingPage)

    I'm not sure that you need that Sign On Step.

     

    If you find that you do, it would look like

    But if you do 

    $SIGNIN
    & "&NextURL=" & URLEncode($Approve)
    & URLEncode("&rdr=" & URLEncode($LandingPage))