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. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... your details > Confirm via Email Create an app as described under Get Access section Click My Apps on the portal website Click on the App you created Note the API Key by clicking on "Show Key" ...; Created on 21 March 2023
9. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... t1 PIVOT ( MAX(t1."Member Status") FOR t1."Campaign Name" IN ( "Campaign 1","Campaign 2","Campaign 3" ) ) t2 The bigger query: Now create another query (better to refresh the page so ...; Created on 20 March 2023
10. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... r " + v_Token); m_Header.put("Content-Type","application/json"); // // build params of request m_Params = Map(); m_Params.put("model","gpt-4"); m_Params.put("messages",l_Messages); // // https://platform.openai.com/docs/api-reference/chat/create m_Params.put("temperature",0.8); m_Params.put("n",1); m_Params.put("max_tokens",256); m_Params.put("presence_penalty",0); m_Params.put("frequency_penalty",0); ...; Created on 06 March 2023
11. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading ...; Created on 01 March 2023
12. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: ...; Created on 28 February 2023
13. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... you know the code to remove this field, then you know what I mean. In Workflow mode: add a workflow to the form whenever it is created or edited, on load of the form; I call mine "OnLoad". For Deluge ...; Created on 28 February 2023
14. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... title handle status createdAt publishedAt updatedAt } updatedAt } cursor } pageInfo { hasNextPage ...; Created on 20 February 2023
15. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... for those who want to integrate ChatGPT with ZohoZIA. Why? Previously, I would edit the message handlers of a Cliq Bot I created but it would only understand the questions I have programmed it to ...; Created on 13 February 2023
16. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... an A4 paper on it's side) /prefer option set This will create custom parameters/argument suffixes you can add which represent a whole string of words that you may use often but don't feel like typing ...; Created on 11 February 2023
17. 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
18. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; What? An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard ...; Created on 03 November 2022
19. 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
20. 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