Default report link in table view

Question

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 records. What I am seeing is that if there are multiple children then the link will open the results in the report view, however if there is only 1 child then the link will open the result in the form view. Is there any way to force the link to always open in report view regardless of how many children?

Thanks

------------------------------
Ember
------------------------------

markshnier__you · Answer

That 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.&nbsp; &nbsp;iI you want to go though those hoops to do that post back and I will explain how to make an &lt;ask the user&gt; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

emberkrumwied1 · Answer

I am using the link on a report.&nbsp; 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.&nbsp; 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. &nbsp; Ember D. Krumwied, CRM, CIGO Corporate Records Manager and Paralegal Investco T:&nbsp;253-447-3047 &nbsp; 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. &nbsp;

markshnier__you · Answer

You 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
------------------------------

emberkrumwied1 · Answer

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? &nbsp; 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). &nbsp; Make sense? &nbsp; Ember D. Krumwied, CRM, CIGO Corporate Records Manager and Paralegal Investco T:&nbsp;253-447-3047 &nbsp; 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. &nbsp;

markshnier__you · Answer

The magic is that it will run the report which expects an answer to the &lt;ask the user&gt; question but it will answer its own question and immediately display the results.&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Default report link in table view

6 Replies