Assuming code is required, the following 266 results were found.
-
as "-201". As I wanted a link so that the user can just click on this link and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
will display all the files to be renamed Return to the notepad (rename.bat) and take out the remark "REM" prefix so your code becomes: @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION FOR /f "tokens=*" %%a IN ('dir /b *" (Copy).jpg"') DO ( SET "oldName=%%a"...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
the folder to keep in Green and the one to delete in Red. - Lists failed deletions if there are any. - Changed browsing code to loop through folder of files to REMOVE. - Changed code to loop through an array of files rather than the directory. - Added...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to do this, click on the red "Verify Now" link. The sidebar for "Domain Verification" will poup on the right. Note the small code and prefix it to your parent domain (eg. abcd12.joellipman.com) and note the CNAME which will either be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
This is an article to demonstrate how to log a time event under a Zoho Projects Issue using code (Zoho Deluge) rather than the graphical user interface (GUI). Note this would probably be similar to when trying to enter a time against a project Task but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
The slightly longer answer to describe this might be better explained if you consider the following snippet of code: // sample data v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= v_Css; Yields All of me Now we have the tabs looking close to what we want, you will have noted that I have done this code in-line of the form. If you were to embed the form on to a page, you would be free to use some reserved CSS attributes on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
but local to the customer and we want to remind our customer that they have an appointment in 1 hour with us. How? The code is actually pretty straightforward but you will need to follow these steps to get the credentials: Login to your Twilio console...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
is primarily for myself as I need to do this for some other clients and I just want to continuously refine and improve my code below. How? I'm going to show you the code first of how to parse the eBay Transaction data and then the code to create a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
functional. First of all, make sure you set up a form with the fields I mentioned earlier in the Creator form. Here's the code which should happen when the form containing this radio field loads up: // // initial CSS (hide element while it is styled)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, you can parse the multi-line into a nice HTML table. But on a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging to the same school and updates some number fields on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
over a dataset of 20k+ contact records and that's only half of the production system's contacts. I needed a quick bit of code to find any duplicates, all within the Zoho Creator app using Zoho Deluge and avoiding the use of any third-party APIs. How? My...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
deleted from attachments based on its identifying number (allows other attachments to remain intact) Generate the file The code here is a cut down version just to demonstrate generating a text file and storing this into a variable: // // initialize...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
beautiful on ZohoCreator pages but then you hit the PDF button and it pretty much vomits your output back to the 90s. The code snippet below is just for a standard template with a modern design. How? Ok, admittedly, when first designing the template,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
rate post saving a record in Zoho Deluge would fail because it was making too many function statements. How? I have this code triggered in a workflow when the sales order is created to do some further calculations based on a surcharge rate held in a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
is misleading and cannot be used in the request for events. There are hardly any parameters you can send to. Here's some code to get the last 50 events: // // *********************************** // get Zoho Projects information v_BaseURL =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *