Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
4 years ago

URL Button Doesn't Work in Edit Mode

I've got a URL button "Submit" that creates a child record then redirects to the parent table. It works great, but I can't do it while in edit mode, which is really the place I need it. I want staff t...
APIs and custom code
Button
BethanyHudson's avatar
BethanyHudson
Qrew Trainee
4 years ago
Clicking Submit adds a child record and the user lands back to their task table.
var text add= URLRoot() & "db/" & [_DBID_AGGREGATE_TASKS]& "?a=API_AddRecord"& "&_fid_80=" & URLEncode([Record ID#]);
var text URLTHREE = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & ToText([Record ID#]);
var text Redirect = URLRoot() & "db/" & [_DBID_TASKS] & "?a=q&qid=1&rid=";
$add
& "&rdr=" & URLEncode($URLThree)
& URLEncode ("&rdr=" & URLEncode($Redirect))​


------------------------------
Bethany Hudson
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
1. Is the advanced settings for your table set to save parent automatically
"Auto save when redirected away from the page"

2. Can you clarify the desired workflow?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • BethanyHudson's avatar
    BethanyHudson
    Qrew Trainee
    4 years ago
    Yes, that setting is clicked. 
    Here is the workflow: staff member adds a task that they have completed; the submit button saves it to an aggregate table; they are redirected back to their individual tasks list table.

    ------------------------------
    Bethany Hudson
    ------------------------------