This seems simple, but I cannot conceptualize how to acheive this:
Client submits a form, creates new row in Google Sheets, triggers email to appropriate employee for review.
Now, said employee is away from the office and needs to utilize the Auto Reply feature in Microsoft Office… The FROM field of the triggered emails is always received as “email@example.com”, even when overriding it to a local address in the workflow. Furthermore, according to Microsoft forums, it is not possible to configure “Reply ALL” when using the auto-reply feature…
So how can my employees communicate to their clients that they are out of office?
I am inclined to think that I could set up a table for the employee to submit an Out of Office request with a start and end date. Then somehow trigger AppSheet to review this table upon each client submission, before triggering both the client submission AND an out-of-office response…
Can anyone suggest how to accomplish above, or offer a better solution? All of your great minds are sincerely appreciated!