Search - Joel Lipman .Com

1. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
2. Zoho Creator / Shopify: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's Shopify. Why? The use-case was that I wanted to search ...; Created on 12 October 2021
3. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // ...; Created on 22 January 2022
4. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
5. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... need to follow these steps to get the credentials: Login to your Twilio console On the dashboard, note the ACCOUNT SID and AUTH TOKEN In the side menu, expand Phone Numbers > Manage > Active numbers ...; Created on 16 December 2021
6. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... each r_User in r_Users.get("users") { // loop through active users if(r_User.get("status") == "active") { v_Email = ifnull(r_User.get("email"),""); v_LastName = ifnull(r_User.get("last_name"),""); // // ...; Created on 02 December 2021
7. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... "permalink": "https://docs.zoho.com/file/a1b2c3d4", "status": "active" }, { "created_time": "2019-08-28T16:30:33Z", "modified_time_ms": 1567009834477, "owner_id": "34567890", ...; Created on 21 October 2021
8. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
9. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... is written at a time when Javascript or interactive pages that change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in ...; Created on 22 October 2020
10. Zoho Deluge - InvokeConnector and useful snippets: / Zoho /; What? So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded ...; Created on 23 January 2020
11. Zoho Deluge - Get Current User ID: / Zoho /; ... being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer functions. Method #1: API v1 userResp = getUrl(("https://crm.zoho.com/crm/private/xml/Users/getUsers?authtoken=xxxxxxxxxxx&scope=crmapi&type=ActiveUsers")); users ...; Created on 08 April 2019
12. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... Application.ActiveSheet.Range("A1").PasteSpecial Set xRow = xRow.Offset(SplitRow) Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Press ...; Created on 11 February 2019
13. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
14. Import Excel CSV file as JavaScript array: / Excel /; ... XMLHttpRequest to read file // (works at time of print (2015-10-05)) var xhr = !window.XMLHttpRequest ? new ActiveXObject('Microsoft.XMLHTTP') : new XMLHttpRequest(); // open ...; Created on 05 October 2015
15. Joes Chart Generator (JCG) Downloads: / Downloads /; VersionPlatform ChangeLogOptions1.0 + Group all the data by a specified column + Generate interactive flash charts- Date Uploaded: Wed, 15th Sep 2010 Download; Created on 07 September 2015
16. CSV Chart Generator: / Product Documentation /; ... a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive ...; Created on 04 September 2015
17. Excel: Extract hyperlink from link: / Excel /; ... a new module (Insert > Module) Copy and Paste the Excel user defined function belowSub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End ...; Created on 06 November 2014
18. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... [1.7.0] Map: latitude/longitude in tooltip data - [1.7.0] Map: default settings from profile file - [1.7.0] News: offline redirects to help page - [1.7.0] Hangar: interactive quick reference image - ...; Created on 24 October 2014
19. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; ... supplier helped setup along with the XML that will be sent to our database table. Be sure to use the same XET code and that the "Active" checkbox is ticked. Store/save your EOR Setting ...; Created on 21 August 2014
20. Client Services: Website Development Agreement: / Static Items /; ... rate). Note that my servers are based in Houston, Texas, USA (due to their traffic [when europe is active, these are not and vice-versa] and resilience [99.99% uptime] status compared to European ...; Created on 15 November 2013