Assuming list is required, the following 200 results were found.
-
= "1000.aaaabbbbccccddddeeeeffff11112222.33334444555566667777888899990000"; // // build URL to query l_Params = List(); l_Params.add("refresh_token="+v_RefreshToken); l_Params.add("client_id="+v_ClientID); l_Params.add("client_secret="+v_ClientSecret);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
until Zoho have this as a setting using the GUI. Why? Our use-case is that we have a subform which gets autopopulated with a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
into how to generate an Access Token to your client's eBay store as that's covered in my article: Zoho Creator: Push to eBay Listings. Getting the Orders in XML format: /* Function: fn_eBay_GetOrders() Purpose: Queries eBay for all orders given a from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
lengths match. In this case, they are system fields for the Postal Code which out-of-the-box differ in length so they do not list the postal code on the deal record to be listed in the "Lead Conversion Mapping" page. In the Leads module, the Zip field...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
can use a custom module in ZohoBooks to store the necessary information of what to delete. Undocumented extras Just making a list of things that at-time-of-print of this article aren't in the official Zoho documentation: Query the documents folder...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ v_BooksOrgID type :GET connection:"zbooks" ]; m_Warehouses = Map(); l_Warehouses = ifnull(r_Warehouses.get("warehouses"), List()); for each m_Warehouse in l_Warehouses { m_Warehouses.put(m_Warehouse.get("warehouse_name"),...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
limit exceed Line:(10)" but it will info out each number to increment: // l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info v_Iteration; } // yields an incremental count from 0 to 4999 Statement...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
type :POST parameters:m_Params.toString() connection:"zcrm" ]; l_UniqueProducts = ifnull(r_CoqlUniqueProducts.get("data"),List()); for each m_Product in l_UniqueProducts { l_DebugNotes = List(); v_CountUnique = v_CountUnique + 1; v_ProductName =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ " "+v_Username+" "+v_UserID+" "+v_EiasToken+" "; v_Message = v_Message + " "; // v_StatusCode = 200; // v_To = ""; l_bcc = List({}); // sendmail [ from :zoho.loginuserid to :v_To bcc: l_bcc subject :v_Topic message :v_Message ] } catch(e) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ p_DealID + "?fields=Pipeline" type :GET connection:"zcrm" ]; l_DealData = ifnull(r_RecordDetails.get("data"),List()); for each m_DealData in l_DealData { if(!isNull(m_DealData.get("id"))) { r_DealDetails = m_DealData;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
upload the zip file that was just created the Index Page is /widget.html Hit Save then find the one you just created in the list and click on Install Select the profile(s) that will have access to this button and click on Save Go to a CRM account record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type:...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
MySQL Oracle equivalentshttps://www.joellipman.com/articles/database/mysql-oracle-equivalents.html
odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle - See if a table exists SHOW TABLES Select...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
I've started this list to make sure I don't spend so long anymore on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
working on iOS and certain smartphones Advantages No copyright, watermarks and as configurable as revolvermaps Can feed any list of latitude/longitude. Working on... Image Switch and color settings (done) Visitor log parsing programs for offline use.
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Groups” link at the bottom of the left menu Click on the “All People” link at the top of the left menu Find yourself in the list by using the iccle arrow next to the 0-100 (top right) Click on your own name or picture to see your profile page Click the...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Great! What follows is the code I'm using to convert this: v_Endpoint = "https://api.joellipman.com/myapi"; l_UrlParams = List(); for each v_Key in m_Payload.keys() { l_UrlParams.add(v_Key.toString() + "=" + m_Payload.get(v_Key)); } info v_Endpoint +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", 1, 200,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF