topic Check two fields for contents if match enter text into another field in App Development

Check two fields for contents if match enter text into another field

Anonymous — Thu, 15 Nov 2018 14:32:58 GMT

IF(WildMatch(Country,'*United States*'),'Referencible' )AS [Action]

AND

IF(WildMatch(Item Desc,'*Population*'),'Referencible' )AS [Action]

I want to combine the syntax above into one statement that checks Country field for United States and Item Desc field for Population. If both conditions are true the text ‘Referencible’ will be entered into the field Action for that record. If not true the text 'N/A' will be entered into the field Action for that record. Can you help?

Re: Check two fields for contents if match enter text into another field

rubenmarin — Thu, 15 Nov 2018 14:35:34 GMT

Hi John, try with:
IF(WildMatch(Country,'*United States*') and WildMatch(Item Desc,'*Population*'),'Referencible','N/A')AS [Action]

Re: Check two fields for contents if match enter text into another field

m_woolf — Thu, 15 Nov 2018 14:35:36 GMT

Maybe:

IF(WildMatch(Country,'*United States*') and WildMatch(Item Desc,'*Population*'),'Referencible','N/A')AS [Action]