Search - Joel Lipman .Com

1. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... I'm using it so I'm documenting it. For this example, we're going to use my use-case scenario mentioned earlier: first-line agents can't select a specific option in the Lead Status picklist: Login ...; Created on 11 February 2022
2. Zoho Deluge: Sort a Map by a specific field: / Zoho /; What? This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort ...; Created on 29 January 2021
3. SSRS Expand specific drilldown by default: / SQL Server Reporting Services /; I thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This ...; Created on 23 February 2011
4. Zoho Creator: Input Color Picker: / Zoho /; What? An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our ...; Created on 14 October 2024
5. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... */ // // initialize m_RelatedList = Map(); v_BooksOrgID = organization.get("organization_id"); v_SalesOrderID = salesorder.get("salesorder_id"); // // analytics specific table to read data from (enter ...; Created on 09 July 2024
6. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... Why? We're assisting a client implement Zoho People as their new HR solution. Zoho Analytics is used to generate specific spreadsheets for a feed into their third-party payroll system. If the data ...; Created on 02 July 2024
7. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
8. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; What? This is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a ...; Created on 25 March 2024
9. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... to me that perhaps this isn't clearly documented. But there are tips found across the web just not specifically addressing this. How? Here is the code for a test function which downloads 2 files ...; Created on 20 July 2023
10. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... but in the United Kingdom, the week generally starts on a Monday. So let's say there's a schedule that has to be run weekly and include all the orders of a specific week... Just to confuse everyone ...; Created on 06 July 2023
11. Zoho CRM: Change System Field Length: / Zoho /; ... file to change system field labels The fix put simply is a CSS hack. Specifically by inspecting the element, removing some of the CSS attributes on the field we want to change, saving it, then returning ...; Created on 19 June 2023
12. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... Only generate invoice if payment received - Distinguish whether composite based on ebay item specific - Add stock in order to authorize payment creation Date Modified: 2023-02-02 (Joel Lipman) - ...; Created on 27 April 2023
13. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... will have the specific OrgID in the URL). Click on "Add Action" Give it the Action Name "Ask ChatGPT" This action should "Answer a Question" It should be answered by "Construct Answer by Fetching Data" ...; Created on 06 March 2023
14. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
15. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... on Shopify,Modified on Shopify,Published on Shopify"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // app specific v_ShopID ="joels-awesome-shop"; v_ShopifyApiVersion = "2022-01"; v_AccessToken ...; Created on 20 February 2023
16. Zoho CRM: Manage a subform using Client Script: / Zoho /; What? This is an article with a snippet of code demonstrating how to manage a subform using a Zoho CRM Client Script. Why? A client wanted an automation on-the-fly that when selecting a specific ...; Created on 09 December 2022
17. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... one way, in other words, listings on eBay get downloaded to Zoho Inventory but not vice-versa. Then there's an added delay of 4 hours. Then item specifics in eBay's listings don't get parsed into custom ...; Created on 31 March 2022
18. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the value of each radio item will be populated using deluge and what's important to note here is that each picklist/dropdown option includes some HTML, specifically a SPAN tag surrounding the date number ...; Created on 09 March 2022
19. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... a quick test I do retrieving 5 products using the REST admin API: // // app specific r_ShopifyAPI = API_Integration[Connection_Name == "Shopify API OAuth"]; v_ShopID = r_ShopifyAPI.Shop_ID; v_ShopifyApiVersio ...; Created on 14 February 2022
20. Zoho CRM: searchRecords with sorted results: / Zoho /; ... in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple ...; Created on 10 February 2022