Forum Discussion
MarceloBenavide
2 years agoQrew Cadet
Are you sure that submit method work with several Concat url?
Marcelo Benavides Torres
- IvanWeiss2 years agoQrew CaptainThat is why I posted :) Cause it is not working so something is wrong in there....
------------------------------
Ivan Weiss
------------------------------- MarceloBenavide2 years agoQrew CadetHi. Ok , I'm sorry, I think that you need check the several url in the submit call.Marcelo Benavides Torres
- IvanWeiss2 years agoQrew CaptainI could be wrong but I am fairly certain I have that right. because the app navigates to the home page of the other app. It just doesnt execute the new record and navigate back to the original app. I think it has to do with the app switching.
------------------------------
Ivan Weiss
------------------------------
- MarkShnier__You2 years agoQrew ChampionOn issue is this line needs to be URLEncoded because the text has spaces in it. Does that fix the problm?
"&_fid_6=Review Expense Report" &
"&_fid_6=" & URLEncode(Review Expense Report") &
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- IvanWeiss2 years agoQrew CaptainHi Mark, thanks for jumping in. That did not fix it. Same issue. here is my updated coded with that update and a couple other tweaks I tried:
//Button Styling:
var text decoration = "text-decoration: none;";
var text bgColor = "background: #009bce;";
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);
//UrlOne: Change Status of current expense report to In Executive Review
var text URLOne = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
[AppToken] &
"&_fid_6=" & URLEncode("In Executive Review");
//URLTwo: Assign a task to Executive Approval in Team Elite App
var text URLTwo = URLRoot() & "db/bpmv2s5ny" & "?a=API_AddRecord=" &
"&apptoken=hidden" &
"&_fid_6=" & URLEncode("Review Expense Report") &
"&_fid_8=" & URLEncode(Today()) &
"&_fid_9=" & URLEncode(WeekdayAdd(Today(),1)) &
"&_fid_24=Assigned" &
"&_fid_28=" & URLEncode("Not Applicable") &
"&_fid_52=" & URLEncode("iweiss@elitestudioe.com") &
"&_fid_69=" & URLEncode([Related Team Member]);
//Display the expense report record
var text URLThree = URLRoot() & "db/bspk82e7" & "?a=dr&rid=" & [Record ID#];
//Combine the URL
var text URLCombined = $URLOne &
"&rdr=" & URLEncode($URLTwo) &
URLEncode("&rdr=" & URLEncode($URLThree));
//Check if the receipts required are uploaded
var bool ReceiptsCheck = If([# of Expense Records over 75 without Receipts]=0,true,false);
//Check if I am in the correct status for the button to appear
var bool StatusCheck = If([Status]="Not Submitted",true,false);
//Display the button only if all required receipts are uploaded. Otherwise display error text.
If($ReceiptsCheck=false,"Please upload missing receipts",
If($StatusCheck=true,
"<div><a style='" & $styleOptns & "' class='Vibrant' href='" &
$URLCombined &
"'>Submit Expense Report</a></div>","Processing Report"))
------------------------------
Ivan Weiss
------------------------------