Zoho Analytics: Determine profits from invoices and purchase ordershttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 = inv."Invoice ID" WHERE inv."Invoice Status" NOT IN ( 'Draft' , 'Void' ) GROUP BY invitm."Item ID", invitm."Quantity" And lastly we can group by invoices in the month and sum up the profits as well as include the customer name and other invoice...

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

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

20 February 2023 v_CsvRow = l_CsvFileRow.toString(); l_CsvFileRows.add(v_CsvRow); // // note the cursor so that we resume from the last cursor v_Cursor = r_Node.get("cursor"); // // output to console for debugging purposes info "Page #" + v_Page + "::" + v_CountTotal +...

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

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

06 March 2023 m_Create.put("Owner", v_LoggedInUserID); r_Create = zoho.crm.createRecord("GPT_Chats", m_Create); // // add the last question to the messages m_Chat = Map(); m_Chat.put("role", "user"); m_Chat.put("content", v_UserMessage);...

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

Zoho Books: Generate Bank Text File for Downloadhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 File downloads to their workstation Here's what's happening in the background: File is generated FIle is attached to the last record of the source data File identifying number is returned from being attached File is opened in a new tab/window to trigger...

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

Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 = Map(); // // build quote request m_QuoteRecord.put("Name.first_name",v_SellerName_Firstname); m_QuoteRecord.put("Name.last_name",v_SellerName_Lastname); m_QuoteRecord.put("Email",v_SellerEmail); // // other params m_Blank = Map(); // // send the...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 check URL for mail merge template: https://writer.zoho.eu/writer/open/ 0) { v_Filename = v_Filename.subString(0,v_Filename.lastIndexOf(".")); } r_ZS_Download.setFileName(v_Filename + "_SIGNED.pdf"); // // attach file to record of module r_AttachFile =...

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

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

25 September 2025 to do this nor if writer will just allow us to embed it... but let's give it a go: The page responses query showing only the last survey attempt per respondent I'm going to modify the analytics query above to only return the latest responses that a...

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

Code Troubleshooting Checklisthttp://mail.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 environment? Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation since the service last worked? Suggestions...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Oracle: order by subquery missing right parenthesishttp://mail.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 API v7 style if(l_NewLineItems.size() > 0) { // // build request to send to CRM v7 // m_RecordData should have value from last iteration m_UpdateQuote.put("Subject",m_RecordData.get("Subject")); m_UpdateQuote.put("Quoted_Items",l_NewLineItems);...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 record var v_ThisRecordID = $Page.record_id; // get the full name of this contact (not sure why this returns both first and last) var v_ContactName = ZDK.Page.getField('Last_Name').getValue(); // get the email of this contact var v_ContactEmail =...

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

Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 thread, and you are not allowed to create more than one thread per topic. No Posting Personal Info - You may not post your last name, or your street address on TEU. This is because this information then becomes accessible to anyone. No Threatening to...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Applying a button and centering it in the RocketTheme Affinity templatehttp://mail.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 found that there's a lot more to do than just that. Instructions Open the templates/rt_affinity_j15/index.php Look at the last few lines with the original code (below) For this website template: I've added the module-dark classes. Specified float:none...

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

View your available module positionshttp://mail.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 module positions. You will need to repeat the process when you select a different template but otherwise the bookmark will last as long as you keep that template.

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

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 => what params? I couldn't find any A little more to change A-Z or Z-A change ASC (ascending) to DESC (descending) in the last bit of the above code. To sort by 2 categories, change ' ORDER BY title ASC' to 'ORDER BY title ASC, hits DESC' where 'title'...

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

Developer's Checklist: Taking over a projecthttp://mail.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 could not accurately describe what the system was for and what it does. The developer had created the system to only last during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Newbies guide to be the local computer guyhttp://mail.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 Source: http://www.reddit.com/r/IAmA/comments/9usm7/iama_local_tech_repair_man_i_run_my_own_business/ I love the last point. Down talk as opposed to hype and then produce. Even with most services this nearly always guarantees a happy customer. "So this...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const WM_SYSKEYDOWN = $0104 Const WM_SYSKEYUP = $0105 Const WM_SYSCHAR = $0106 Const WM_SYSDEADCHAR = $0107 Const WM_KEYLAST = $0108 Const WM_IME_STARTCOMPOSITION = $010D Const WM_IME_ENDCOMPOSITION = $010E Const WM_IME_COMPOSITION = $010F Const...

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

Basic Webpage Controls with JavaScript / COMhttp://mail.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 (original is AHK Basic only, but here is an AutoHotkey_L Version by sinkfaze) Basic Webpage Controls COM Object Reference Last edited by jethrow on Wed Jun 22, 2011 10:18 pm; edited 22 times in total Source: Jethrow @ Autohotkey Forums

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

MySQL parameters in Excel 2007 PivotTableshttp://mail.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 The one query to rule them all SELECT CONCAT(s.LogID, ' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3...

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