Forum Discussion

ThomasEasterli1's avatar
ThomasEasterli1
Qrew Trainee
5 years ago

URL button to preform multiple actions in same click

Have an URL Button on a parent (table 1 parent) TASKS table that checks a user out of a task and loads necessary info into a child (table 2 child) TIME_CARDS table. It's been requested that upon clic...
APIs and custom code
Button
jasonjohnson1's avatar
jasonjohnson1
Qrew Cadet
5 years ago
Try wrapping everything inside the var text inside a URLEncode like below. This is a method that I use when doing 2 different types of API commands in a single button click so it might work here as well.  I also changed the third line data from Now() to "today" because Now() gives the time that the browser last refreshed not the actual now. 
var text url=

URLEncode(URLRoot() & "db/" & [_DBID_TIME_CARDS] & "?a=API_EditRecord&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
& URLEncode ([Max Check-In Time Card Record ID # for Current User])
& "&_fid_33=" & URLEncode("today") // check out
& "&_fid_35=" & URLEncode([WORK_ORDER - wo_number])
& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_TASKS_CHECK_OUTS] & "?a=nwr&dfid=2"
& "&_fid_9=" & URLEncode([Record ID#])
))
;

If([Max Check-In Time Card Record ID # for Current User]>=1,
"javascript:" & "$.get('" & $url & "', function(){" & "location.reload(true);" &
"});" & "void(0);"
)


------------------------------
jason johnson
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    I think, that Thomas already has it working from the post above, but I appreciate the "today" tip.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------