Search - Joel Lipman .Com

1. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... reportName : "Contacts_Report_SearchableByWidget", criteria : "(Primary_Email == \"" + v_ShopifyEmail + "\" && Shopify_ID == \"" + v_ShopifyID + "\")", ...; Created on 14 March 2024
2. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... was a primary contact on the customer record. This is from within ZohoCreator, requesting for an invoice in ZohoBooks to be sent. How? So the key here is that there were no contact persons on ...; Created on 07 March 2024
3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
4. ZohoCRM: Import Attachments: / Zoho /; ... r1 vMyExternalFile w300 x10 y55, Gui, Add, Edit, r1 vMyExternalFileColKey w30 x310 y80, Gui, Add, Edit, r1 vMyExternalFileColFile w30 x310 y105, Gui, Add, Edit, r1 vMyExternalFileColPrimaryID ...; Created on 16 January 2023
5. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... that has the value you want to display. Under "Show Value As", select Max Then click on the "Settings" tab and do the following: Under Primary Value - Label, enter the static text you want to ...; Created on 24 October 2022
6. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... but my windows login screen will appear on my central monitor (after further reboots my daisy chained 2 monitors now load the bios logo with the primary monitor displaying the windows login) > Login to ...; Created on 12 March 2022
7. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... = invokeurl [ url :v_Endpoint type :POST parameters: m_GraphQl.toString() headers:m_Header ]; info r_GetProduct; Awesome! Now for the primary objective of this task, which ...; Created on 14 February 2022
8. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
9. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... same as the billing address... Or more specifically, the primary contact, company, address and phone from the customer record and not from the sales order change. How? The key is a setting you need ...; Created on 07 October 2021
10. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... ********************************************************************** -- USERGROUPS: -- ********************************************************************** -- Ensure ID (primary key) match up on ...; Created on 12 September 2015
11. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; ... as the the XET and EOR codes) Specify the Message Group that the monitors will run. In our demo, the link value uses all three primary keys of the CAP entity. They can be separated by double hashes/pound ...; Created on 21 August 2014
12. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation ...; Created on 04 October 2013
13. Reorder Columns in a Table: / Databases /; ... `Column2` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- To CREATE TABLE IF NOT EXISTS ...; Created on 22 July 2013
14. JDatabase: using the Joomla database with examples: / Joomla /; ... be a valid primary key value. $user_record->id = 42; $user_record->name = 'Joel'; $user_record->username = 'jlipman'; // Update their details in the users table using id as the primary key. $result ...; Created on 27 January 2013
15. Drop If Object Exists: / Transact-SQL /; ... SQL inline table-valued function IT = Internal table P = SQL Stored Procedure PC = Assembly (CLR) stored-procedure PG = Plan guide PK = PRIMARY KEY constraint R = Rule (old-style, stand-alone) RF = ...; Created on 03 August 2012
16. First and Last Entry on a Page using Modulus Remainder: / Personal Home Page /; ... I'm looking for... always difficult. After a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This article ...; Created on 26 September 2011
17. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; ... not the primary aim of this tutorial, but it will prove valuable because you should be able to find plenty of useful JavaScript examples online. This will be helpful because in my opinion, the simplest ...; Created on 05 July 2011
18. Developer's Checklist: Taking over a projec: / Web-Development /; ... goes in, what comes out? (accepts/returns, data types specifically, test by running each function separately) Examine databases (data types, constraints, primary/foreign keys, autoincrements, schema ...; Created on 01 March 2011
19. Frontpage Item Ordering: / Joomla /; ... name (or whatever item happens to be your default frontpage item, can't be an article). Click on the menu Parameters - Advanced on the right. Set the Category Order to No. Order by Primary Order Only ...; Created on 16 September 2010
20. Project Plan for Freelance Website: / Web-Development /; ... within Client company? Budget (see Rates for Joellipman.com below) Similar looking websites and colour schemes Will the website be the primary medium for the Client? Affiliates ...; Created on 25 February 2010