Search - Joel Lipman .Com

1. Windows 7: System Clock is constantly going out of sync: / Windows OS /; The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and ...; Created on 28 January 2010
2. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... basic HTML/CSS knowledge): Place the cursor where you want the button and give it some text, I'm going to start with Accept Quote Then click on the link icon and give it the link noted from the UR ...; Created on 04 November 2024
3. Zoho Creator: Input Color Picker: / Zoho /; ... but important to some staff... How? In an earlier article, I've shown how to change a radio type field in ZohoCreator into a Carousel type of interface. This time, we're going to repurpose and restyle ...; Created on 14 October 2024
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... to ask us to build this solution for you. It can take a few days but it will save your staff a ton of time per week! What your staff see: How? So we're going to create a button. Let's use ...; Created on 06 August 2024
5. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... hitting statement execution limits and rather than proposing an upgrade or add-on to the subscription plan; we wanted some proof using code. How? We're going to use a quick snippet of some code. ...; Created on 31 July 2024
6. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... workspace you want to create the monitoring system. Preferably use the workspace that has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select ...; Created on 25 July 2024
7. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... les order ID" = soi."Sales order ID" Initially we thought we could take the purchase order by simply going through the comments but this only shows Purchase Orders raised from a Sales Order w ...; Created on 09 July 2024
8. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... and the system managers need to be notified in advance of any errors with the intention to be able to correct any inconsistencies themselves. How? We're going to add a scheduled workflow on a daily ...; Created on 02 July 2024
9. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is that the customer wants the item/product rate taken ...; Created on 23 May 2024
10. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; What? There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is ...; Created on 07 May 2024
11. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... > Schedules > Create New Schedule I'm calling my schedule "Shopify - Check Webhooks" and I'm going to execute a writing function. It has a function name of "fn_Schedule_ShopifyWebhooks" and a display name ...; Created on 22 April 2024
12. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... (aka the Quote Builder) will need to post a new quote to the system as well as show previous orders. How? We're going to use the Zoho Extension SDK. You should refer to my previous linked article ...; Created on 14 March 2024
13. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... Display As: "Image" You can now specify the size of the image as well (16x16 is a tad small). Caveat(s): A bit work needs to be done to the code above to prevent attachments from going in twice ...; Created on 05 December 2023
14. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; What? A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function ...; Created on 04 October 2023
15. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... + v_BillID + "/attachment?organization_id=123456789" type: POST files: m_Attachment connection: "zbooks" ]; Open the file / Download via Browser We're going to use an openUrl() function here ...; Created on 02 October 2023
16. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM an ...; Created on 18 September 2023
17. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... // returns 2020 You should also pad single digit week numbers if we're going to store a year week value: v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() == 7,zoho.currentdate.subDay(1),zoho.currentdate).toString("w"); v_ThisCurrentWeekNumberPadde ...; Created on 06 July 2023
18. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... "ITEM CREATE RESPONSE FOR " + v_ItemID; info r_CreateItem.get("message"); Error(s) Encountered items with opening stock cannot be deleted, set the opening stock to zero: Guess who's going to hav ...; Created on 04 May 2023
19. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... article link above), we're going to use the GetOrders call for order (sales) management. /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year ...; Created on 29 March 2023
20. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... I always resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to join this to the contacts data table. So I'm going to make this ...; Created on 20 March 2023