redirect to related record on parent table

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have 3 tables:  Projects (Grandparent), Tasks (Parent), and Activities (Child).  When I add an Activity from the Tasks table form I am currently re-directed back to the previous page, which is generally the Tasks form.  I would like to re-direct back to the related projects form.  Is this possible?  I've tried to play around with the 

& "&z=" & Rurl()

at the end of the "Add Activity" formula URL field, but am not familiar enough with what these mean and have not yet been successful.

Any help would be appreciated!

Photo of Jennifer


  • 10 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
In this example when you create a new Activity from the Tasks table you will be redirected to the related Parent record upon saving

P -< T -< A

Pastie Database

I did this very quickly so there might be some minor issues if you navigate around the natural workflow.