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.
@TrevorBeck4 жыл бұрын
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. :-)
@ZahratAlafrah3 жыл бұрын
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. 😀
@renejacobsen25975 жыл бұрын
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?
@TrevorBeck5 жыл бұрын
When using CopyDown, you have a choice of pasting the formula or the result. If you use the formula, it should automatically update.
@okaythisisepic32125 жыл бұрын
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.id243 жыл бұрын
It works for me. Thanks to share
@dronie87825 жыл бұрын
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
@TrevorBeck4 жыл бұрын
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.
@akashbhateley45635 жыл бұрын
Send this excal sheet download link
@TKRawat-vt9wm2 жыл бұрын
now its not working
@adamm54256 жыл бұрын
can i set it to specific TIME or DATE only? please!
@TrevorBeck4 жыл бұрын
Sorry, I've only explored DATE.
@danielcerdeira16125 жыл бұрын
Where can I find forMule?
@danielcerdeira16125 жыл бұрын
I found!
@miguegoodface5 жыл бұрын
@@danielcerdeira1612 where?
@danielcerdeira16125 жыл бұрын
Its a Google sheet add-on. Look for formmule Google sheet add-on.