Zoho Deluge: Proper Case for Nameshttps://joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 they are the same entity but may have uppercased a letter in their name while the other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR...

• 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 Joel Lipman Ltd. All Rights Reserved the JavaScript These are the contents of main.js and is working at time of print: // Start with Zoho SDK stuff ZOHO.CREATOR.init() .then(function(data) { // Initialize var v_ShopifyID = ""; var v_ShopifyEmail = "";...

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

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 { for each m_PriceBracket in m_PriceBookItem.get("price_brackets") { if(v_ThisQuantity >= m_PriceBracket.get("start_quantity")) { if(m_PriceBracket.get("end_quantity") != "" && v_ThisQuantity

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

Zoho Analytics & Zoho People: Monitor DataSource Sync https://joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 "Scheduler" Click on the "Add Scheduler" button Complete the "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 it (requires some basic HTML/CSS knowledge): Place the cursor where you want the button and give it some text, I'm going to start with Accept Quote Then click on the link icon and give it the link noted from the URL made earlier (the one to the CRM REST...

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

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

01 April 2025 line item(s).\n\nAre you sure you want to proceed?', 'Proceed', 'Cancel'); // if "Proceed" was clicked if (b_Proceed) { // start Loader ZDK.Client.showLoader({type:'page', template:'spinner', message:'Re-writing Invoice Line Items...' }); // reset the...

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

Windows 7 and Google Chrome incognito mode by defaulthttps://joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 Basically if you've just started using "incognito" mode with the Google Chrome web-browser, this article is just how to switch the quick launch shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share...

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

Increase Recent Documents Number in Windows XPhttps://joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

28 July 2011 fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just for me: Start > Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New...

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

Reminder on SSRS row separatorhttps://joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have:...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

List last modified files using FTP Command-linehttps://joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 how do I do it using just Microsoft Windows? How? I don't have a clue. Here's what I've got so far: Open a command-prompt (Start > Run > Type COMMAND > OK) Type ftp my_ftp_host (where "my_ftp_host" is the hostname or IP of the server holding my site)...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Regular Expressions in SQLhttps://joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`....

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

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttps://joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

MySQL Transactions in PHPhttps://joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: Our tables must use an engine that supports transactions...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB

Zoho Deluge: Check Time Booking Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-check-time-booking-slots.html

05 December 2018 in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90; bool_doubleBooked=false; for each thisRecord in...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 "tasklist_id": 78901234567890130, "person_responsible": "20211234567", "duration": "1", "duration_type": "hrs", "start_date": "11-12-2021", "end_date": "12-12-2021", "percent_complete": "0", "order_sequence": "4", "priority": "None", "custom_fields":...

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