Discussions

Expand all | Collapse all

Report Links: Matching to a Value in Multiple Target Fields

  • 1.  Report Links: Matching to a Value in Multiple Target Fields

     
    Posted 09-27-2018 21:46
    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!


  • 2.  RE: Report Links: Matching to a Value in Multiple Target Fields

    Posted 09-27-2018 22:02
    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.


  • 3.  RE: Report Links: Matching to a Value in Multiple Target Fields

     
    Posted 09-27-2018 22:25
    Oh I keep forgetting about Formula Fields. Thank you!