Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

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

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 fie...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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]