DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 ''; -- 1900-01-01 SET @TimeVal = ''; -- 00:00:00.000 SET @DateMatch = 0; SET @TimeMatch = 0; SET @ColumnTypeIsDate = 0; -- Determine if Given Value is date IF @OrigVal IS NULL RETURN NULL; -- Determine if Given Value is date IF ISDATE(@OrigVal)=1 SET...

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

DataScramble - Randomizing data rowshttps://joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 ''; -- 1900-01-01 SET @TimeVal = ''; -- 00:00:00.000 SET @DateMatch = 0; SET @TimeMatch = 0; SET @ColumnTypeIsDate = 0; -- Determine if Given Value is date IF @OrigVal IS NULL RETURN NULL; -- Determine if Given Value is date IF ISDATE(@OrigVal)=1 SET...

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

Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://joellipman.com/articles/crm/zoho/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

21 September 2021 = v_NextTime.toTime().toLong(); // // calculate seconds in between v_UnixSeconds = v_NextEpoch - v_NowEpoch; // // determine days v_Days = floor(v_UnixSeconds / 1000 / 60 / 60 / 24); info v_Days; v_UnixSeconds = v_UnixSeconds - (v_Days * 1000 * 60 * 60...

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

Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

31 January 2020 This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month. Why? Fine if you are determining the quarter by the month and your Fiscal year starts from January, simply divide by 3... How? I'm showing...

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

Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine the cost of each item purchased; including shipping and tax. The second is to associate these to the invoiced items and...

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

Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works....

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

Zoho Deluge: Determine your Statement Execution Limithttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 What? A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was hitting statement execution limits and rather than...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 £499.95 is correctly £416.62) Date Modified: 2023-02-23 (Joel Lipman) - Check if ebay Order ID already exists on system to determine whether to update or create. - Check if SalesOrder already exists on system to determine whether to update or create. -...

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

Calculating Percentagehttps://joellipman.com/articles/ecommerce/calculating-percentage.html

20 May 2010 be reminded of how to calculate a percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress So Far / Total Progress Units) * 100 = % or (Net Amount / Gross...

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

Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018". Why? Well there's a long a way to do it (but...

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

Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 environment variable: This allows you to use keytool from any folder: Open a command prompt Type CD C:\Program Files\Java Determine your JDK folder dir jdk* and append the \bin. Note this for later. Right-click on the "Computer" icon/label (desktop /...

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

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

10 December 2020 add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to determine total number of employees in this department/team: To determine the total number of employees, we will use...

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

Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 This means that if I click on Tuesday10March, this code will match "10" to the map and determine what index or offset this is from the starting date, which is "2". It can then determine which CSS element to highlight in a different CSS color, and which...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 per section. -- NOTE: Because Joomla randomly selects an ID for the installing admin, I -- have changed the script to determine what this ID is by finding out what -- user_id is the first user created in the upgrade site. This is the ID -- used when...

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

Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why?...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 := v_Monitor%A_Index%Left v_y1 := v_Monitor%A_Index%Top v_x2 := v_Monitor%A_Index%Right v_y2 := v_Monitor%A_Index%Bottom ; determine if leftest if(v_x1...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 ]; How? So in the following example, we are going to setup a connection in Zoho Books on an EU datacenter: First determine what datacenter your client is using Register the App Setup the Connector How do I determine what datacenter to use? To find out...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 can be searched for with the "State" field on the Lead record. // // ************************************************ // determine customer timezone: BEGIN // v_CustomerTimeZone = ""; // // build up address from Lead to geocode l_LeadAddress = List();...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 { // // specify your own Inventory/Books organization ID v_BooksOrgID = 20221234567; // // determine URL of file to download (note the DC here is EU but yours might be COM) v_Url = "https://inventory.zoho.eu/api/v1/items/" + input.Zoho_Inventory_ID +...

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

Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 } // add currency code into column "Agreed Currency" json_Arg.Agreed_Currency = v_CurrencyCode; // the rate values we determine earlier json_Arg.Rate_Year_1_0 = v_DealRate0; json_Arg.Rate_Year_1_5 = v_DealRate1; json_Arg.Rate_Year_2_0 = v_DealRate2;...

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