What?
An article to document how I calculated the start and end dates of when Daylight Savings Time is in effect.
Why?
Admittedly, most of Zoho apps have this built-in but here's some snippets ...
What?
A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds.
Why?
I've done this in lots of other systems but here's one in Zoho ...
What?
So this is a quick article on how to maintain an aspect ratio when resizing an image.
How?
These are the calculations to work out the new height given the width or the new width given the ...
... loop this to get all the categories
// let's calculate how many pages we need
v_MaxPages = ceil(v_TotalProducts / v_PerPage);
//
// generate a loop list
l_ProductPages = " ".leftpad(v_MaxPages - 1).replaceAll(" ...
... module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the ...
... in the subform:
// initialize
var v_CalculatedNumberOfSkills = 0;
// get the Opp stage
var v_OppStage = ZDK.Page.getField('Stage').getValue();
// get the Skills subform
var l_SkillsSubform = ...
... ed to include those credit notes for refunds, etc. This tweak is if we want to calculate credit notes issued in a particular month rather than the one-to-one with an invoice as profits in the past wou ...
What?
This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party.
Why?
The use-case scenario is that our Creator server ...
What?
A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting.
Why?
As developers, we're keep account of our time and we are currently ...
... the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked ...
What?
A quick article to document how to calculate the distance "as the crow files" between two coordinates given the latitude and longitude of each.
Why?
Well, you can pay for a good Google solution ...
What?
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...
What?
A quick article on how to display a OK/Cancel popup which I use as a message to the user for debug purposes.
Why?
It's similar to javascript's message box or confirm box, only Android let's ...
... and have it calculate to the nearest second. I call this latest app "byeBU" and this is version 0.4 Beta (unofficial app).
Why?
Something to do...
How?
The following code is using AutoHotkey ...
... opposite, where the week starts on the previous Saturday and ends on the last working day of the week.
The Solution
Where "givenDate" is the given date you have to calculate the last working day ...
... (I will be checking "Student Username" first as "Student Reference" must be calculated and not blank/null):
So I tried setting the "Available Values" as suggested by Stack Overflow to gets its value ...
I might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.