Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 text to Joomla language file (translatable) - Date Uploaded: Sun, 10th Mar 2013 2.1.1- Corrected alias reference to all columns irrespective of order settings. - Link for text only links title and not description. - Restored module parameter: Display...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 on the attachment to see what the link should be: Ensure a report exists with your form and that one of the fields/columns viewable is the file upload or attachment field In Zoho Creator, in the "Edit" mode, go to "Settings" Under "Users and Control"...

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

Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

11 January 2021 I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the headers and data but without using a for loop. What...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 addresses which in turn contained commas. Saving this as a CSV and asking Deluge to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 + " "; input.Note_Attachments = v_NoteAttachments; Here's the code at the end of the parent form to hide the columns I don't need the user to see (I'll populate these by code): hide Attachments.Parent_Record; hide Attachments.Document_Name; hide...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 every employee's record. My employee record form is called "Staff" and the subform is called "Usual Shift" containing the columns "Day", "Start Time", and "End Time": // // select applicable staff l_ApplicableStaff = Staff[ID != 0]; for each c_Employee...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 text, textarea, integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted fields is equals. When you use...

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

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

25 September 2025 me synchronize every hour. Then I'll write the SQL queries to get the individual responses into a table with labels and columns that can help me group them (and identify which responses belong to which survey attempts). Then I'll write the SQL to sum up...

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

SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 include the tablix header... obviously). I right-clicked on the header row of the tablix and checked the box "Repeat header columns on each page. Situation I have a report which has been set to landscape with zero margins specified. Although BIDS...

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

Trim values along with the tabhttps://www.joellipman.com/articles/database/mysql/trim-values-along-with-the-tab.html

13 June 2016 data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to Remove Tabs

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

MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 to do with each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers)

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