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 ...
... tasks down the first column, and time spent in the form of person days in the cross-join.
Why?
Currently the smallest bookable time by low-level tape monkeys and techies is 30 minutes (Managers ...
... the first is the string to start with, the second is the number of spaces to pad with.
//
// set number of times to iterate through loop (plus 1)
v_CheckDaysAhead = 7;
//
// create a string ...
What?
An article on something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and ...
... about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed the process above and it took immediate effect...
Update 2024
So ...
What?
Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous ...
... Tools"
Caveats
Only make the changes necessary to how you like it. You will find issues with trying to undo some parts and tweaks as these will consume a lot of time (anyone remember the day ...
... in a subform called "Mondays" then to click a button which copies it to the remaining working days.
How?
So I have a form with 6 subforms which list staff/employee shifts from Monday to Saturday. ...
What?
A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays.
Why?
Wanting to create a schedule for availability over the next ...
... but I have since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works.
Why?
This took me several days and in the end only going through various forums ...
... belongs to
Search for employees of the same department (team members) who have booked the same days off (ie count holiday clashes)
Prevent an employee for applying for leave if over 80% of the department ...
Ergonomic adjective
"relating to or designed for efficiency and comfort in the working environment."
So it's pretty important not to be slouching over the coffee table for hours or days on end. I ...
... the first Monday of the month (ignoring bank holidays) or to say the last Tuesday of the month.
How?
Quite easily. For the first Monday of the month, it is likely that even if today was the first ...
What?
Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds.
Why?
Here are some examples of what ...
... "Credit Note - 30 Days";
// we want the 30 from the above string
How?
I'm aware of the getAlphaNumeric() function in Zoho and I can remove the letters with removeAllAlpha():
v_PaymentTermsAlphaNum ...
... I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I tried the example as per the Apimo documentation and it worked! There were a few adjustments ...
... registering for username reminders, password resets, or e-mail changes.
The key stored on the device expires after 30 days and requires you to login again if you have not used this app in that time. ...
... But if CODE is not populated,
-- Using &G[COD.SRS:•|•]&ABLANK="*LookupFailed*"
-- yields:
A colleague of mine found this ABLANK solution. It took two of us the best part of two days to come up ...
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.