Kia ora!
I’m setting up an automation that watches one table for new records, and updates records in a second table with the information from the first. The specific use case is clients being able to update their personal information. This is done via a form in the first table with a range of optional fields - with the aim being that clients can only fill out what needs updating and leave the rest.
However, when updating records in the second table based on these entries in the first, any empty fields in a record in the first table wipes the data from those fields in the second.
Is there a way to leave fields alone if the fields in the new record are empty?