Assuming 1 is required, the following 337 results were found.
-
numbers at the end still need to match what's in CRM and with ZohoBooks rounding differently can make cent/penny errors into 100s of dollar/pound errors. Zoho CRM has a fun way of rounding which differs to Zoho Books so when pushing an invoice, there's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
search for Xero. fn_Xero_MapTaxRates This function used to take a Xero TaxType name and return a Zoho Tax ID (64-bit unsigned 19 digit integer) but that's more use when writing to Zoho Books. Within ZohoCRM, we only need the name and in this case the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) + ' WHERE SOUNDEX(' + COLUMN_NAME + ')=SOUNDEX('''+...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
which employee, on what date, and for how many days they were off sick. When migrating to a new system, the destination wanted 1 row per day. This meant that if in the old system, there was 1 row with an employee who took 2 days off, we would want 2...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
(note you will need to change the keys and relevant IDs to match your own solution): // specify provider ID $my_provider_id = 1234; $my_timestamp = time(); // specify company ID $company_id_1 = 1234; $company_id_2 = 4321; // specify agency ID...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
&& !isNull(r_AvailableSlot)) { v_HourCheck = r_AvailableSlot.getPrefix(":").toLong(); if(v_HourCheck < 12) { input.Morning:ui.add(r_AvailableSlot); v_CountMorning = v_CountMorning + 1; v_CountTotal = v_CountTotal + 1; } else if(v_HourCheck >= 12 &&...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
list but I felt this deserved its own article. Why? A client wanted the discount displayed on a template and if they gave 10% discount, it would display as 10.00%. And they need the decimal because sometimes they might offer 12.5%. But when it displays...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Function: void fn_AB_AssociateVacancy2Candidate(int p_CandidateID) Workflow: AB001: Associate Job Openings with Candidate Trigger: Workflow run whenever a candidate record is modified Purpose: Associates Job Openings with a Candidate when their record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User 1964-02-18 After: ID Name DateOfBirth --------- ------------...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
CREATE OR REPLACE FUNCTION UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2 DEFAULT NULL, -- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings )...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
called "wallpaper": /imagine a flower // returns 4 square pictures of a flower /imagine a flower --wallpaper // appends "--w 1920 --h 1024 --hd" // returns 4 pictures of a flower in a landscape orientation with an aspect ratio of 16:9 (a bit like an A4...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
Recipe Ingredients 1 milk 1 tbsp creamy peanut butter 1 tsp vanilla 1 vanilla ice cream Recipe Preparation Fill a tall glass or mug with as much milk as you wish (I use 1 cup); pour into blender, and add the vanilla and peanut butter. Whirl for 1...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ---------- ---------- ----------- Task 1 0.14 1:00:00 Task 2 0.07 0:30:00 Task 3 4.80 34:15:00 Excel needs the decimal number to be representative of a 24 hour slot. In...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
they can use the interface again only to find it may crash again. In the background and from a developers understanding: field1 is told to update field2 when field1 is changed. When field2 is changed, it is told to update field1. This causes a recursive...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
match in which case it should re-add the row with an "End Date" specified (blank or not). console.log("Joel Lipman - 20221018 -------------------------"); // get some values from the current record var v_CurrencyCode =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
on a Sunday (ie. myDate.toStartOfWeek("EEEE") returns Sunday). In other words, the day counting starts at 7, followed by 1 for Monday, 2 for Tuesday, and so on... How? The logic behind this would be to take the date of the order, check if the order date...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples assume today's date is Wednesday 03 August 2011 @ 11:46: This Week: -- Start Date (US...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value '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...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB