Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
New function: Ez()
This function returns text value if this value is not empty string. If it is empty string, it returns null instead.

Ez("TEST") returns TEST value.

Ez("") returns null.
ID
1103
Category
TeamDesk
Author

Robert Gustavsson
Date Created
4/26/2017 8:04:20 AM
Date Updated
4/26/2017 8:41:11 AM
Status
New Idea
Score
20
Promoted By
Dale OliverRobert Gustavsson
Comments
Kirill Bondar  Staff  4/26/2017 8:13:00 AM
What's the usage context? TeamDesk converts empty strings to NULLs upon save anyway.
Robert Gustavsson 4/26/2017 8:29:55 AM
For use in formulas:

"If you can read this text it means either of following column(s) are not empty:" & Ez(Nz(" column 1": & [column1]) & Nz(" column 2": & [column2]))
Kirill Bondar  Staff  4/26/2017 8:35:31 AM
"If you can read" & List("", "C1:" & [C1], "C2:" & [C2])
Robert Gustavsson 4/26/2017 8:41:11 AM
Ah, so I'll use List() then, thanks.
Feedback
 
Back to Search Results