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.

Sign up

Login to the community