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
------------------------------
Easy peasy! I'll expose all the fields on the child and work with that logic. Thanks, Mark, you da admin!
------------------------------
Ryan Parr
------------------------------
------------------------------
Ryan Parr
------------------------------