Assuming records is required, the following 63 results were found.
-
signs or a single tilda with the keys enclosed by double chevrons. Add the DataChange-out-tray Rule Element (DRE) records by clicking on the "Add" button Use brackets/parenthesis if you need to Enter the field to monitor under "Old field/Value" enclosed...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
CNAME as I find it easier and it is a step we need for Zoho on their side. Important: You should now have at least 2 CNAME records against this domain/subdomain. I usually have 3: .joellipman.com (used in verification), .joellipman.com and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
"pdf", r_ContactRecord.get("Email"), m_MergedData, "joels_connector"); if(!isNull(r_SendResponse.get("records"))) { v_Grammar = if(r_SendResponse.get("records").size()==1,"","s"); v_OutputMessage = v_OutputMessage + "Generated and sent " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
you use "equals" for multiple conditions, and if one of your conditions is (Company:equals:ABC), the response will contain records with ABC as well as ABC Inc in their Company fields. When you use "equals" with a single condition and search for a field...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
in the CLI, in particular the widget JS script that is referred to in widget.html and secondly, the way you retrieve records in the Zoho JavaScript. If you do not include Zoho queries, then I have found the app can be ported between either Creator or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
total number of employees in this department/team: To determine the total number of employees, we will use zoho.people.getRecords as a search: // get total "team members" in department l_SearchCriterias = List(); m_SearchCriteria = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes this functionality exists in reports but I want to do it in code so as to display it in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Why? My use case scenario is that I was trying to build a related list in Zoho CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being returned, all pretty much useless to me. Well the "for some reason"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
whoever manages the domain for the client. Who owns the domain (eg. mycompany.com) So this setup involves creating the TXT records on the DNS. Ideally, we would not want access to the DNS as Zoho Support as we could be blamed for any website / mail...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
events; status=closed are events in the past; status is a mandatory field // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index (not the ID of the record)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
iteration m_UpdateQuote.put("Subject",m_RecordData.get("Subject")); m_UpdateQuote.put("Quoted_Items",l_NewLineItems); l_RecordsToSend = List(); l_RecordsToSend.add(m_UpdateQuote); m_Data = Map(); m_Data.put("data",l_RecordsToSend); // // this is REST...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the header which was an expression detailing what the report was displaying, so for example: -- If setting the limit to 100 records =IIf( Sum(Fields!myCount.Value, "DataSet2")>100, "» Displaying the first " & CountRows("DataSet1") & " of " &...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
= CONVERT(VARCHAR(2),DATEADD(MONTH, 1,GETDATE()),101) + '/01/2009 01:30:00 PM', Note = 'Event 6' ) SELECT -- Number the records based on the date, if multiple records have -- the same date then they will be numbered the same. Used in -- calculation to...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
sequence -- number (padded with zeros) How? So how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query: SELECT RIGHT('000' + CAST(e.ID AS VARCHAR), 3) AS EmployeeNo, RIGHT('000' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
FROM [dbo].[XML_EVENTS] -- Returns attribute "financialyear" of CURRENT_EMPLOYEE (eg. "2014") In a WHERE clause To select records matching a value for the XML field: SELECT * FROM [dbo].[XML_EVENTS] WHERE CAST(Event_XML AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
"error"}: I have had this error with API v2 when I'm using PHP/cURL and not deluge to get a list of contact records. As I'm listing errors encountered, I'm adding it to this list. If submitting the headers as an array, note that it must NOT be an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)];... Lastly, there is a function I find myself...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *