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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
  • (Edited)
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.
Photo of Evan Fujikawa

Evan Fujikawa

  • 390 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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
Photo of Evan Fujikawa

Evan Fujikawa

  • 390 Points 250 badge 2x thumb
I have multiple parent forms leading to the same child record table. Would the url formula be placed in the parent or child form?
Photo of Avi Sikenpore

Avi Sikenpore

  • 532 Points 500 badge 2x thumb
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.
Photo of Avinash Sikenpore

Avinash Sikenpore

  • 162 Points 100 badge 2x thumb
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.