Assuming name is required, the following 277 results were found.
-
BOTH tables and return one table with everything I want. Consider the following two tables exist: Joomla Articles (table name: jos_content): id title introtext -------------------------------------------------------------------------- 1 Welcome This is...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to take over, you can at any point control which server your website visitors will go to when they type your domain name. Important: You only need the domain name and no additional packages (not even email as our servers handle that). UK Domain...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
m_CreateContactPerson.put("contact_id", "1234567890123456"); // the account ID in books m_CreateContactPerson.put("first_name", "Joel"); m_CreateContactPerson.put("last_name", "Lipman"); m_CreateContactPerson.put("email", "somewhere@beyondthesea.com");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
{ l_Users = r_Response.get("response").get("users"); for each v_User in l_Users { info v_User.get("full_name") + " :: " + v_User.get("id"); } } } Update 2020: Note this can also be achieved with the following shortcode: l_Users =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Method #2: Using Deluge Assuming that I have a form called "MyImages" and an image upload field that has the field link name "MyImage". There is an additional single-line text field called "Name". I have added an entry with name "Logo" and I have...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
"message": "Error occurred", "uri": "/api/forms/json/P_ApplyLeave/updateRecord", "errors": { "code": 7013, "message": "Field name 'ApprovalStatus' is invalid " }, "status": 1 } } [Warning: Another red herring ahead] We tried various other options such...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
owner of a record. Why? A client had added a custom lookup field to the users settings called "Division" (similar to team name) and wanted any Opportunity record to have a field showing the user's Division. This would help in reporting later down the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
add a Notes field to the Creator form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you rename it from "Tabs" to something else, all CSS references need to be changed as well to the new name and follow the syntax...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
but then they changed address and couldn't change the template. So they had something like: ${Organization.Organization Name} ${Organization.Street} ${Organization.City} ${Organization.Country} ${Organization.Postal Code} 11 My Street, My City, My...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
then separate each with parenthesis joined by "and" or "or". Nulls are not returned. Set the "ModuleToSearch" to the API Name of the module you want to search. Method #1: zoho.crm.searchRecords() Contrary to the documentation saying there are only the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= {"cf_payment_method","cf_payment_date","cf_last_4_digits"}; if(!l_DontCopyFields.contains(m_CustomField.get("api_name"))) { l_NewCustomFields.add(m_CustomField); } } // add custom field payment mode m_MiniCustomField = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
// get opportunity lookup (related deal) of this record let r_DealLookup = ZDK.Page.getField('Opportunity_Name').getValue(); let v_DealID = r_DealLookup.id; let r_DealDetails = ZDK.Apps.CRM.Deals.fetchById(v_DealID); // get Deal/Opportunity fields we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
third-party CDN / API gets upgraded. Add these to the widget as you see fit but I'm including jQuery and Bootstrap: Company Name - Quote Builder Hi You have 0 Pending Quotes You have 0 Previous Quotes Get a New Quote! © 1999 Joel Lipman Ltd. All Rights...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Update"); m_CreateRecord.put("JSON_Payload",m_Payload.toString()); r_CreateRecord = zoho.creator.createRecord("myOwnerName","myAppName","myFormName",m_CreateRecord,m_Blank,"myCreatorConnection"); // // build the hash based on the payload body v_Data =...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
m_NewLineItem.put("CUSTOM_FIELD_2",m_LineItem.get("CUSTOM_FIELD_2")); m_NewLineItem.put("Product_Name",m_LineItem.get("Product_Name")); m_NewLineItem.put("Quantity",m_LineItem.get("Quantity"));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, database, etc.). For obvious reasons, these cannot be hardcoded. What? Any developer installing my component will do...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
I'm making has to ensure user's can only see their own projects and not everyone's: SELECT * FROM #__projects ORDER BY name -- yields all projects irrespective of which user is logged in What I want: SELECT * FROM #__projects WHERE user_id= ORDER BY...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
deal with the passwords can then be up to you. To use the following script, you need to change the my_wordpress_db to the name of your wordpress database and change my_joomla_db to the name of your joomla database. Note that your database user should...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW: Dataset to populate the dropdown SELECT d1.Name, d1.ItemID FROM (...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB