ThomasEasterli1
5 years agoQrew Trainee
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 click of button, two basic functions are preformed:
1) Adds necessary info to the child TIME_CARDS table.
2) Loads new record form for child (table 3 child) TASKS_CHECK_OUTS table and pre-populates a few fields in said form.
There has been several unsuccessful iterations of the code. Currently the code is as follows and works in that it adds the necessary info to the TIME_CARDS table. However, it does not load the correct TASKS_CHECK_OUTS form.
var text url=
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#])
)
;
If([Max Check-In Time Card Record ID # for Current User]>=1,
"javascript:" & "$.get('" & $url & "', function(){" & "location.reload(true);" &
"});" & "void(0);"
)
Please advise.
------------------------------
T$
------------------------------
It's been requested that upon click of button, two basic functions are preformed:
1) Adds necessary info to the child TIME_CARDS table.
2) Loads new record form for child (table 3 child) TASKS_CHECK_OUTS table and pre-populates a few fields in said form.
There has been several unsuccessful iterations of the code. Currently the code is as follows and works in that it adds the necessary info to the TIME_CARDS table. However, it does not load the correct TASKS_CHECK_OUTS form.
var text url=
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#])
)
;
If([Max Check-In Time Card Record ID # for Current User]>=1,
"javascript:" & "$.get('" & $url & "', function(){" & "location.reload(true);" &
"});" & "void(0);"
)
Please advise.
------------------------------
T$
------------------------------