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 LegendThat is how a report link behaves.
If you really want to force a report then you will need to build you own URL formula field. iI you want to go though those hoops to do that post back and I will explain how to make an <ask the user> report and run it from the URL formula button.
Assume you know that you can set the form to show the child records directly on the form so of course that will always be a report.
But maybe you are using the report link field on a report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If you really want to force a report then you will need to build you own URL formula field. iI you want to go though those hoops to do that post back and I will explain how to make an <ask the user> report and run it from the URL formula button.
Assume you know that you can set the form to show the child records directly on the form so of course that will always be a report.
But maybe you are using the report link field on a report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I am using the link on a report. I do know how to display the report results directly into a form, but in this case the users are seeing a summary of items in a parent table (report view) that includes a link to open the associated children records. I am just seeking to the ability to standardize the user experience and notice that it is different for 1 child record vs. multiple children records.
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__YouYou 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
------------------------------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
InvestcoT: 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
------------------------------