Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 = zoho.currenttime.toLong() / 1000; // // by default gets last 100 messages (doesn't return anything if no parameters specified) v_Endpoint = "https://cliq.zoho.eu/api/v2/chats/"+v_ChatID + "/messages?fromtime=" + v_FromTime + "&limit=50"; r_ChatDetails...

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

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

01 April 2025 the type of invoice selected var v_InvoiceType = ZDK.Page.getField('Invoice_Type').getValue(); // check source quote is specified var v_QuoteID = ZDK.Page.getField('Converted_From_ID').getValue(); // only make changes to the invoice if 1 of the 2...

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

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 read-only privileges. The report has 4 parameters, two of them use the default values (from and to date range) and two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 = {1}; v_PerPage = 1; // // map to retrieve all records (to include approved and converted records, this needs to be specified as the query value) m_IgnoreRestrictions = Map(); m_IgnoreRestrictions.put("approved","both");...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the record, they will get a validation error on the...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 So the file shouldn't exist if you check after the script has completed. Do the following step to keep the file in a specified folder. 5. Form processing works so now test the actual file upload Add the following code after the above code sample in step...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Press Esc while dragging a tab. Returns the tab to its orginal position. Ctrl+1 through Ctrl+8 Switches to the tab at the specified position number on the tab strip. Ctrl+9 Switches to the last tab. Ctrl+Tab or Ctrl+PgDown Switches to the next tab....

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 and I myself don't put any copyright information on the end product. I needed a program to: + Group all the data by a specified column + Generate interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 GROUP BY t1.IP ORDER BY b.user_name ) t2 GROUP BY MONTH(t2.Date); Notes: I use this in a PHP script so where year is specified (2010), I have a variable posted from a HTML form in my PHP. Also note: The association to a user can change because anonymous...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 if you're working on a local report within BIDS connecting to remote servers. If you want the report to be viewable on a specified Reporting Server than you'll need to deploy the report. If you get the following error (like I did) when you view the...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 I only know how to do this with a UNION ALL clause. Scenario: I have a Joomla module which should take the keywords from a specified number of different but similar tables. I'm looking to query the Title and the Introductions of any valid articles from...

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

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 though, I wanted the "left" div to take over the whole page if there were no modules positioned in the "right" div. I specified width of left using PHP. This is the CSS though: #container { position: relative; } #content { position: relative; top: 0;...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 SHGFI_SYSICONINDEX = $000004000 Const SHGFI_LINKOVERLAY = $000008000 Const SHGFI_SELECTED = $000010000 Const SHGFI_ATTR_SPECIFIED = $000020000 Const SHGFI_LARGEICON = $000000000 Const SHGFI_SMALLICON = $000000001 Const SHGFI_OPENICON = $000000002 Const...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 param3=@param3): Local Variables Note that we were trying to execute our stored procedure with the parameters specified just after the name of the procedure. The trick is not to use any of these and to use the GUI dialog of the "Dataset Properties" for...

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

Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 them all: This is a function I pulled from the Autohotkey forums submitted by SKAN which lists all the functions for a specified Dynamic Link Library (DLL) along with an inputbox for convenience: InputBox, FunctionToDo, DLL File, Enter the name of the...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources and folders will also show. The Side-by-Side Table As you know, most datasets will return the...

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

How to change local folder for TFShttps://www.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 Source Control Explorer and check what it says next to "Local Path" (for me this said the name of the local folder that I specified just before)

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 the column name which will contain this value. ** ** ** ** Return Values : Table of three columns: ** ** - myValue: value specified in parameter 1 (matched in database to search) ** ** - myTable: table in which the column occurs ** ** (returned as...

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

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 to spread gradient backgrounds across a long page. It would appear to be fool proof because of the "background:#f7f7f7" specified at the beginning of the code but it is not. My only solution was to propose to set the background as white (#f7f7f7 - white...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 the Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the datasource (eg. "Sheet1$"). Using the example above: Sheet1$A11:AL12 Selects all data from column A, row 11 up to...

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