I'd like to have a button on my main table that when clicked to shows the record on at a related table.

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

My main table is all of our client records.  I 'd like to hit a button that will open their billing entry that's on a related table.   Any formula ideas?

Photo of Tony

Tony

  • 194 Points 100 badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
So is the setup that 1 Client has many Billings entries?  And you want to click a button on the Client to display a report of all their Billing records?
Photo of Tony

Tony

  • 194 Points 100 badge 2x thumb
Basically.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
Before I give the slightly complicated answer for a formula, why not just put a report link field on your Client Record to show a report link to the billing records or an actual embedded table of the Billing entries right on the client record?  The report link field will have been created for you on the left side of the Relationship between Clients and Billings
Photo of Tony

Tony

  • 194 Points 100 badge 2x thumb
Thank you.  I saw that and wasn't entirely sure how to use it.  I figured it out now.  Thank you again!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
Great, stupid simple is always the way to go when available!  No need to write formuals that way.