Search - Joel Lipman .Com

1. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... So we created a custom module called "Candidates x JobOpenings" (with alternative API name as "CustomModule6"). Just to add to the complexity of the task, the client has their own reference for Candidates ...; Created on 08 February 2023
2. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
3. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at ...; Created on 24 October 2020
4. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; Applies to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without ...; Created on 25 January 2016
5. Two icons created on Android: / AndroidOS /; What? If you're installing an app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. ...; Created on 20 October 2014
6. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; Applies to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created ...; Created on 22 November 2013
7. Create Read-Only Database User in SQL Server: / Databases /; The following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security ...; Created on 09 November 2010
8. ZohoCRM: Import Attachments: / Zoho /; ... This is a "zcrm_" prefixed ID of the user who owns the attachment. Modified By Id: This is a "zcrm_" prefixed ID of the user who modified the attachment. Created By Id: This is a "zcrm_" prefixed ID of ...; Created on 16 January 2023
9. Zoho Deluge: Generate a loop or list of any size: / Zoho /; What? This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts ...; Created on 21 October 2022
10. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... @ https://api-console.zoho.com/) Select your "Self Client" Enter in the applicable Scope(s): eg. ZohoSign.documents.ALL,ZohoSign.templates.ALL (possibly incl. ZohoSign.account.ALL) Click on "Create" You ...; Created on 17 October 2022
11. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; What? A noteworthy article in my opinion on how to send a CRM quote record using a template the customer created from a button. Why? Yes you can do this already by going to the record, clicking ...; Created on 18 August 2022
12. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... the function this worked as expected. Now put it on a workflow where the settings were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers ...; Created on 17 August 2022
13. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... ZohoInventory.packages.READ ZohoInventory.shipmentorders.CREATE ZohoInventory.shipmentorders.READ // // init (put your own ZohoBooks/ZohoInventory Org ID v_BooksOrgID = 123456789; // // ...; Created on 14 July 2022
14. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... fields in Zoho Inventory... and the list goes on. So in my job, we tend to create a few custom functions which will download any item from eBay to Zoho Inventory and vice-versa. Easy to make the function ...; Created on 31 March 2022
15. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... form to download the attachments and upload them to the Creator "Document" form: // // get attachments v_NoteAttachments = ""; m_SortCriteria = Map(); m_SortCriteria.put("sort_by","Created_Time"); m_SortCriteria.put("sort_order","desc"); l_Attachments ...; Created on 11 March 2022
16. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... for this, I created the following Creator form: The fields: Calendar Day Select (link name: Calendar_Day_Select || type Radio) Form CSS (link name: Form_Css || type Add Notes) Selected Value for ...; Created on 09 March 2022
17. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of code to remind me. How? ...; Created on 02 March 2022
18. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... needs information from additional apps installed on the Shopify store. Why upgrade to the latest version for Shopify when private apps created before February 2022 won't be deprecated? Because the ...; Created on 14 February 2022
19. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... String crmAPIRequest Outputs: output message to user Date Created: 2022-02-11 (JoelLipman.com - Joel Lipman) - Initial release - Checks the user profile ...; Created on 11 February 2022
20. Zoho CRM: searchRecords with sorted results: / Zoho /; ... init l_Pages = ; v_PerPage = 200; m_SortCriteria = Map(); m_SortCriteria.put("sort_by","Created_Time"); m_SortCriteria.put("sort_order","asc"); // add in additional search criteria m_SortCriteria.put("Processed_by_Function","false"); // ...; Created on 10 February 2022