Calculate items do not store logical values

[jmgirard]

I am having trouble getting a calculate type item to store logical values (i.e., TRUE or FALSE).

A minimum working example is here: https://docs.google.com/spreadsheets/d/14x1TtDJH0J2ivvuf7r7kK-9_ZdQd1ycyzk5kZ2TBp4g/edit?usp=sharing

[jmgirard]

The plot thickens. It seems that the issue is only with storing FALSE logicals, as TRUE values seem to be converted to 1's successfully:

Config

Input

Output

Note the missing values for the two FALSE items. They aren't NA, just missing entirely.

[cyriltata]

Dear Jeffrey Thanks for reporting the issue. We will resolve this in the next release. For the moment please could you use your workaround? best Cyril

…

On Thu, Oct 17, 2019 at 11:32 PM Jeffrey Girard ***@***.***> wrote: The plot thickens. It seems that the issue is only with storing FALSE logicals: Config [image: image] <https://user-images.githubusercontent.com/6829033/67049253-c8594400-f103-11e9-8bd4-6e3917f18c4f.png> Input [image: image] <https://user-images.githubusercontent.com/6829033/67049380-15d5b100-f104-11e9-8cd2-44e5758667c1.png> Output [image: image] <https://user-images.githubusercontent.com/6829033/67049221-b4addd80-f103-11e9-8236-75d540ca146d.png> — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#428?email_source=notifications&email_token=AARL5Z5J3BXPW7S5Y4OVUH3QPDKX5A5CNFSM4JB6E4KKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEBRS4XQ#issuecomment-543370846>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AARL5Z4QIMWRAJB2BYJJOWTQPDKX5ANCNFSM4JB6E4KA> .

[jmgirard]

Sounds good. Thank you!

[rubenarslan]

To explain this a little, the calculate fields always store text. So all you ever get is a text representation of the value. But I think we're doing the conversion on the PHP side (where an empty string can denote false), when we should probably be doing it on the R side with as.character to keep things consistent (in R an empty string is NA, not false).