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. 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.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 01-03-2020 12:08
From: Ryan Parr
Subject: 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 the text fields on the child record, I'd like it to update it's matching fields on the parent. 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.
Thanks in advance!
------------------------------
Ringoparr
------------------------------