Can Webhook Ignore Fields With no Value?

Question

Hello!I have a child table with 3 text fields (Audio, Video, and Audio &amp; Video). It has a parent table with 3 text fields (Audio, Video, and Audio &amp; Video).If a user enters a value into any of the text fields on the child record, I'd like it to update it's matching fields on the parent.&nbsp; However if one of those fields has no value entered into it, i don't want it to override the existing data on the parent... it should skip the field.Can this be done via a webhook? In reality, my table has a ton of fields on it... i realize i could create automatons for each one, but that would take us over the automation threshold.&nbsp;Thanks in advance!------------------------------Ringoparr ------------------------------

markshnier__you · Answer

Here'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.&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

ryanparr · Answer

Easy peasy! I'll expose all the fields on the child and work with that logic.&nbsp;Thanks, Mark, you da admin!------------------------------Ryan Parr------------------------------

ryanparr · Answer

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

The types of the arguments or the number of arguments supplied do not meet the requirements of the function&nbsp;IsNull.The function is defined to be&nbsp;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 · Answer

npIF(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 -&nbsp; ie spaces or other non visible characters.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

ryanparr · Answer

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------------------------------

Forum Discussion

Can Webhook Ignore Fields With no Value?

Related Content

Snapshot Fields

Carrying the old value of a field into a webhook

Find and Replace Field Values

Webhook Pipeline Question

Proxy fields