Set report criteria via URL to view data in subform

Set report criteria via URL to view data in subform

Hi,

Can you open a report to a specific record (and maybe other criteria) where that record ID and other criteria is passed in via the URL?

I have a Master Form with a Subform.  The Subform of course has a lookup back to the Main Form (let's call that MF_Link_ID).

Let's say the Main Form has information about a contract and the Subform has some details about the contract, some of which require approval (a decision box in the Subform).

I want have a report that has custom actions for a person to approve or deny the items in the Subform that require approval.  Of course the report will have to be based on the Subform so I can add the custom actions.  The report does not include any criteria.

This is the URL I created, which I send via an email to the approver:

" https://app.zohocreator.com/" + zoho.adminuser + "/" + zoho.appname + "/#Report:Approvals_Report?MF_Link_ ID=" + record.ID + "&Approvals_Required=true";

I was hoping that only those records where the MF_Link_ID == the Main Form record ID and where the decisions box is true will show, but that is not what is happening.  All the Subform entries for all Main Form entries are shown.

I tried doing this so many ways but have had no success so far.  I thought this would work but it does not: https://www.zoho.com/creator/help/url-pattern/functionality-based-urls.html#To_set_criteria_for_a_view.

Any thoughts?