Assuming name is required, the following 277 results were found.
-
the link "Zia Developer Console" (yours will have the specific OrgID in the URL). Click on "Add Action" Give it the Action Name "Ask ChatGPT" This action should "Answer a Question" It should be answered by "Construct Answer by Fetching Data" The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3 ---------------- --------------- -------------- -------------- -------------- Joel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
v_ImageToDownload = ifnull(p_DownloadImageUrl,"https://joellipman.com/tmp/icon_linkedin.jpg"); v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url :v_ImageToDownload type :GET...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
of a Report in ZohoCreator l_CsvLines = List(); l_ApplicableProducts = Products[Display_in_Widget=="Yes"] sort by Product_Name; for each c_Product in l_ApplicableProducts { l_CsvRow = List(); l_CsvRow.add(c_Product.Photo);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
.NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User 1964-02-18...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Administrator) MS Business Intelligence Development Studio 2008 Test/Sample MySQL Database to connect to (server and username + password). Admin Access to the reporting server if you plan on deploying the report to it. Scenario: We want to report on a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
How? I'm breaking this down into 3 stages: Zoho Creator: Specify Custom Domain Domain Registrar: Setup subdomain and add CNAME Zoho Support: Get Zoho to setup SSL 1. Setup Custom Domain So go into your Zoho Creator app and go to the "Settings" tab, then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
form without a redirect. Drag a decision box field on to the form; we are calling ours "Save & Close" with the field link name as "Save_and_Close" (the field link name is important for the next step: CSS styling): Apply the following styling (this will...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
"info": { "count": 3, "more_records": false } } Amazing! Let's go one further for a lookup field, in this case the account name field on the quotes record: // // build up COQL query v_CoqlQuery = "select Account_Name.Account_Name from Quotes where...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// // get customer's requested time v_CustomersRequestedTime = input.Customers_Requested_Time.toTime(); v_CustomerTimeZoneName = "(+01:00) Europe/Luxembourg"; v_CustomerOffset = "+01:00"; // // calculate GMT v_CustomerPlusMinus =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
+ p_QuoteID + "&print_type=pdf"; f_FileRequest = invokeurl [ url :v_Url type :GET connection:"zcrm" ]; f_FileRequest.setParamName("file"); f_FileRequest.setFileName(r_QuoteDetails.get("Subject") + ".pdf"); // // get a greeting name v_EmailTo =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
install -g zoho-extension-toolkit (this also updates existing install) sudo zet init select Zoho CRM enter a unique Project Name cd to the new project name To give permissions to write sudo chmod -R 777 . open the newly created widget.html file in your...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
staff have been entering employees goals, then we're going to query it and push it to Zoho Analytics. Find the form link name: Putting this here as it should be what we first did! This is with reference to the Zoho People version 5: Login to Zoho People...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
the input in a TextView (invisible or visible) held in the calling XML /* 201411041253 */ private String hangar_aircraft_name; public void editHangarAircraftName(View view) { // get current value for hint TextView currentName = (TextView)...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
(parser.next() != XmlPullParser.END_DOCUMENT) { if (parser.getEventType() != XmlPullParser.START_TAG) { continue; } String name = parser.getName(); if (name.equals("title")) { title = readTitle(parser); } else if (name.equals("link")) { link =...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form to have (I included the IDs for functional purposes) Further down the "Create View"...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
Flat File Connection..." Browse to the first file in the folder to loop through and select it. Set the connection manager name, specify columns as per usual. OK the connection manager and display its "Properties" Under Expressions, click the ellipsis...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
taskschd.msc > OK) - You will need administrator rights for this step. Click on Create Task... Under the General tab, for "Name" give it a general name with no symbols/special characters and preferably no spaces (I tend to give it an all lowercase name...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
) String Length LENGTH(string) BIT_LENGTH(string) CHAR_LENGTH(string) LEN(string) DATALENGTH(string) Dates / Times Weekday Name DAYNAME(now()) DATENAME(dd, getdate()) Weekday Number DAYOFWEEK(now()) DATEPART(dw, getdate()) Month Name MONTHNAME(now())...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *