Is there a way to check if a field has more characters than a specific amount?
Hi!
I am trying to set up a beast mode function that checks if fields are correctly filled out in our asset tracking software, and lists out any asset that does not meet all requirements (ie fields not filled out or have been auto-generated by the software itself).
One thing I am curious about is, I'd like to be able to include a function that can see if either one field (Serial Number) is empty OR has more than 7 characters included. I am fairly new to beast mode calculations, and we have most everything working properly to check all empty (NULL) fields and one field if it is either empty or auto generated (LIKE 'EXAMPLE-%'), but I'm not totally sure if or how to check if the character count is more than 7 characters in a field.
I hope I'm making some sort of sense here. And thank you for any advice!
Best Answer
-
Hi @JoeR_PSIT
You can use the LENGTH function to get the number of characters in a string
CASE WHEN `Serial Number` IS NULL OR LENGTH(`Serial Number`) > 7 THEN 'Error' ELSE 'OK' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3
Answers
-
Hi @JoeR_PSIT
You can use the LENGTH function to get the number of characters in a string
CASE WHEN `Serial Number` IS NULL OR LENGTH(`Serial Number`) > 7 THEN 'Error' ELSE 'OK' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3 -
Thank you Grant! That was such a quick and helpful answer. I have tested it and while it will take some work to get it working with a more complex beast mode calculation, that is EXACTLY what I was looking for! Time for some trial and error and try to push this further :D
Thank you again! I really appreciate it!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive