Assuming output is required, the following 89 results were found.
-
fixed to the header of every page. The logo image was quite a big image at 2501x805 pixels. By resizing it to the final output size (464x99 pixels), cropping out excess whitespace, and re-uploading this fixed the problem. Step #1 Remove any images that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
} else { v_Center:= v_x1 a_MyArray[1,0] := v_x1 a_MyArray[1,1] := v_y1 a_MyArray[1,2] := v_x2 a_MyArray[1,3] := v_y2 } } ; output test v_Leftest := a_MyArray[0,0] v_Central := a_MyArray[1,0] v_Rightest := a_MyArray[2,0] MsgBox 1: %v_Leftest% 2:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
// ensure this is the corresponding module API name in CRM v_BooksAPIBase = "https://books.zoho.eu/api/v3"; // // init v_OutputMessage = ""; v_CrmSoRef = ""; v_CrmSoID = 0; // // get books so name (sales order number) r_BooksSoDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= ""; v_RelatedListXML = v_RelatedListXML + "No records found"; v_RelatedListXML = v_RelatedListXML + ""; } // // output return v_RelatedListXML; in Zoho Books // // find all related quotes l_DataRows = List(); v_QuoteRefID = "0"; v_CrmOppID = "0";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// do stuff here... eg getting data fields, generating a title and setting the title: input.Title = " Hello World "; // // output input.Note_Preview = input.Title; // // re-enable auto-update preview input.Update_Preview=true; To any other fields I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // push to ZohoBooks r_CreateSO = zoho.books.createRecord("salesorders",v_BooksOrgID,m_BooksCreateSO,"ab_books"); // output response info r_CreateSO; // read response if(!isnull(r_CreateSO.get("salesorder"))) { v_SalesOrderID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= v_NextWorkingDay.addDay(2); } // add to list of allowed dates l_AppointmentDates.add(v_NextWorkingDay); // // output and add 1 more day to loop info v_NextWorkingDay.toString("EEEE") + " :: " + v_NextWorkingDay.toString("yyyy-MM-dd"); v_NextWorkingDay...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= v_ToMonthDate1.subDay(v_DayIndex); if(v_CheckDateEnd.toString("E")=="Sun") { v_DST_EndTime = v_CheckDateEnd; } } // // output info "Start Date (Current Year): " + v_DST_StartTime.toString("EEEE, yyyy-MM-dd HH:mm"); info "End Date (Current Year): " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_HtmlEntity.keys() { v_StringToDecode = v_StringToDecode.replaceAll(v_HtmlKey, m_HtmlEntity.get(v_HtmlKey), true); } // // output return v_StringToDecode; } Usage: v_TestString = "Father & Sons"; v_DecodedString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // curl (zoho invoke) request r_GetProduct = invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; // // output info r_GetProduct; GraphQL: Usage example: And here's a quick test to retrieve the 5 recent products using the GraphQL API: // // app...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Started"); // // send request and create record r_CreateMeeting = zoho.crm.createRecord("Events",m_ScheduleMeeting); // // output response (for debugging purposes) info r_CreateMeeting;
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ l_Params.toString("&"); r_AccessToken = invokeUrl [ url: v_Url type: POST ]; // // output v_AccessToken = ifnull(r_AccessToken.get("access_token"), ""); // // use the access token to query requests m_Header = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in l_GeneratedList { if(v_Index>0) { l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd")); } } // // output info l_CheckDates; // // outputs: 2022-10-22,2022-10-23,2022-10-24,2022-10-25,2022-10-26,2022-10-27,2022-10-28
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
//info l_Candidates; // // sanity check to output that it did something info "Done: " + zoho.currenttime.toString("HH:mm:ss"); // // loop through our list for this page for each r_Candidate in l_Candidates { v_CountTotal = v_CountTotal + 1;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // note the cursor so that we resume from the last cursor v_Cursor = r_Node.get("cursor"); // // output to console for debugging purposes info "Page #" + v_Page + "::" + v_CountTotal + "::" + v_VariantSKU + "::" + v_Cursor; } // // capture whether to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // yields: // Me,Myself,I // a,b,c Additional Adding to a screen output: eg. a button response or response of info: try holding down the ALT key and pressing 255, then releasing the ALT key and save the change to your code. This will not display a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= leftpad(" ",v_DaysAgo).replaceAll(" ",",").toList(); // // loop through for each index v_Index in l_GeneratedList { // output to developer for debug purposes v_Date = zoho.currentdate.subDay(v_Index).toString("yyyy-MM-dd"); info v_Date; // // set...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a fresh instance of Zoho Inventory. In this task, we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet. How? Similar to how we retrieved the eBay active listings (see article link above), we're going to use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_OrderDate = zoho.currentdate.toString("yyyy-MM-dd"); v_Page = 1; v_PerPage = 10; m_Output = Map(); l_Costs = {11,13,15,17,20}; b_DebugMode = true; l_DebugMessages = List(); l_DebugMessages.add("eBay Order ID: " + p_eBayOrderRef);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF