Get Alert Mails on Expiry | Google Sheets Malayalam Tutorial
Vložit
- čas přidán 13. 05. 2024
- ഇൻഷുറൻസ് പോളിസികളുടെയും, മറ്റ് സബ്സ്ക്രിപ്ഷൻ സർവീസുകളുടെയും Renewal / Expiry Date കണ്ടെത്തി അതിനു അനുസരിച്ചു Alert Message, email ആയിട്ട് അയക്കുന്ന ഗൂഗിൾ ഷീറ്റ്സ് ഫോർമാറ്റ്.
Google Sheets template for calculating the Expiry Date or Renewal Date in Excel and the program for sending Alert messages as mails, explained in Malayalam.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
Subscribe to the channel @AjayAnandXLnCAD for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/learn-mi...
Download the code (Apps script) for generating mails.
drive.google.com/drive/folder...
#googlesheettutorial #malayalamtutorial #expirydate
Code for generating mails with Alert messages
function checkExpiry() {
// Set current time before performing other tasks
var currentTime = new Date();
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
sheet.getRange("L3").setValue(currentTime);
var lastRow = sheet.getLastRow();
var expiredValues = []; // Array to store expired values
var expiringSoonValues = []; // Array to store expiring soon values
for (var i = 4; i 0 || expiringSoonValues.length > 0) {
var recipientEmail = 'yourmail@xlncad.com'; // Replace with your actual email address
var subject = 'Notification from Google Sheet';
var message = "";
if (expiredValues.length > 0) {
var expiredMessage = "Expired Items: " + expiredValues.join(", ");
message += '1: ' + expiredMessage + "
";
}
if (expiringSoonValues.length > 0) {
var expiringSoonMessage = "Items Expiring soon: " + expiringSoonValues.join(", ");
message += '2: ' + expiringSoonMessage;
}
MailApp.sendEmail(recipientEmail, subject, message);
}
}
how to add second column content also with subscrition.
app script function run, but mails are not coming
Perfect. ഇതെപോലുള്ള സർവീസ് തരുന്നത്തിന് പ്രത്യക നന്ദി അറിയിക്കുന്നു
Ur the best👍👍👍
നിങ്ങളെ വിഡിയോ കണ്ട് ഞമ്മളെ കാര്യങ്ങൾ എല്ലാം നമ്മൾ ചെയ്യാറുണ്ട്
Google sheet lover 🌹
Thank you again for a beautifully simple explanation 🙏
Done. Ignore previous message. Thank you so much
Sir.Appreciations and Thanks. Highly useful utility. Looking more going ahead
You are great in this. Love ❤
try cheydu its working. very helpful
Appreciated!! thanks for sharing
😀👍
As always, it's a very good class sir !
Sir
Ithe Microsoft Excel le cheythe outlook l connect cheyan pattumo.
Very useful video. Thanks 🙏🏼
My pleasure 😊
Can we use Edate formula to find the expiry date within days. Like for tender 15 days time is given, to find whether it is expired or not, can we use Edate formula?
Perfect
Thank you for the amazing content
You are welcome!
Automatic message alert setup cheythathinu shesham, oronnum renew cheythaal athil update cheythathinu shesham Run kodukkano
Great sir 😊
Thank you :)
Very informative video.
Thank you :)
Enik excel expert level padikkanam A2z padikkanam enda vayi step by step class undo
Good explanation. Nice content.
Thank you 😀👍
nice
Worth watching ❤
😀👍
In Status column, valid ayathinu active enn engane add cheyyum?
i have tried by copying your code and made necessary changes and ran the programme; successful, but one one item is shown in the mail every time. why?
How can I trigger a separate email for each item whenever an item got expired.
Google sheets related videos iniyum ponnotte👍😍
🙌
Yes me also google sheet lover👍👍👍
Is this available in Excel?
I don't use Google sheets.
Very good video. Thanks. I don't use outlook. What is the code to get email alert from my gmail account?
You can use any email service.
How to send alerts as HTML Mail (Table structure with coloured rows/columns)
Function EDATE parameter 1 expects number values. But '17-04-2024' is a text and cannot be coerced to a number.
Power B I seperate course undo?
search bar option cheyyyamo?
👍
Small business vendi koodi cheyumallo
Ithu sms aayi cheyyan pattumo
12.56 il 2 cell add akiyappol day left enna column thil -45424 ennu kanaam... Adh varaaradhirikkaan endhanu cheyyendadh
Same column il mouse ila Right button cleck cheyth Format Cell il Number choose cheyttha mathi
11:03:20 PM Notice Execution started
11:03:21 PM Notice Execution completed___________ but no mail coming. alreadychanged the mail address
Google sheet on the computer is not free. Can we get free
Hi Sir
Function EDATE parameter 1 expects number values. But '21/04/2023' is a text and cannot be coerced to a number.
show in expiry date calculation what is the issue?
This can be a result of the local settings with your Google account. If the Locale settings is United States, date should be entered in MM/DD/YYYY format, where as in India we follow DD/MM/YYYY format.
Go to File > Settings > Change the Locale settings to either India or UK. Also change the Time Zone to Indian Standard Time (GMT+05:30)
Now it's working. Thank you
@@XLnCADMalayalam
Google sheet open ചെയ്യാതെ പുതിയ items, date ഒക്കെ add ചെയ്യാനും, നിലവിൽ ഉണ്ടായിരുന്നത് renew ചെയ്യുമ്പോൾ അത് update ചെയ്യാനും കൂടെ ഇതിൽ add ചെയ്യാൻ പറ്റുമോ?? Google form pole ഏതെങ്കിലും സർവീസ് ഉപയോഗിച്ച്?
Nice suggestion. But I haven't tried that yet. If I happen to find a solution, I will let you know.
എന്റെ google mailൽ message വരുന്നില്ല... Execution കറക്ടായി നടക്കുന്നുണ്ട്,permission നും കറക്ടായി കൊടുത്തു.എന്താ കാര്യമെന്ന് മനസ്സിലാകുന്നില്ല.
From my experience, if you have added more columns in the sheet. He has created the add script for the column he mentioned in the video only.
Hai sir
How to add cell reference between contiguous data?
Can you please explain the question with more details. like what is the nature of your data, expected output and more.
💗👌
Alerts via whatsapp nadaukumo
I haven't tried that yet. Better try ChatGPT or Gemini for generating a script for this purpose.
WHEN CLICKING EXTENSION , PAGE IS NOT OPENING AND SHOWING AS BAD REQUEST ERROR 400, IT WORKS ONLY IN INDIA?
You may have logged into two or more gmail accounts. Sign out, login into one of them and try again.
Function EDATE parameter 1 expects number values. But '14/08/2023' is a text and cannot be coerced to a number. INGANE ERROR VARUNNU
change the date in mm/dd/yyyy, it will work 👍
Car rental income and expence salary or video cheyyo
So, I recommend watching the videos on the basics and try to create the Excel Template yourself. Wish you all the best😀👍
How to write code
Extensions tab engana add cheyyunnath
You don't need to add Extensions tab. It's a part of Google Sheets.
Ith Excel il cheyyan pattumo
Technically it can be done. But automatic mail generation with Excel on Desktop will not be that easy.
@@XLnCADMalayalam i created the sheet on google and done all. but email is not working. checked permissions also. mail id changed to mine. debug also checked and not found any error
If the "Months" is Date, How to Write the Code
Use DAYS() formula
Suggestion Only:
=IF(E4