Assuming list is required, the following 206 results were found.
-
existing custom fields (not required but just in case) l_CustomFields = invoice.get("custom_fields"); l_NewCustomFields = List(); for each m_CustomField in l_CustomFields { // exclude existing custom field payment mode and date l_DontCopyFields =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= "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 Sign
- 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 Creator
- 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 Deluge
- 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 CRM
- 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 Books
- 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 Books
- 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 Deluge
- 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 CRM
- 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 Deluge
- 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 CRM
- 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 CRM
- Language: *
-
click on the link "Administration Control Panel" Click on the "General" category link at the top of the module management list (not the "General" tab in the top left) At the bottom, type ROKBB3 then press the "Create new module" button. Make sure...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
use an example that worked for me. Important: This is for Joomla version 1.6.x+. Aim / Objective Add a field with a dropdown list. Add a button to upload an avatar (and sync with 3rd party avatar). Not riveting stuff but something that all my clients...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Connection refused 111 Can't open SMTP stream. One common problem people have is an incorrectly setup mail system. Here is a list of rules that must be followed: I took this from Direct Admin but it has some useful guidelines for these kind of issues:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
some files that this will select. Modify \templates\\config.xml add the select option "Ambient Turquoise" to the end of the list: Grey Dots Tartan Lines Dark Squares Light Squares Mosaic Turquoise Color Ambient Turquoise Add a...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
the article title. In the stages thereafter, I'm going to simply enhance the relevance factor: Soundex: Built-in function to list matches that sound like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
I've used a UNION clause which will hopefully make all rooms (even empty ones) display. Note the second select statement (to list all the rooms) has to have the same number of fields as the first statement. This is the final script for the events table...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
room taken from a room bookings system. Below the details, we've connected it to the assets database and want to list the equipment and features found inside the room. Problem #1: More of an aesthetic problem than functional but when the room didn't...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB