Default report link in table view
When creating relationships between tables the system automatically creates a link field and add new field. The link field, when selected will open either a report or form for the associated child re...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou would need to create a report with an <ask the user> filter based on which Parent record to display.
ie where [Related Parent] is <ask the user>
Then create a formula URL like this
URLRoot() & "db/" & [_DBID_Child_Table] & "?a=q&qid=99&v0=" & [Record ID#]
replace the _DBID_Child_Table with the table alias fond at the bottom of the Advanced Settings page for the child table, but still in [Square Brackets]
Replace 99 with the report # that you created.
.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
ie where [Related Parent] is <ask the user>
Then create a formula URL like this
URLRoot() & "db/" & [_DBID_Child_Table] & "?a=q&qid=99&v0=" & [Record ID#]
replace the _DBID_Child_Table with the table alias fond at the bottom of the Advanced Settings page for the child table, but still in [Square Brackets]
Replace 99 with the report # that you created.
.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thank you for this...will this solution force the user to have to select or enter an Entity Name in order to view the report or will it pickup that information depending on the specific parent record the link was accessed from?
Meaning, if from the parent report view for Entity ABC Company there was this new "ask the user" report link and it is selected would the user be asked to enter the name ABC Company or would the link know that they wanted the report for ABC Company (because that was the parent record they selected the link from).
Make sense?
Ember D. Krumwied, CRM, CIGO
Corporate Records Manager and Paralegal
Investco
T: 253-447-3047
Confidentiality Notice:
This message is intended exclusively for the individual or entity to which it is addressed. This communication may
contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you
are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part
of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies.
P Please consider the environment before printing this email.
- MarkShnier__YouThe magic is that it will run the report which expects an answer to the <ask the user> question but it will answer its own question and immediately display the results.
So the answer will be fed to the report according to the parent record that they launched from with no user input, just the "click" off the report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------Fabulous! I will give this a try and post back with any issues. THANK YOU!
Ember D. Krumwied, CRM, CIGO
Corporate Records Manager and Paralegal
InvestcoT: 253-447-3047