MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 07:30 07:30 07:30 07:00 00:00 00:00 37:00 I 03:45 03:30 03:00 03:30 00:00 00:00 00:00 23:00 Method 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user....

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting how to do this and it takes about an hour to go through the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 your region. Sign in with your Amazon username and password. After you have logged in, look for the menu option Account and Lists which should show somewhere along the top right of the home screen. Under Account and Lists, look for Your devices and...

• Type: Article
• Author: Joel Lipman
• Category: Kindle
• Language: *

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10; b_HasNextPage = true; v_Cursor = ""; l_CsvFileRows = List(); // // start preparing CSV file to email for debugging purposes v_ReportCSV = "Ref,Shopify SKU,Shopify Title,Shopify Product...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 // // initialize v_Response = previousParam; m_Response = Map(); m_Response.put("todo","prompt"); l_Messages = List(); // // capture latest message from user v_Message = ifnull(userInput,""); m_Thread = Map(); m_Thread.put("role","user");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 and I would like to use it as a reference for when I forget how to do this. The use-case here is that we have a dropdown/picklist on a CRM invoice record that has the options of "Deposit" and "Final Balance". This rewrites the invoice line items to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 ]; m_GoalsResponse = ifnull(r_GoalsData.get("response"), Map()); l_GoalRecords = ifnull(m_GoalsResponse.get("result"), List()); for each m_GoalRecord in l_GoalRecords { v_CountTotal = v_CountTotal + 1; l_GoalKeys = m_GoalRecord.keys();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 p_ContactID); v_ContactEmail = r_ContactDetails.get("Email"); info v_ContactEmail; // // the following related list couldn't be found hence the change to the summary query in analytics // l_ContactSurveys = zoho.crm.getRelatedRecords("Zoho_Survey",...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge - Get Full Day Namehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 My_Date = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // lists Day_Names =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 from the end-user. The one to rule them all: This is a function I pulled from the Autohotkey forums submitted by SKAN which lists all the functions for a specified Dynamic Link Library (DLL) along with an inputbox for convenience: InputBox,...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Vertically align an asterisk on a linehttps://www.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 So I have an unordered list of values (*, 1, 2, 3...) and for styling reasons I want the asterisk to be the same size as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 Registry as default settings. /TBD :: wait for sharenames To Be Defined (retry error 67). :: :: Logging Options : :: /L :: List only - don't copy, timestamp or delete any files. /X :: report all eXtra files, not just those selected. /V :: produce...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Display category. - Enhancement: Reorganized parameters "Module Settings". - Enhancement: Parameters switched from radio to list type. - Enhancement: Aesthetic tweaks for Joomla v3 admin panel. - Date Uploaded: Mon, 14th Jul 2014 Download 3.1...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 v_State = "testing"; v_ResponseType = "code"; v_Access = "offline"; v_Prompt = "consent"; l_Params = List(); l_Params.add("scope=" + v_Scope); l_Params.add("client_id=" + v_ClientID); l_Params.add("state=" + v_State); l_Params.add("response_type=" +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded by: l_Users = zoho.crm.getRecords("users") or r_User =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 looping through rows here but it wants the internal name here eg. "1234567890123_temp.pdf" // // build the URL l_BuildUrl = List:String(); l_BuildUrl.add(v_CreatorDownloadBase); l_BuildUrl.add(v_AppOwnerName); l_BuildUrl.add(v_AppLinkName);...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 of employees, we will use zoho.people.getRecords as a search: // get total "team members" in department l_SearchCriterias = List(); m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","Department"); m_SearchCriteria.put("searchOperator","Is");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 below but one that worked was initially guessed as "none" but then later found in the documentation could also be an empty list []. So there are a few trigger options but I'm listing the one(s) to stop workflows below to see if this helps anyone: Stop...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 for use in the code below Edit the Message Handler code ChatGTP 3.5 Turbo // // initialize m_Response = Map(); l_Messages = List(); v_Message = message.trim(); // // if the message contains a question mark, send it to OpenAI if(v_Message.contains("?"))...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 straight away (less than 1 second requirement) to Shopify with "yes received" response. As such, here's a function which lists the Shopify webhooks it's responsible for and if it finds one missing, it is to restore it. This function only has to check on...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *