for each rec in Calibration_Master[ID != null] { calhist = Calibration_History[Calibration_Master_ID == rec.ID]; if(calhist.Cal_Due_Date < zoho.currentdate && calhist.Status != "Completed") { calhist.Status="Overdue"; } if(calhist.Cal_Due_Date >= zoho.currentdate && calhist.Status != "Completed") { calhist.Status="Due"; } if(rec.Cal_Due_Date < zoho.currentdate) { rec.Status="Overdue"; } if(rec.Cal_Due_Date >= zoho.currentdate) { rec.Status="Due"; } }
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter