Assuming each is required, the following 208 results were found.
Here's the standard code you'd expect if your Fiscal year starts in January (Divide by 3 and round up): for each v_Month in l_Months { v_Quarter = (v_Month.toLong() / 3).ceil(); info "Month: " + l_MonthNames.get(v_Month-1) + " :: Quarter: " + v_Quarter;...
// // build params m_Params = Map(); // set to application or user to see the notifications for each m_Params.put("PreferenceLevel","User"); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); // // convert to xml and replace...
// // start with first date to add (check if it is a working day) v_NextWorkingDay = v_GivenDate; // // loop through each day to set an appointment for for each index v_Loop in l_NumberOfDays { // skip if Sunday (add 1 day)...
]; if(!isnull(r_Response.get("fields"))) { // loop through every field to find the customer's timezone one for each r_Field in r_Response.get("fields") { if(r_Field.get("api_name") == "Customer_s_Timezone") { // loop through all the picklist values of...
l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100; for each c_Appt in l_Appointments { // // get package references specified in a previous multi-line text field l_PackageRefs =...
so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is...
"I'"}; // // deal with double barrelled surnames l_FormattedLastName = List(); l_LastNameParts = v_LastName.toList("-"); for each v_LastNamePart in l_LastNameParts { // // default to proper v_LastNamePart = v_LastNamePart.proper(); // // if exception...
l_PaginationParams.toString("&") type: GET ]; v_TotalProducts = 0; v_TotalCategories = r_Categories.toJSONList().size(); for each m_Category in r_Categories.toJSONList() { if(!isNull(m_Category.get("count"))) { v_TotalProducts = v_TotalProducts +...
m_Blank = Map(); // // evaluate v_BooksOrgID = organization.get("organization_id"); // // loop through line items for each m_LineItem in salesorder.get("line_items") { r_BooksItem = zoho.inventory.getRecordsByID("items", v_BooksOrgID,...
= 0; v_CountDeleted = 0; // // pagination v_PerPage = 500; // // loop through pages to fetch as many as possible for each v_Page in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor * v_PerPage; // // get unique product...
users = userResp.executeXPath("/users/user"); if ((users != null) && (users != "")) { userList = users.toList("-|-"); for each user in userList { emailNode = user.executeXPath("/user/@email"); email = emailNode.executeXPath("/email/text()"); if (email...
{ // remember remember the 5th of november l_RememberLookup = List(); if(input.myLookup.size()>0) { for each v_SelectedLookup in input.myLookup { l_RememberLookup.add(v_SelectedLookup); } } } // // clear lookup clear myLookup; // // get list of all...
Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html
pour the rest into a bowl anduse it to lubricate the pan, using a wodge of kitchen paper to smear it round before you make each pancake. Now get the pan really hot, then turn the heat down to medium and, to start with, do a test pancake to see if you're...
copyright... Basically this is the third time I wrote this program, simply because I reghost all my computers (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media...
Generation" is set to "NO". (Important! remember to switch this to YES when you have updated all your thumbnails as each thumbnail is one entitlement of the first 100,000 for free. After that there may be a charge or images may come back...
COM Support (recommended) the COM Standard Library - for use with AHK Basic Purpose The purpose of this tutorial is to teach the intermediate AHK user how to start using COM to control webpages. My goal is to provide methods for controlling webpages,...
use EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround and never a solution. Add in the ID of each entry as a field to pull from the database so that anyone can drilldown to the specific logged activity event (smallest unit...
T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html
... Sunday 16/10/2011 A007 08:00 17:00 NULL NULL NULL NULL NULL NULL */ Note that my data is inaccurate as the last row of each grouped data has been changed to NULL. Also note how the actual select query is pulling data from my CTE in its...
to find either 'a', 'b', or 'c' use the following regular expression: [abc] This expression matches the first character in each of the following strings: at bet cot The expression does not match: def Non-Matching Character List Use the non-matching...
on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later....