Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails =...

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

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

03 November 2022 ID") AS "Invoice ID", MAX(inv."Invoice Date") AS "Invoice Date", MAX(abs_month(inv."Invoice Date")) AS "Invoice Month Year", MAX(inv."Invoice Number") AS "Invoice Ref", MAX(inv."Invoice Status") AS "Invoice Status", MAX(invitm."Buy Price") AS "Invoice...

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

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 v_TotalHours := 0 v_YourProfile := "" v_YourEmail := "" v_YourBrowser := "" v_YourName := "" v_Message := "" v_YourDate := A_Year "-" A_MM "-" A_DD b_KeepOpen := false v_RunFolder := A_ScriptDir "\Run_" v_YourDate "_" A_Hour "-" A_Min ;...

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

Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Pose Sitting With their Back to the camera Period / Age {module title="Joel Lipman's List of MidJourney Times"} in the year «Year» 60s 90s Autumn during the Dark Ages at Dawn at Dusk in the Evening Futuristic during Golden Hour Historical during the...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've...

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

ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 console.log(response); }); }); */ /* ************************************ */ /* Some non-Zoho JavaScript */ /* Set Copyright Year */ var today = new Date(); var currentYear = today.getFullYear(); $('footer span.year').text(currentYear); Error(s)...

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

Tim Minchin - 1984https://joellipman.com/articles/_other-misc/tim-minchin-1984.html

16 April 2011 brilliant Tim Minchin using my favourite book as a response to "the Big Fat Quiz of the Year" show hosted by Jimmy Carr. {youtube}CZ7U3Cu4Mr4{/youtube} https://www.youtube.com/watch?v=CZ7U3Cu4Mr4

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

Zoho Deluge - Get Current User IDhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

08 April 2019 #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer functions. Method #1: API v1 userResp =...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", 1, 200, "Year_Month:equals:2021-06") { v_ThisEventTime = r_Event.get("Event_Time"); v_ThisEventNote = r_Event.get("Event_Details"); // //...

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