How can I make a report link inactive if there are no current records?

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
I have setup some report links that will show a list of activities under a related record. If there are no records created, how can I deactivate the link?

For example:

Record 1 = > Sub Record 1 | Sub Record 2
The report link would display sub record 1 and 2.

If there are no sub records under Record 1. The report link would say "No Records Available" or something similar
Photo of Ismail

Ismail

  • 0 Points

Posted 6 years ago

  • 0
  • 1
Photo of Surya

Surya

  • 0 Points
If you are talking about the subreport on a form, all you have to do is to have it show the data on the form rather than a link. Once you do that, it will show the data in the child table if there are any, otherwise it will say "No child records found", where the word child will be replaced with whatever is the name of the table records.

Hope that helps.
Photo of Ismail

Ismail

  • 0 Points
The report link isn't on a form but a report. Thanks for the help though!

I have a report that shows call records, lets call them Campaigns.
Under each Campaign, you can create Emails, Lists etc.

The Campaigns Report has report links to Emails and Lists. The Report link for Email will go to Emails created under a campaign record. I want to format the report link so that if there are no Email records for the campaign it will not list it.
Photo of Surya

Surya

  • 0 Points
Thanks for that clarification. Here is how you do it.

1. Create a summary field on the Campaigns field to contain the number of Email records in that Campaign.
2. Create formula field called "Emals in this Campaign" on the Campaigns table.
3. In the formula field, you will be checking if the summary field is zero or greater than 0.
4. If it is zero, the value of the formula field will be blank or "".
5. If it is more than zero, the formula field will have the value  composed as below:

https://flra.quickbase.com/db/DBIDofEmailsTable?act=API_GenResultsTable&query={fidofrelatedcampaign.EX.RecordIDOfCampaignsTable

The above is a template of how the URL formula should look like. You should replace the DBID part with the DBID of the Emails Table. Replace the RelatedCampaign  with whatever is the fid of the reference field in the Emails Table etc.

Hope that helps.
Photo of Ismail

Ismail

  • 0 Points
Hi Surya,

That link doesn't work for me. How can I get to that article in the API documentation?
Photo of Surya

Surya

  • 0 Points