Tutorial - Automatically send email reminders from Google Sheets with formMule

Рет қаралды 42,060

Күн бұрын

Пікірлер: 19

@darryldarks 4 жыл бұрын

Trevor, I just want to genuinely say thank you so much for putting out this content!! You’re doing a wonderful job and really educating people. Thanks again.

@TrevorBeck 4 жыл бұрын

Thanks for your kind words. I haven't uploaded anything in the last year, but with my new position at work I should be able to find more time to do that again. :-)

@ZahratAlafrah 3 жыл бұрын

Hi, thanks for the explanation 1- How can I run the web link directly after the submit form button? 2- How can I show the sender's mail in the form field without typing it? 3- How do I get a student to check-in and check-out only twice a day ? Thank you ....

@bryanmalone1118 Жыл бұрын

Does the emails get sent if the Google Sheet stays closed? or does someone have to open the sheet everyday for the actions to occur?

@TrevorBeck Жыл бұрын

The formMule add on runs in the background - no need to open the file. 😀

@renejacobsen2597 5 жыл бұрын

Looks great and first e-mails works 100%. Reminders is a problem when CopyDown doesn't update formula when date changes (as in your example). Are yours a CopyDown cell? (E4 at 1.50) Any advice on that?

@TrevorBeck 5 жыл бұрын

When using CopyDown, you have a choice of pasting the formula or the result. If you use the formula, it should automatically update.

@okaythisisepic3212 5 жыл бұрын

I don't know if they've updated Google Calc or if it's my regional Swedish settings but I had to separate the arguments with ';' as in =if(B2-7

@batakedu.id24 3 жыл бұрын

It works for me. Thanks to share

@dronie8782 5 жыл бұрын

hello, already you are doing a great job. I would like to send a notification email to myself and to the clients as part of my work. it's about product rental. example: I want to send an email with the following conditions: in a sheet google sheet a product must be returned to us on a certain date, if this date is not respected then I send a reminder email to myself and to the customer, if this date is respected then I do not send any email. my sheet has 3 columns date (product removal date, product estimated return date and return date). I am not a programmer. can you give me your help? thank you so much

@TrevorBeck 4 жыл бұрын

You can create a column called RETURNED and then populate it with Yes or No. FormMule can be set to look for a specific result in a column before firing off.