Conditionally display link in a Calendar

[Kuroshi]

I have this formula:
 

CASE
WHEN [@field: Calendar_ID] = ' '
THEN '<a href=
"https://accountid.caspio.com/dp/appkey?Calendar_Date=[@field:WorkDays_Date*]&ResourceName=[@field:ResourceName]"> Test </a>'
ELSE ' '
END

However it is not working as expected. Logic is if the field Calendar_ID is blank, then show the Test link. Link is not showing. 

[Barbie]

Hello @Kuroshican you try to use IS NULL instead of = ' ' ? Here's the formula:

 

CASE
WHEN [@field: Calendar_ID] IS NULL
THEN '<a href=
"https://accountid.caspio.com/dp/appkey?Calendar_Date=[@field:WorkDays_Date*]&ResourceName=[@field:ResourceName]"> Test </a>'
ELSE ' '
END

Hope it helps.

[cheonsa]

For more details, you can check this function reference: https://howto.caspio.com/function-reference/

[Kurumi]

Hi - sharing this new post!