Report Links: Matching to a Value in Multiple Target Fields

Question

I have an Organizations table. I also have an Events table.

Our events table has a rich text 'Description' field as well as a 'Host' field.

I'm looking to create a Report Link that looks for the value found in the Organization Table's 'Name' field, in_ either _the Events Table's 'Description' field __or its 'Host' field.

Is there a way to do this? - that is, to make a report link search in multiple target fields?

Any help greatly appreciated!

suryaexpert · Answer

You can uncheck the "Only include values if they match exactly in both fields" and see how that goes. But I am not sure if it will match using the "contains" or "starts with" factor. Using Multiple target fields is not directly possible. You could have a single formula text field that has the values of all the target fields you want to check against and use that in the report link. Hope that helps.

samw · Answer

Oh I keep forgetting about Formula Fields. Thank you!

Forum Discussion

Report Links: Matching to a Value in Multiple Target Fields

Related Content

Building a report from multiple tables

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

Multiple Tables Report

Match date to End of Month (EOM) date