Search - Joel Lipman .Com

1. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
2. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... The workaround for staff is to round this up manually and then save the record. But this can be an annoying overhead, especially if it can be auto-corrected with a client script. Pre-amble For ...; Created on 13 December 2023
3. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... " and it should popup with ...things you can ask me... with one being "Ask ChatGPT" Click on it and then ask away:... Keeping a Conversation So annoyingly, the variable broadcast was unreliab ...; Created on 06 March 2023
4. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... m_Record.toString(); } Without a regex solution and the replacement back to commas then the above outputs: Actions Do you want to get rid of the annoying escaped double-quotes ...; Created on 26 August 2021
5. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... Books will create 3 custom modules in your CRM under the tab "Zoho Finance". There is a lag/delay in the synchronization of Zoho Books to Zoho CRM and vice-versa. Annoyingly the attachment does ...; Created on 15 May 2020
6. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... time field in Deluge So annoying but sometimes you want to insert a date/time value into a date/time field and you get the error: v_MyDateTimeString = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ssZ"); // ...; Created on 06 February 2020
7. Reorder Columns in a Table: / Databases /; ... this: Method: MySQL ALTER TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the default properties it had before the move ...; Created on 22 July 2013
8. MS Excel - Sort pivottable column headings by date: / Excel /; ... "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero: Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong tree. If I padded ...; Created on 12 April 2013
9. List all cron jobs for all users: / Linux /; ... Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning ...; Created on 04 May 2011
10. CSS Background Without Causing Scrollbars: / Cascading Stylesheets /; ... is a bit annoying because you scroll to the right and theres nothing but some background image. Also the footer was at 100% so it got cut off if you scrolled horizontally. Aim / Objective To have ...; Created on 23 April 2011
11. RokDownloads Manager does not list files: / Joomla /; ... far the solution has been to open this with Internet Explorer with a cleared-cache. A little annoying in view how much I hate Internet Explorer and it's various versions which only work with particular ...; Created on 28 October 2010