Search - Joel Lipman .Com

1. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; ... part of this, ie "String4". So I need to delimit based on the dot/period (.) and use substring in a sort of reversed form. For argument's sake, I'm assigning this string to the variable "haystack". ...; Created on 28 January 2013
2. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... :POST connection:"my_books_connection" ]; v_OutputResponse = "Thank you for accepting your quote! We'll be in touch soon to finalize the next steps and get everything ready."; } else if(v_Intent ...; Created on 04 November 2024
3. Zoho Creator: Input Color Picker: / Zoho /; ... span label span"; // create a new row after every 10 boxes (1 box = choice-table-row + choice-table-cell + choice-table-row = 3 divs) v_CssStyle = v_CssStyle + ".zc-Color_Picker div:nth-child(30n+1)"; ...; Created on 14 October 2024
4. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
5. ZohoCRM: Make either Mobile or Email mandatory: / Zoho /; ... on a Zoho CRM contact record is used to authenticate the contact on a Wordpress portal. OTP or 2FA or MFA or OTC is in effect however; so a contact email OR phone number is required. Both aren't required ...; Created on 03 October 2024
6. What can MAGA’s do to stop Biden from cheating again?: / Jokes /; A guy goes to a bar and is served by a robot bartender. The robot says, "What'll you have?" and the guy says, "A martini." He then gets the best martini he's ever tasted. The robot says, "What's your IQ?" The ...; Created on 28 August 2024
7. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... onto the template document; every time. What if I told you we can code a single button on the record which does all of that for you; with only you needing to approve the document before it gets sent ...; Created on 06 August 2024
8. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... basis at 1am in the morning every day. This will be added to the client's Zoho People instance which will check the datasource metadata via the Analytics API. Add a custom scheduler in Zoho People Login ...; Created on 02 July 2024
9. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... is sitting right now. The code snippet to get the item record from the price book Note that I'm using a connection called "zbooks" and it has every permission under the sun (the naughty ZohoBooks.fullaccess.all) ...; Created on 23 May 2024
10. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; What? An article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person ...; Created on 14 May 2024
11. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... repeats the header on every page. The key here is the HTML attribute zcpage-headerhtml: My Company Ltd Test Street, Test County TEST1 ZIP1 +44 (0)1234 567890 This email address is being protected from spambots. You need JavaScript enabled to view it. ...; Created on 07 May 2024
12. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... that Shopify would intermittently remove our webhooks. This would make the entire synchronization of the system go out of whack and some records would slip through the net while every day, the process ...; Created on 22 April 2024
13. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... in Zoho Inventory and this feeds the website. More than often, however, this request comes in when the customer has already been setting their Zoho environment up and the Wordpress site has the more information. ...; Created on 15 April 2024
14. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... We have no intention of creating a new record per file... Saying that, the file name will change every time it is updated as you will see. Also note, I have a form called "Document", a report called ...; Created on 25 March 2024
15. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... the customer record. Instead, when building the invoice, this had to be added (don't ever remember having to do this) as contact_ids (array/list). Instead the below script will show you how to use this ...; Created on 07 March 2024
16. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; What? This is an article just repeating a script from the Zoho Kaizen series allowing a confirmation box (something lacking in Zoho Creator - but that every app outside of Zoho has) as well as a popup ...; Created on 06 February 2024
17. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... so that I get the popup to enable bi-directional rather than via the tickbox. The below code is added to a trigger whenever the ticket form is submitted either on creation or modification. The ...; Created on 26 January 2024
18. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... Uploads an image to workdrive and returns the public link Date Modified: ??? - ??? ttps://workdrive.zoho.com/apidocs/v1/filefoldersharing/shareeveryone ******************************************************************************* ...; Created on 05 December 2023
19. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... it works then the connection string is fine. What I was doing?: I'm not saying this is the solution to whenever you get the above error; I'm just saying this what I was doing and this is what fixed ...; Created on 04 October 2023
20. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... that file sat on someone's mailbox. It must be downloaded (as in browser downloads it to the computer immediately) and then removed from wherever it was downloaded from... All within ZohoBooks without ...; Created on 02 October 2023