Quick Base Discussions

Expand all | Collapse all

Is there a way to return from child table back to the parent parent record?

  • 1.  Is there a way to return from child table back to the parent parent record?

    Posted 10-10-2017 01:22
    When I'm in the child record table is there a way to return back to the specified parent record? When I select the related record ID it take me to a form with partial information and is different from the parent record form.


  • 2.  RE: Is there a way to return from child table back to the parent parent record?

    Top
    Contributor
    Posted 10-10-2017 02:29
    It sounds like you might have multiple forms for the parent record.  Is that the case?

    If so, you will need to create a formula url that specifies the form that you want to go to.  
    That can be done with a 

    &dfid=10

    display_form_id


  • 3.  RE: Is there a way to return from child table back to the parent parent record?

    Posted 10-10-2017 04:47
    I have multiple parent forms leading to the same child record table. Would the url formula be placed in the parent or child form?


  • 4.  RE: Is there a way to return from child table back to the parent parent record?

    Posted 10-10-2017 13:04
    There are two ways you can handle the returning to the correct parent form. One is encoding the correct dfid in the URL like Matthew suggested. It would be a formula url like : 
    URLRoot() & "db/ABC123456?a=er&dfid=12_fid_9=" & URLEncode ([Related Parent Record ID#]]) 

    ABC123456 = parent table dbid

    This formula will only take you to the specific form (form id 12). You can use some logic to dynamically change the form id it goes back to or use multiple buttons which take you to the different forms. This formula field will be in the child table

    second way is - to encode "&z=" & Rurl() at the end of your add child record formula URL in the parent table.

    the z=rurl() will return to the prior page (be it a form or a report). That means once the user is done adding the child record he/she will return to the original form/page they started with.

    An example would be URLRoot() & "db/DEF123456?a=API_GenAddRecordForm&_fid_9=" & URLEncode ([Parent Record ID#])& "&z=" & Rurl()

    the DEF123456 = child table dbid.


  • 5.  RE: Is there a way to return from child table back to the parent parent record?

     
    Posted 10-10-2017 13:11
    There are two ways you can handle the returning to the correct parent form. One is encoding the correct dfid in the URL like Matthew suggested. It would be a formula url like : 
    URLRoot() & "db/ABC123456?a=er&dfid=12_fid_9=" & URLEncode ([Related Parent Record ID#]]) 

    ABC123456 = parent table dbid

    This formula will only take you to the specific form (form id 12). You can use some logic to dynamically change the form id it goes back to or use multiple buttons which take you to the different forms. This formula field will be in the child table

    second way is - to encode "&z=" & Rurl() at the end of your add child record formula URL in the parent table.

    the z=rurl() will return to the prior page (be it a form or a report). That means once the user is done adding the child record he/she will return to the original form/page they started with.

    An example would be URLRoot() & "db/DEF123456?a=API_GenAddRecordForm&_fid_9=" & URLEncode ([Parent Record ID#])& "&z=" & Rurl()

    the DEF123456 = child table dbid.