Report Link Filtering

Question

I'm trying to create a report link which dynamically filters by multiple criteria.

The intent is to have a report link, appearing on an RFP record, which shows Partners who perform the service(s) the RFP includes. This was done when setting up the report link and specifying that the match be on the service (listed in the RFP and on the Partner record).

Now I want to filter the report further so that is only shows records where the Partner operates in the State where the RFP is issued. Not seeing a clear way to do this. Any suggestion is appreciated.

Thanks,
Jake

------------------------------
Jake
------------------------------

markshnier__you · Answer

Can you tell us how the Partner Record identifies the State in which they operate? Is the Partner listed twice if they do the service in two state? Or does the Partner have some kind of list of States on a single Partner record

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

jakerattner1 · Answer

Hi Mark,&nbsp;The state's are associated via a many to many and are captured on the Partner record by a combined text look up. Does that help?ThanksJake------Original Message------Can you tell us how the Partner Record identifies the State in which they operate?&nbsp; Is the Partner listed twice if they do the service in two state?&nbsp; Or does the Partner have some kind of list of States on a single Partner record------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

donlarson · Answer

Jake,Could you include a diagram of the related tables and the fields for this report?Don------------------------------Don LarsonPaasporterWestlake OH------------------------------

markshnier__you · Answer

This can definitely done, one way or the other.I'm going to make the assumption that the Partner record is in fact listed many times, once for each service and that is how you did the Report Link, by looking for an Exact Match in the Report Link settings.&nbsp; If that assumption is not correct, then the following will not apply and we will need to go to Plan B.My suggestion is to:

Do a lookup from the Partner record down to the child states record of the Service.&nbsp;
Make a concatenated field in the format like Service-State.&nbsp;
Then make an additional combined text summary field of the [Service-State] up to Partners.
Then convert the combined text summary field to a text field type with a formula text field ToText([Service-State combined text]) called [Service-State (text format)]
On the RFP record make a field in the format [Service-State]
Lastly make a Report Link field on the RFP to match [Service-State] to the&nbsp;[Service-State (text format)] in the Partners Table.

------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Forum Discussion

Report Link Filtering

Related Content

Secure Links for Instant Access and Full Control

Embedded Grid Edit Report Pre-filtered Conditional Dropdown

Trying to create a report with an ask users filter, but with a multiselect

Go to report with custom filters Formula URL or Report Link

Form rule modal display a link