Skip to main content
Question

Return to default edit parent form for user's role when saving a child record. Multiple forms.

  • Jun 9, 2021 10:13 PM UTC
  • 0 replies
  • 53 views

I have multiple forms for the parent record, the add record form is the same for all roles and is also the view/edit form for some roles but for other roles the view/edit form is different. Currently, I'm using the default formula: URLRoot() & "db/" & [_DBID_ADD_DEPARTMENT_UNIT] & "?a=API_GenAddRecordForm&_fid_6=" & URLEncode ([Record ID#])& "&z=" & Rurl()

But, when the user's default edit form is not the add form, it is returning to a blank add form. When adding a child, I need to return to the add form, in edit mode, regardless of the user's role.

Any ideas?

------------------------------
Sherry Blackburn
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
I gather that you are sitting on a Parent record and want to add a child and then return to the parent record in edit mode on a particular form.

Try this for the Add Child (Add Department unit) button.

var text AddDeptUnit = URLRoot() & "db/" & [_DBID_ADD_DEPARTMENT_UNIT] & "?a=API_GenAddRecordForm&_fid_6=" & URLEncode ([Record ID#]);

var text ParentInEditMode =  URLRoot() & "db/" & dbid() & "?a=er&rid=" & [Record ID#]
& "&dfid=2";

$AddDeptUnit
& "&NextURL=" & URLEncode($ParentInEditMode)

replace the "2" with the form number of the Parent table that you that you want to land the user on.   

In my mind & "&dfid=2";
 
means

"Da Form ID is 2"



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