Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 { m_ThisRecord = m_UnsortedRecords.get(v_SortKey); info m_ThisRecord; } Recap The original sample data l_MyListUnsorted looks something like this in a JSON parser: [ { "name": "Joel", "id": 46498, "date": "1977-11-14T12:30:00+00:00" }, { "name":...

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

Setting up your store to use SSLhttps://www.joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 Master Domain: http://www.example.com Secure Domain: https://www.example.com Most people prefer to use dedicated SSL as it looks more professional and can improve customer confidence. How do I test SSL is working? Before we do anything we need to test...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 week numbers is because these are academic week numbers. So I can't use the built-in functions. The current structure looks similar to this: ID SetID WeekNumber StartDate --------- ---------------- ---------------------- ---------------------------- 1...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ReportID uniqueidentifier NULL The ID of the report (looks like a hexadecimal SSID). It's the unique ID of the report but not unique in the table (can be referenced many times)....

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 program I've been wanting for ages. Only way to be sure it doesn't have any malicious code and that it does what I want and looks like I want it to look, was to make my own. What does it do? Amazing. It detects transmissions over a network. Basically on...

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

DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 DateOfBirth --------- ------------ ----------- 1 Fred Bloggs 1964-02-18 2 Another User 1988-06-24 3 John Smith 1972-11-17 Looks pretty good, doesn't it? The advantages of this is that you can send this data to your developers and the data types will be...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID Name EmpType CodeType 1...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 sell." Joke10:="Not so much of a has-been, more of a definite won't be." Joke11:="If you see two people talking and one looks bored, he's the other one." ; make program select one joke in this instance Random, JokeIndex, 1, 11 ThisJoke:=Joke%JokeIndex%...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 view top configurations for best distance/duration - Pilot: view top rated equipment - Pilot: rate other configurations (looks and performance) - Pilot: report a location as restricted or recommended for flying - Pilot: know a flight club? send us the...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• 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 Right-click on one of the file upload/attachments and copy the link Return to your code and customize the permalink so it looks the same but appends the file name See the following as an example of what you should end up with: // // attach to ZohoBooks...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 & jQuery) which I’m referring to over the web (Content Delivery Network – CDN) Recap So as a recap, this is how it looks so far: The HTML: The CSS: The JavaScript: The Preview in Browser: Adding some Zoho SDK functionality: First I’m going to add the...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 Additional: We asked Zoho for a solution that might work and were given the following snippet of code (not tested yet!). It looks like we have to fill in the blanks and it's on the same path as we were. The main revelation was the function...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 more fun to write another function that will generate the Auth'n'auth token. Here is a reminder on what my Zoho Creator form looks like for API Integrations and the fields I refer to: Note the Dev ID field and the Session ID fields that we didn't use in...

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

Zoho Creator: Copy Subform to other Subformshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

17 November 2021 days. How? So I have a form with 6 subforms which list staff/employee shifts from Monday to Saturday. The form I have looks something like the following: and displays as something like this: The code I create a workflow that when the decision box "Copy...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 Elements, make the changes to your box using your HTML knowledge (in my example, clearing the hard-coded address) Once it looks like you want, click on the "Save" then "Save Now" button in the top right of your CRM. Done... get everyone involved to...

• 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 "); row.Document_Name=v_FilenameFormatted; } } And finally, with a bit of CSS, this is what the end product looks like:

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 case, if they were tightened too much, they would go right through the gaps resulting in the fans falling... But the crystal looks nice. Link(s) / Source(s): Microsoft Store: Intel® Graphics Command Center YouTube - JayzTwoCents - This might be the best...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 cells). But here we're simply going to use ZohoCreator and its PDF rendering options. What's wrong with just using CSS? It looks beautiful on ZohoCreator pages but then you hit the PDF button and it pretty much vomits your output back to the 90s. The...

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

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits :c) This is "a day in the life of New York City". {module title="Youtube Embedded Video...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

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

14 December 2016 'user' = 'Fred'"); $a2=$mysqli->affected_rows(); //Check 1 row affected by each query if ($a1==1 && $a2==1) { //Everything looks OK, commit changes $mysqli->commit(); } else //Something went wrong. Roll back to before begin_transaction()...

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