Assuming primary is required, the following 21 results were found.
-
> Contacts > Layout Rules > New Layout Rule Call it "If Email Blank then Mobile Required" Select the Email field as the primary field to control this rule Set the condition that the email "is empty" > click on the "Next" button Set Mandatory FIelds >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
modify a record in a table in Joomla: // Create and populate an object. $user_record = new stdClass(); // Must be a valid primary key value. $user_record->id = 42; $user_record->name = 'Joel'; $user_record->username = 'jlipman'; // Update their details...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
exceptionArray_that; // get the value we want to transform string ValueToConvert = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation symbols)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
int(11) NOT NULL AUTO_INCREMENT, `Column3` int(11) NOT NULL, `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...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Frontpage Item Orderinghttps://joellipman.com/articles/cms/joomla/frontpage-item-ordering.html
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. Set the Primary Order to Default. Click on the Save button at the upper right.
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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 Windows You should see all 5 screens flicker to life.... Finally! I say...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
the scripting language of the web, and is supported by most web browsers. Controlling webpages using JavaScript is not the primary aim of this tutorial, but it will prove valuable because you should be able to find plenty of useful JavaScript examples...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
But the packing slip would display the Ship to address as the 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
[ 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 was to recover the relevant product based on any given Product SKU. Making the above into a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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 display above the sales person (eg. "Sales Person") Alongside the Value...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
is that I am using the send invoice API and I kept getting this error despite including the customer_id and there was a primary contact on the customer record. This is from within ZohoCreator, requesting for an invoice in ZohoBooks to be sent. How? So...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
fields) var config = { appName : "joes_quote_builder", reportName : "Contacts_Report_SearchableByWidget", criteria : "(Primary_Email == \"" + v_ShopifyEmail + "\" && Shopify_ID == \"" + v_ShopifyID + "\")", page : 1, pageSize : 10 } // find the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
m_OutputRecord.put("DueDate",m_GoalRecord.get("DueDate")); // // primary key m_OutputRecord.put("ObjectiveRecordID",p_RecordID); // // Add this row to Analytics m_Header = Map(); m_Header.put("ZANALYTICS-ORGID",v_AnalyticsOrgID); m_Columns = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
!= "-Unknown-") { r_CreateContact = zoho.crm.createRecord("Contacts",m_CrmContact); if(b_Debug) { info "Creating Primary Contact: " + r_CreateContact; } if(!isNull(r_CreateContact.get("id"))) { v_CrmContactID = r_CreateContact.get("id"); } // // create...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
!= "-Unknown-") { r_CreateContact = zoho.crm.createRecord("Contacts",m_CrmContact); if(b_Debug) { info "Creating Primary Contact: " + r_CreateContact; } if(!isNull(r_CreateContact.get("id"))) { v_CrmContactID = r_CreateContact.get("id"); } // // create...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
-- USERGROUPS: -- ********************************************************************** -- Ensure ID (primary key) match up on both systems unless you have -- custom usergroups. -- I did not have to do it this time but shout if you need help --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Drop If Object Existshttps://joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html
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 = Replication-filter-procedure S = System base table SN = Synonym SQ = Service...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
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 / Associate Websites? Any relevant market research notes. eg. a website is not just a...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
data types specifically, test by running each function separately) Examine databases (data types, constraints, primary/foreign keys, autoincrements, schema diagram, scheduled jobs) Examine content integrity (what is available front-end and back-end? can...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
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 signs or a single tilda with the keys enclosed by...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *