What?
This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit.
Why?
We're creating a custom module ...
What?
This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging ...
... as an example, the equation that's happening is:
$thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession']));
$this_time_from1 = date("H:i", strtotime($sub_row['TimeFromSession']));
$this_time_to1 ...
Situation
The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just ...
... true which will automatically send it and mark it as sent. As the function I use before this to generate the invoice, also updates an invoice, I wanted to keep the action of sending separate so that staff ...
... You would need to record the attachment ID and only push it to Analytics if Analytics doesn't have that attachment ID in its table already... or updates it if it does.
You might want to add to the code ...
... get all active users in CRM
m_UserMapping = Map();
v_Endpoint = "https://www.zohoapis.eu/crm/v4/users?type=ActiveUsers";
r_Users = invokeurl
[
url :v_Endpoint
type :GET
connection:"zcrm"
];
l_UserUpdates ...
... clients set their due dates differently.
How?
The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are.
void fn_ReturnCurrentPaymentTerms()
{
v_BooksOrgID ...
What?
This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records...
Why? ...
... that asked, in this case Zoho Inventory. So for this, I've set up a nightly schedule which checks on all the shipments from a certain date and updates the shipment status for items that have been delivered: ...
... evaluate (specify here your dates [time set to midnight])
v_timeFrom = zoho.currenttime.subDay(0).toString("yyyy-MM-dd'T'00:00:00.000'Z'");
v_timeTill = zoho.currenttime.addDay(1).toString("yyyy-MM-dd'T'00:00:00.000'Z'");
//
// ...
... it to a list, then lets you generate an array or list of any size.
Why?
My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers ...
... and payment date to appear on the invoice.
How?
This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields. Executing ...
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 ...
... dates given a number of days
So here's another scenario where you have a start date and you are asked to list the working days, 7 days after the start date. I'm aware of the method .workdaysList():
date1='2022-07-21';
date2='2022-07-29';
info ...
... it says
m_ShippingAddress.put("is_one_off_address",true);
m_ShippingAddress.put("is_update_customer",false);
// send the request via API (change connection name to your own)
r_UpdateSO = invokeurl
[
...
... was loaded. Then I would tell Audit_Change to only trigger the workflow if it had waited about 5 seconds till after this datetime to allow auto-updates to happen. This method is fine for 1 or 2 fields ...
... and updates the Opportunity/Deal/Potential record. In this example, the custom field is called "Division":
//
// init
v_DealID = ifnull(p_DealID,0);
r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID);
//
// ...
... have already booked the requested dates off.
In other words, if there are 10 people in a department/team, and 8 people have booked tomorrow off, prevent a 9th team member booking tomorrow off.
...
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.