Question

Null values in Cloud

Laserfiche Cloud

Updated October 24, 2024

asked on May 5, 2023 • Show version history

I saw it asks a few times but I still dont understand how to update a lookup table in Cloud with nothing or NULL.

For example, if someone has a termination date in the table, and they go active again, I simply want to remove the terminate date.

All the options I have tired throw an error of "invalid string".

So if someone has information in a Cloud lookup table it can never be removed?

EDIT

I guess I figured this out in that its a date/time field. I changed the field in the lookup table to be text instead and then I could write an empty string to it and it seems to work. Still would really like a dbnull token.

3 0

Replies

replied on August 31, 2023

I'm glad you found a work around. I'm still looking for something more traditional - an actual null value. Hopefully this thread, or this -> Cloud Data Source Query Rule - Setting Null Values - Laserfiche Answers get some attention from the folks triaging feature adoption. Having access to a null value would be a big help.

0 0

replied on October 24, 2024

It seems that you can't insert null values for the following data types:

Date/Time
Numeric
Integer

You either have to use a default value (like a default date/time, or a '0'), or change your data type to text - both of which have knock-on implications for things like reporting or rules and workflows used later on.

If you would like to be able to insert Null values in look-up tables, please consider adding a like/comment to this feature request: https://answers.laserfiche.com/questions/224721/FEATURE-REQUEST--Cloud-Lookup-Tables-Null-Values

0 0

You are not allowed to follow up in this post.

Question

Question

Null values in Cloud

Replies

Sign in to reply to this post.