When a table from source is empty in some instances and not others
Status: Closed · Asked by matthew.gillard on · 0 views
Your Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NmMwNTZiMDYzMjA0MzY1MjY1NTUzMCI_3D_pc
Task History ID: IjU3NjAwNTZiMDYzNjA0M2M1MjZlNTUzZDUxMzE1MTYzNTQzOSI_3D_pc
Hi there
We have an automation from webhook (infinity app table).
We are formatting date fields from the infinity app table.
In the table we have 8 columns of dates. Sometimes the table will only have one column of dates (7 blank), sometimes 2 (6 blank), sometimes 8 (no blanks).
I see the automation does not work unless all 8 columns have a date. see screen shot below of the date columns of the table.
How can we setup the automation for the below where they maybe 1 date, 2 dates or 5 dates etc etc
Hey @matthew.gillard
We have made some changes based on your requirements.
I kindly request you to try again now and let me know if you are still facing the same issue.
thank you all working now