Error when trying NailDyan's Calc "please disregard this thread"

[Hiperf]

I have tried the following from NailDylna and I am getting a validation error. Incorrect syntax near (.

CASE WHEN
(SELECT COUNT([@field:SMNUnique]) FROM tblSubmission WHERE [@field:SMNUniqueCalc] = [@field:SMNUnique]) 
THEN
'Exists'
ELSE
'Does not Exisit'
END

[PotatoMato]

Hi,  @Hiperf. You're missing a condition on your select count query.  It should be:

CASE WHEN
(SELECT COUNT([@field:SMNUnique]) FROM tblSubmission WHERE [@field:SMNUniqueCalc] = [@field:SMNUnique]) >= 1

You may change '>= 1' as needed.

 

-Potato

[Flowers4Algernon]

Hello! Just wanted to share this article, which should be helpful when creating a formula: https://howto.caspio.com/function-reference/