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?
@Jennifer_Shields You might be better served by giving your clients access to edit their data via a portal like this one:
(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code.)