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
MarkShnier__You
Qrew Legend
Qrew LegendHere's an idea.
Suppose that there is a field on the parent for Project Date.
Look that up down to the child.
Now make a field called [Date to be written on project] (I realize you will have shorter names)
IF(not IsNull([Child Date Entry]),[Child Date Entry],[Project Date])
and then write that value to the Project Date field in he webhook. So while there is not logic to avoid clobbering the Project Date with a block, if the date entry on the child record was blank, you will re-writing the same [Project Date] original value over again, which means no change.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Suppose that there is a field on the parent for Project Date.
Look that up down to the child.
Now make a field called [Date to be written on project] (I realize you will have shorter names)
IF(not IsNull([Child Date Entry]),[Child Date Entry],[Project Date])
and then write that value to the Project Date field in he webhook. So while there is not logic to avoid clobbering the Project Date with a block, if the date entry on the child record was blank, you will re-writing the same [Project Date] original value over again, which means no change.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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__Younp
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
------------------------------