CASE statments

[Joemac]

I'm not familiar with the syntax or exactly how CASE statements work.  Hoping someone can guide me in the right direction.  For my example I'm working in a datapage and want to create a field that says if a field = DROPSHIP to have the value be YES, if not then have the value be NO.

Here is what I have:

CASE

WHEN [tbl_drops_scf_pos]="DROPSHIP"

THEN No

ELSE Yes

END

Thanks for your help!

[GoodBoy]

You need to enclose the Yes and No with single quotes since they are string.

For example:

CASE

WHEN [@field:Sample] = 'DROPSHIP'

THEN 'Yes'

ELSE 'No'

END

[GoodBoy]

This article might help as well: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ 

[ParkLoey]

Hey there guys! Just wanted to add Caspio's function reference as well. They have samples on how to use functions/expressions/operations and where it can be used:

https://howto.caspio.com/function-reference/

[RuisiHansamu]

I also wanted to share this and here are other forum topics that is related to the CASE Statements here: 

 

[Flowers4Algernon]

Hi! This forum post could be helpful, too: 

 

 

[Wikiwi]

You might also  want to look into this forum post for additional information regarding Case When statement.