Skip to main content
Question

How to create a formula url button that links to a report related the parent but only pulls in related address, not record ID

  • September 26, 2018
  • 0 replies
  • 108 views
I have 3 tables: Loans, Draws, Trades. Loans is the parent to Draws, Draws the parent to Trades. In Trades I have several reports created depending upon the Draw # (each includes different sets of fields). What I want to be able to do is create a formula url button that the user can click on and it will pull up the related report, depending upon the Draw #, but relating to the Loan Property Address and not the Loan Record ID. The Loan Record ID is the key field and needs to remain the key field. Right now I have I have this formula:

If([Draw #]=1,URLRoot()  & "db/" & [_DBID_TABLE_1]& "?a=q&qid=138&nv=1&v0=" & [Loan - Property - Address: Street 1] ,
[Draw #]=2,URLRoot()  & "db/" & [_DBID_TABLE_1]& "?a=q&qid=139&nv=1&v0=" & [Loan - Property - Address: Street 1],
null)

But it is still pulling in the Trades for ALL addresses, not just the related address on that Draw. It's pulling in the correct reports, just not relating to the current Draw Property Address. Any suggestions?
    This topic has been closed for replies.

    Are those two respective reports (138 and 139)  set to be <ask the user> type reports against that field?

    • ArchiveUser
    • Author
    • Quickbase Alumni
    • September 26, 2018
    No they are not because I also use them for a Print Draw Request url formula button that works well. I just did not want to build more reports. :)
    When  you use this in a URL

    a=q&qid=138&nv=1&v0=" & [Loan - Property - Address: Street 1] ,

    what that means in plain English is that you are running report # 138 and there are going to be 1 questions to be answered and the answer to the first question (which happens to be called number 0) is the value in the field 

    [Loan - Property - Address: Street 1]
      • ArchiveUser
      • Author
      • Quickbase Alumni
      • September 26, 2018
      Okay, I get that. Is there any other way to link it to the Loan property address or do I need to make the property address the key field? If so, I'll have to test so I don't screw up the rest of what I have set up! :)
      I'm just saying that you need to make a report that asks a question and then you can have the url formula answer the question.  You do not need to change the key field.  It is just a button to run a report.
      • ArchiveUser
      • Author
      • Quickbase Alumni
      • September 27, 2018
      Okay, thanks much!

      Terms & ConditionsAccessibility statement