Assuming follows is required, the following 26 results were found.
-
message box. How? There are links to how to create a widget in detail which I'll link to at the bottom of this page. What follows are the quick steps to create a widget.html file and how to get whatever the Zoho Deluge CRM function returns. Create a JS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
URL v_AnalyticsOrgID = "123456879"; // // go to the web chart we made in analytics and look at the URL: // the workspace ID follows the /workspace/ // the view ID follows the /view/ part v_WorkspaceID = "1234567000008912345"; v_TableID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
a table with the same report mentioned several times but just in a different week. I want a returned table structured as follows: Report Name Run Last Week Run This Week ------------------ ----------------- ------------------- Report 001 5 2 Report 002...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // lists Day_Names = List:String({"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"}); Day_Abbreviations =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
value passed for JSONString"}: Can happen when posting to ZohoBooks and you haven't put JSONString into a map as follows: m_Header = Map(); m_Header.put("Authorization","Zoho-oauthtoken " + v_AccessToken);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
12:30, 1923-10-16 15:00 This above snippet of code, loops through the sorted list of keys and retrieves each record as follows: {"name":"Amazing","id":335448,"date":"1997-07-05T23:15:00+00:00"}...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
} return v_Output; } Sends something like the following request (sent using Zoho Deluge but the cURL breakdown as follows): curl -d '{"image":{"position":1,"attachment":"/9/R0lGODlhbgCMAPf......... Q7PCAAOw==\n","filename":"my_test_photo.jpg"}}' -X...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
+ v_BooksOrgID type :GET connection:"zbooks" ]; info r_PaymentTerms; } This should yield something as follows: { "code": 0, "message": "success", "data": { "payment_terms": [ { "payment_terms_id": "123456000000000123", "payment_terms": 15, "is_default":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
more of a play around to see what can be achieved and how much this can be customized. The task I've set for myself is as follows: Trigger if the contact record has a tickbox called "Extra Confidential" ticked/checked=true Popup a confirmation box to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
synchronization between your Zoho People and Zoho Analytics instances failed. The last synchronization data we have is as follows: "; if(!isNull(m_DataSourceInfo.get("datasourceName"))) { for each v_DataSourceKey in m_DataSourceInfo.keys() { v_Message =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
importing a table based on a query which joins the sales orders and purchase order items by the custom lookup field. What follows is the code required to build the custom related list in ZohoBooks: /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
"Accounts" acc ) AS t1 LEFT JOIN "Joels Image Library" img ON t1."Status" = img."Status Value" This produces something as follows: Create a widget that shows an image This step here will create a widget that will show the last image (or first image if...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
after Zoho confirms it’s safe. Once the backend team confirmed there was no risk to balances, the correct approach was as follows: Resolution Confirm permissions. Sign in as the Super Admin in Zoho Books. Feed management options can be hidden for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
$Itemid; mosRedirect( $link, _THANK_MESSAGE ) replace that code with the URL for the contact Thank-you page as defined as follows: $link = sefRelToAbs( 'index.php?option=com_contact&task=view&contact_id='. $contact[0]->id .'&Itemid='. $Itemid );...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
whatever you usually do when you modify a server-side file... ahem... The code by to look for (joomla default) should be as follows: $_REQUEST['tmpl'] = 'component'; include('index.php'); There is some more text but it's in /* lines */ which means these...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
the following PHP file, I've named this file "article.php" (thanks to my amazing imagination). The contents of which are as follows:
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
https://www.googleapis.com/auth/userinfo.profile How? I've listed below 3 methods, the first follows the manual (or the logic thereof as I don't use the client library) and is a function sending two requests, the second is the appropriate multipart...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
is our employee number and the second column will be the remaining data on that row. So I setup my connection manager as follows (note the "Ragged Right" and delimiter as "{CR}{LF}" - my rows to skip is because of the state of my data): Crucial fix...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
15 The one lookup task: Changing the lookup to "use results of an SQL query": Which would code with the joined tables as follows (note that in our case we needed the lookups on the source database which was not the same as our staging one which this...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
The Group expression used in grouping 'table1_month' returned a data type that is not valid. My DataSet Query was as follows: SELECT CONCAT(MONTHNAME(t1.Date), ' ', YEAR(t1.Date)) Month, SUM(IF(t1.VisitorBrowser='MSIE', 1, 0)) 'IE',...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *