Assuming 1 is required, the following 341 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: *
-
the Zoho People Salary table within the built-in integration / synchronization. Why? My use-case is for a client who has over 1200 employees but similar to performance goals, we need to write code to push the salary data out to a Zoho Analytics table....
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- 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