Forum Discussion

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

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

Try just this

URLRoot() & "db/" & [_DBID_TIME_CARDS] & "?a=API_EditRecord&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
& URLEncode ([Max Check-In Time Card Record ID # for Current User])
& "&_fid_33=" & URLEncode(Now()) // 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#]))

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

ThomasEasterli1
Qrew Trainee
5 years ago
Your suggestion is to add a blank line in the code to separate the table's actions?

Well, I tried it and it was unsuccessful.

------------------------------
T$
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  No, my suggestion was to only use this code and forget the javascript stuff and var URL=
  
  The extra space was to just mentally separate the two steps.
  
  URLRoot() & "db/" & [_DBID_TIME_CARDS] & "?a=API_EditRecord&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
  & URLEncode ([Max Check-In Time Card Record ID # for Current User])
  & "&_fid_33=" & URLEncode(Now()) // 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#]))
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------
  - ThomasEasterli1
    Qrew Trainee
    5 years ago
    Thank you for the clarification.
    
    Yes that worked as the js was overriding the previous call.
    
    ------------------------------
    Thomas Easterling
    ------------------------------