We are using Zapier for Cloud calling service where phone number and date of call get updated in google spread sheet when we receive call on board line.
Problem: When same customer is calling again and we want to update cell partially keeping exisitng notes + new notes but right now existing data is getting deleted and only latest notes are getting updated.
Example of Solution: Existing notes under note column is “customer called on 02 dec 2022”. After Receiving Second Call, Note Column should be updated as “customer called on 3 Feb 2023” | “customer called on 02 feb 2023” |
Best answer by simplifyworkView original