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

Question

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
------------------------------

markshnier__you · Answer

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
------------------------------

sherryblackbur1 · Answer

Thanks Mark. It is returning to the correct form in edit mode, but it is returning a blank form – not to the parent record in edit mode. I've tested it in multiple roles with the same result. Any ideas?

Sherry Blackburn | Sr. Applications Systems Analyst - Quickbase | Technology Solutions Partners

PeaceHealth | 1115 SE 164^th Ave. | Vancouver, WA 98683

Learn about Quickbase and requesting an app.

Use your PeaceHealth credentials when prompted - 3x3@peacehealth.org and your network password

Need a Quickbase consult or working session? Book it HERE.

This message is intended solely for the use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential, and exempt from disclosure under applicable state and federal laws. If you are not the addressee, or are not authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, distribute, or disclose to anyone this message or the information contained herein. If you have received this message in error, immediately advise the sender by reply email and destroy this message.

markshnier__you · Answer

Hmmm, are you launching the Add child button while in the ADD mode on the Parent before the Parent is saved?

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

sherryblackbur1 · Answer

This is from the url on the form: a=er&amp;dfid=10 &nbsp;  Sherry Blackburn&nbsp; |&nbsp; Sr. Applications Systems Analyst - Quickbase&nbsp; |&nbsp; Technology Solutions Partners PeaceHealth&nbsp; |&nbsp; 1115 SE 164th Ave.&nbsp; |&nbsp; Vancouver, WA 98683   Learn  about Quickbase and requesting an app. Use your PeaceHealth credentials when prompted -&nbsp;&nbsp;3x3@peacehealth.org&nbsp;and your network password Need a Quickbase consult or working session?  Book it HERE. &nbsp;   This message is intended solely for the use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential, and exempt from disclosure under applicable state and federal laws. If you are not the addressee,  or are not authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, distribute, or disclose to anyone this message or the information contained herein. If you have received this message in error, immediately advise  the sender by reply email and destroy this message.

sherryblackbur1 · Answer

I am in ADD mode, before the parent record is saved. I do have it set to auto save before adding the child record. &nbsp;  Sherry Blackburn&nbsp; |&nbsp; Sr. Applications Systems Analyst - Quickbase&nbsp; |&nbsp; Technology Solutions Partners PeaceHealth&nbsp; |&nbsp; 1115 SE 164th Ave.&nbsp; |&nbsp; Vancouver, WA 98683   Learn  about Quickbase and requesting an app. Use your PeaceHealth credentials when prompted -&nbsp;&nbsp;3x3@peacehealth.org&nbsp;and your network password Need a Quickbase consult or working session?  Book it HERE. &nbsp;   This message is intended solely for the use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential, and exempt from disclosure under applicable state and federal laws. If you are not the addressee,  or are not authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, distribute, or disclose to anyone this message or the information contained herein. If you have received this message in error, immediately advise  the sender by reply email and destroy this message.

Forum Discussion

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

6 Replies