Returning to parent table from child to grandchild relationship

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
This sounds crazy from the title, but what I currently am doing is creating a project in a parent table.  From this table I go into the child table to enter required data.  But in one particular relationship I have there is a child table that I input data into and from there I go into a grandchild table to add some data also.  This is where the problem occurs.

When I save the record in the child table I return correctly to the parent table to continue entering data on the project.  But when I go from the child table to the grandchild, the link breaks that forces a save and return to the parent.  At this point I have to go back to the parent table and edit the record.

Any thoughts?
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
  • like a mojito

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
I'm not quite understanding.

You are on a Project and Add Child and presumably the Project table is set to save automatically.

Now you Add Child and then Add Grandchild and the Child Saves automatically.  Is your issue what happens at that point.
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
I found your posting earlier about setting tables to save parent record when child record is created and I have implemented this on all tables.  So you are correct in that when I am on the parent (Project) table and create the child record (Information), the project saves automatically.  Upon completing the data entry in the Information table and saving the record, I am automatically returned to the Project table to continue entering all pertinent information.

The problem arises when I choose to create a record in a child table (Feeders) and from within this table I go into a grandchild table (Regulators) to enter data there.  So when I select to enter the Regulator table to enter data, the Feeder table saves and then the Regulator table opens to enter data there.  Upon saving the Regulator record(s), I enter back into the Feeder table.  I hit save but I just stay in the Feeder table now.  

I believe at this point in the process I have broken the Save and Resume functionality which is keeping me from returning back the the Project table to finish entering the project.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
So it seems to be be working properly lands you back on the Parent record of the one you just saved, which in your case it actually the child record of the main Parent project.  

There are two choices

1. Just have a link on the feeder record and the user will then navigate back to the parent. But i guess that you don't link that option.

The other options that should work is to make a formula field like this to Add Regulator.

var text ADDRegulator = ( and then paste in here the same formula that you have now but without the last last which is like & & "&z=" & Rurl() (be sure to end with a semicolon ;

var text DisplayProject = urlroot() & "db/" & [_DBID_PROJECTS] & "?a=dr&rid=" & [Related Project];

$ADDRegular
& "&NextURL=" & URLEncode($DisplayProject)
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
Thanks for the reply.  Ended up getting smart and changing the relationship to make more sense.  Back to my motto "Work Smarter, Not Harder"!