Hi,
I’ve set up my base to support my dog grooming salon. I can set up a field that will alert me of appointments for the following day (along the lines of If next appointment = -1 days, Then …),
but I would like an automated setup so that the client will receive a text message (sms) reminding them of their appointment.
“Just to remind you that {{dog’s name}} has an appointment at the groomers tomorrow {{appointment date and time}}.”
To make it a little more complicated, the appointment dates and times are on the ‘Dogs’ sheet, which is then linked to the ‘Clients’ sheet which has the telephone number on. Has anyone managed to do this?
Thank you for any advice or suggestions.