Skip to main content
Question

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

  • June 28, 2019
  • 0 replies
  • 62 views
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? 

Thank you!
    This topic has been closed for replies.

    • ChayceDuncan2
    • Quickbase Alumni
    • June 28, 2019
    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
    • Author
    • Quickbase Alumni
    • June 28, 2019
    Wow....this was so easy and works so well. Thank you!
    Terms & ConditionsAccessibility statement