Button to open form (on child table) from report (on parent table)

Question

Hello,Hope you can help with this. I found a few related articles but can't seem to make the formula work.I have two tables: Transactions (parent) and Notes (child). There is one note to one transaction. I have a report on the parent table that lists transactions and I'd like to create a formula URL button on that report that opens the related note (using a designated form, "view" mode).What would be the formula for this?&nbsp;Thank you!

chayceduncan2 · Answer

So you want to open the the child from the parent? Simple way is to create a summary field in your relationship for the Max Record ID of your notes - which will return the record id of your note.

Then for your url - something like this will work

"
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

haleyhaley · Answer

Wow....this was so easy and works so well. Thank you!

Forum Discussion

Button to open form (on child table) from report (on parent table)

Related Content

Building a report from multiple tables

API Button Help

Formula Url Buttons

Rich-text formula button on dashboard

Multiple Tables Report