Child Record redirects to new parent record when saved

Question

In the new form, when I add a child record from a link on the parent record and then save the child record it redirects me back to the parent table in an "add new record" mode instead of back to the original parent record I was working on. This is causing duplicate records to be made because the user thinks the initial parent record wasn't saved. If I save the parent record before clicking on the add new child record button then it redirects back to the parent record I was working on just fine, but if that save doesn't happen before clicking the add child record button first then it will take us back to add new record to parent table. Anyone know of a fix for this?

------------------------------
Amber Goodman
------------------------------

serviceqb · Answer

Go to the Advanced Settings of the table and Check the Box that Says "AutoSave when redirected away from the Page"
This should save the Parent record and allow it to attach the child correctly. Is the button you are using the system-generated add button or a Formula URL you created? If it is the latter, you may just need to fix the redirect.

------------------------------
Tammie King
tjking@mintz.com
(978)828-9643
------------------------------

ambergoodman · Answer

That is already turned on.&nbsp; It does save the parent record and take you to the child record, but when you save the child record it doesn't take you back to the parent record you just created.&nbsp; It takes to into the parent table in a new record so our users are hitting save there and basically creating another new record.&nbsp; Now if I save the parent record and then click the button to add a new child record it will bring me back to the existing record but not if I don't save the parent record before clicking to add a child record.------------------------------Amber Goodman------------------------------

markshnier__you · Answer

I have not tested, but sounds like a bug to me that needs be be reported.
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

miketamoush · Answer

I agree with Mark that sounds like a bug. However, maybe as a temporary work around you can use a formula rich text button and take advantage of the %%rid%% to return to the new record? Not the ideal solution, but should work.------------------------------Mike Tamoush------------------------------

adamkrzyzanek · Answer

Indeed very annoying, I wonder if you already reported it via Case to QB?
How to Incorporate %%rid%% in formula??I add it at the end and it returns to "Home Page" Dashboard (not even to same Table)

URLRoot() &amp; "db/" &amp; [_DBID_CUSTOMIZATION_INITIATIVE] &amp; "?a=API_GenAddRecordForm&amp;dfid=14&amp;_fid_849=" &amp; URLEncode ([Alignment ID#])
&amp; "&amp;_fid_357=" &amp; URLEncode([SMO])
&amp; "&amp;_fid_568=" &amp; URLEncode([Subsector])
&amp; "&amp;_fid_13=" &amp; URLEncode([Customization Type])
&amp; "&amp;z=" &amp; Rurl()&amp;"%%rid%%"------------------------------Adam Krzyzanek------------------------------

Forum Discussion

Child Record redirects to new parent record when saved

8 Replies