Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Automation To Find Exact String from Long Text List

Topic Labels: Automations
Solved
Jump to Solution
1504 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Anthony_Cassel
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to make a linking automation. Our records in Table 1 do not all exactly match records in Table 2. I am using an Long Text field to create a list of other numbers I would like the automation to look for when linking.

Anthony_Cassel_0-1683811018150.png

The problem is that using the Find Records function has the options to find a record that "is"(which wont work because im using a list) or "contains"(which will find records that dont exactly match. EX: 2118-1 will match with 2118-1.1 or 2118-11) Is there any ways around this?

Anthony_Cassel_1-1683811108914.png

 

 

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

The Find records action with "contains" is behaving as designed.

The workaround is to have a delimiter around your search string and to include that delimiter in your search.

For example, it looks like most (but not all) of your IDs are followed by a comma. If you could add a comma directly after all of the IDs, including the last one, you could then search for "contains" and include the comma. 

I actually don't like a comma in this case. I prefer to use two delimiters: one at the beginning and another at the end: [2118-1][2118-1.1][2118-11]. Then I have a formula field that tacks on the delimiters to the ID and use that formula field in the Find records.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

The Find records action with "contains" is behaving as designed.

The workaround is to have a delimiter around your search string and to include that delimiter in your search.

For example, it looks like most (but not all) of your IDs are followed by a comma. If you could add a comma directly after all of the IDs, including the last one, you could then search for "contains" and include the comma. 

I actually don't like a comma in this case. I prefer to use two delimiters: one at the beginning and another at the end: [2118-1][2118-1.1][2118-11]. Then I have a formula field that tacks on the delimiters to the ID and use that formula field in the Find records.

Anthony_Cassel
5 - Automation Enthusiast
5 - Automation Enthusiast

I think that would actually work perfectly. Youre a genius. I will give that a go. Thanks a ton.