Skip to main content

Condition "If field is exactly record" bugs


Forum|alt.badge.img+4

Dear, 

 

I am using the following automation : 

 

 

 

It works perfectly fine...but not in every case.
Indeed, when the field value contains a space (i.e. "The Demons") or a number within (i.e. The4demons) it doesn't recognize it (even if that of course exactly the same value from a table to another).

 

Does someone have a way to handle this issue?

 

Have a nice day, 

Arthur

3 replies

kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6001 replies
  • June 26, 2024

When something works most of the time, but not all of the time, it is usually time to dig deeper into the values that are having problems. 

What are the field types involved? Can you share screen shots of table values? Could there been a change in upper/lower case? Could there be leading/trailing spaces? 


Forum|alt.badge.img+4
  • Author
  • Participating Frequently
  • 7 replies
  • June 27, 2024
kuovonne wrote:

When something works most of the time, but not all of the time, it is usually time to dig deeper into the values that are having problems. 

What are the field types involved? Can you share screen shots of table values? Could there been a change in upper/lower case? Could there be leading/trailing spaces? 


Hi, 

These are "linked record" fields with values similar to these : 

These two precisely are not recognized, when the "link to record" value "Sparel" for instance, is recognized perfectly.

Thank you, 


 

 


dilipborad
Forum|alt.badge.img+20
  • Brainy
  • 215 replies
  • June 28, 2024
Arthur_CRM wrote:

Hi, 

These are "linked record" fields with values similar to these : 

These two precisely are not recognized, when the "link to record" value "Sparel" for instance, is recognized perfectly.

Thank you, 


 

 


Hello @Arthur_CRM 
First of all, find records of action check for exact match only. No matter what is the case(upper, lower) of text.
For example, These are examples that are not matched.
1) "Test String" and "TestSring",
2) "Test Sting and "Test string",
3) "test Sting and "Test String".

Use Automation with a script that can do that different case search and fuzzy match.
To use this you need to know some JS.
👍


Reply