Assuming 1 is required, the following 337 results were found.
-
Portal_Listing_Report and I have a publish key held in v_ListingPublishKey and lastly, my datacenter is .COM: URL Syntax #1 // works in eBay v_ImageSrc = "https://creator.zoho.com/file" + zoho.appuri + "Portal_Listing_Report/" + input.ID +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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 Deluge
- Language: *
-
Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below: l_Months = {1,2,3,4,5,6,7,8,9,10,11,12}; l_MonthNames =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
for applying for leave if over 80% of the department have already booked the requested dates off. In other words, if there are 10 people in a department/team, and 8 people have booked tomorrow off, prevent a 9th team member booking tomorrow off. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
commas between two quotes with a custom string, to be exact: v_FormattedData = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); The slightly longer answer to describe this might be better explained if you consider the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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 Amount) * 100 = % eg. (12 steps / 30 steps) * 100 = 40% ie. 12 steps of 30 is 40% progress eg....
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
great idea, I'm just trying something out. The brief was pretty much just "...fast and works with cms articles...". If we have 100 slides then 100 slides of data will need to load at the same time per page. Terrible. Using AJAX (which will have to be...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
is to run the below example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE PROCEDURE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
to: Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
a purchase order. Let us assume we have the following in a form/report called "Stock_Upload": RowID Name SKU Account Email 0001 Test Product 1 TEST001 test1@joellipman.com 0002 Test Product 1 TEST001 test1@joellipman.com 0003 Test Product 1 TEST001...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
"-03-08 02:00:00"); // // Ends First Sunday in November at 2:00 v_LastMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-11-01 02:00:00"); // // loop through each day in a week to get the start and end dates for each v_DayIndex in {0,1,2,3,4,5,6}...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to get the first page of most recent invoices from Xero and pull them into ZohoCRM Inputs: - Outputs: - Date Created: 2025-10-08 (Joel Lipman) - Initial release Date Modified: 2025-10-13 ( Joel Lipman) - Parsing Xero Dates and Times to include timezone...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
in an SSIS Script Task but this article includes the full process of packaging the script into a reusable component. Example #1: As an SSIS Script Task My solution so far: The following script will convert to lowercase and then capitalize the first...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
TotalTimeToday TotalTimeWeek ----------- ----------- ---------- -------- ------- -------- -------------- ------------- 2013-12-02 Monday 09:00 12:00 13:00 17:00 7:00 7:00 2013-12-03 Tuesday 08:45 12:00 13:30 17:45 7:30 14:30 2013-12-04 Wednesday 09:00...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
border, text alignment and background v_Css = v_Css + ".zc-Tabs-group label.choice-label-text{display:block !important;width:125px;padding:5px;border:1px solid #eee;text-align:center;}"; v_Css = v_Css + ".zc-Tabs-group...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
which one here, as long as I can get to the 3rd tab of the widget (it becomes enabled once you've completed enough on the 1st tab): I'll click on the 3rd tab called "Settings" then on the sub-tab "Image", and click on the button labeled "Choose Image":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
Standalone Purpose: For any deal which is cancelled, cancel its related sales orders. Inputs: - Outputs: - Date Created: 2025-01-30 (Joel Lipman) - Initial release Date Modified: ??? ??? More Information: Custom View ID: 123456000012345678...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *