Forum Discussion

Qrew Trainee

3 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

MarkShnier__You

Qrew Legend

Can you post your current code? Is the advanced settings for your table set to save parent automatically

"Auto save when redirected away from the page"

Your workflow that you were sitting on a parent record editing the parent record and then clicking submit which is supposed to save the parent record and add a child record? When they press submit where do you want to land the user?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

BethanyHudson

Qrew Trainee

3 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
Qrew Legend
3 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
  Qrew Trainee
  3 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
  ------------------------------