Assuming name is required, the following 277 results were found.
-
a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the headers and data but without using a for loop. What I have:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
action called "Add_Tags". I'm going to get the tags of the contact record using an invokeurl because shortcode only gives me name and ID; but I want the color code field as well which I only seem to get with an InvokeURL. I'm then going to create a list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the “master” workspace Log in to Zoho Analytics as an Account Admin Confirm you are on the Home page, with the company name visible in the top-left Confirm the Workspaces tab is selected Click Import Your Data Search for Zoho People Select the Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Script Login to ZohoCRM > Setup (cog icon next to profile photo) > Developer Hub > Client Script > New Script Give it a name, I'm calling mine Invoice TBC Give it a description. I said "Sets the subject/name of the invoice to TBC when first created....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
website (at time of print: Jcomments v2.3.0 on Joomla v2.5.4) Copy the below script to a text file Change the database names to match your setup Change the table name prefixes to match your setup Run the modified SQL script against your database. Note:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
without needing to redistribute or update this app. {youtube}fQD0xVEYDks{/youtube} Location: For location, type a city name, post code, zip code or any value that is understood by the api.openweathermap.org website. There are plans to shift this to...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have: id name date --------------------------------------------- 46498 Joel 1977-11-14T12:30:00+00:00 8949 Anonymouse...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" which is the file name as it is to be displayed in ZohoCRM). For example...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
} // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID = r_QuoteDetails.get("Account_Name").get("id"); r_SearchResults =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I'm sending to the function. So in "Edit this application" > go to Workflow > Functions > New Function: give the function a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
** Return Values : Table of two columns: ** ** - Value: Your search term and matching variations ** ** - Source: The table_name.column_name it found this value (Maximum) ** ** ** ** Additional: ** ** - For performance, restrict this by schema otherwise...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
-- value() returns single value, specify data type as second parameter SELECT Event_XML.value('(/STAFF/EMPLOYEE_NUMBER/@name)[1]','varchar(20)') FROM [dbo].[XML_EVENTS] Issues: XQuery [value()]: 'value()' requires a singleton (or empty sequence), found...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02 myproduct3 TEST03 I'm trying to insert a record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
{ b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name == "eBay API (Sandbox)"]; //info "Sandbox Mode"; } else { r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; //info "Production Mode";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
use "equals" with a single condition and search for a field (mentioned in point #3 of the Note on this page), like Campaign_Name:equals:CRM, the response will contain only those records whose Campaign_Name is "CRM" and not records with "Best CRM" or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the student ID number Agenda Outline Note: As simple as this sounds, this...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB