Can Webhook Ignore Fields With no Value?
Hello! I have a child table with 3 text fields (Audio, Video, and Audio & Video). It has a parent table with 3 text fields (Audio, Video, and Audio & Video). If a user enters a value into any of...
Forum Discussion
Mark,
I ran into a formula error when it came to a multi-select text field. Do you have any tips on how to address that field type?
"Formula error -- Bad or missing arguments in function call
You may need to do one of the following to fix the problem:
------------------------------
Ryan Parr
------------------------------
I ran into a formula error when it came to a multi-select text field. Do you have any tips on how to address that field type?
"Formula error -- Bad or missing arguments in function call
| The types of the arguments or the number of arguments supplied do not meet the requirements of the function IsNull. The function is defined to be IsNull (. |
You may need to do one of the following to fix the problem:
- Choose the right number and type of arguments.
- Use a type conversion function to convert the arguments you are using to the correct type.
- Choose a different function.
------------------------------
Ryan Parr
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendnp
IF(Trim(ToText([my multi select field]))="", "This field is blank")
ie convert to text and then test vs "" which is empty quotes.
Note that you cannot check IsNull([my text field]) as its documented that the IsNull function does not work for text fields, so you need to test against empty quotes.
The Trim is just to trim off any extra leading or trailing white space - ie spaces or other non visible characters.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
IF(Trim(ToText([my multi select field]))="", "This field is blank")
ie convert to text and then test vs "" which is empty quotes.
Note that you cannot check IsNull([my text field]) as its documented that the IsNull function does not work for text fields, so you need to test against empty quotes.
The Trim is just to trim off any extra leading or trailing white space - ie spaces or other non visible characters.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Ahh i see that IsNull isn't working for most of my fields, because they're predominately text fields.... I'll use the Trim function to fix them all.
Thanks again!
------------------------------
Ryan Parr
------------------------------- MarkShnier__YouYep
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=n&rl=rx
Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null. The result of this function is true if x is null, otherwise false. The argument x may be of any data type (except text or boolean).
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- One more thing... what about checkboxes? Is there anything fancy i should do to address those? They currently return a value of 0 even if checked.
Here's where I'm at but it's clearly wrong:
If(Trim(ToText([Custom Promos]))="", (Trim(ToText([Install - Custom Promos]))),(Trim(ToText([Custom Promos]))))
------------------------------
Ryan Parr
------------------------------