Report Links: Matching to a Value in Multiple Target Fields

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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!
Photo of Sam W

Sam W

  • 210 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
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.
(Edited)
Photo of Sam W

Sam W

  • 210 Points 100 badge 2x thumb
Oh I keep forgetting about Formula Fields. Thank you!