Calculated Field for List String

[EmmePGN]

Hi all, my calculated field that pulls data from a List String field is showing "Valid" prior to saving my datapage.

However,  when I look at the actual page on preview it is showing me an error message "Calculation Error".

Anyone knows where I'm going wrong?  Please help thank you.

Below is my simple code (per Caspio instructions). The [@KnwIT] is a list-string.

 

CASE
 
WHEN [@KnwIT] IS NULL THEN 'Not Done'
 
WHEN [@KnwIT] IS NOT NULL THEN 'Complete'

END

[NiceDuck]

I'm afraid that we cannot access list string fields on calculated fields, the same with the calculated values and formula fields.

[NiceDuck]

If you are on a form type of datapage, you can try using this workflow where they converted it first on a comma seperated values on a virtual field  then use that comma seperated values for your calculation. 

I hope this helps.

[PotatoMato]

Hello,

At this time, List fields cannot be used in Charts, Pivot Tables, Grouping, Aggregations, Formula Field, and Calculated Field. Here are the notes about List data type: https://howto.caspio.com/tables-and-views/data-types/list/

 

-Potato

[EmmePGN]

17 hours ago, PotatoMato said:

Hello,

At this time, List fields cannot be used in Charts, Pivot Tables, Grouping, Aggregations, Formula Field, and Calculated Field. Here are the notes about List data type: https://howto.caspio.com/tables-and-views/data-types/list/

 

-Potato

Hi Potato and Nice Duck, thank you for responding to me. I will follow the thread dated April 8 about similar issues. Thank you.