Search - Joel Lipman .Com

1. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; What? This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form ...; Created on 23 June 2021
2. SITS: XET format for Export not available: / Extensible Markup Language /; What? Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard ...; Created on 08 August 2014
3. View your available module positions: / Joomla /; Update for Joomla 2.5.x Note that Joomla versions 1.6 upwards include this as an option in the global configuration settings which you can access using your Joomla admin panel: Template Manager Options ...; Created on 15 September 2009
4. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... v_TotalProducts + " in " + v_TotalCategories; // // if categories >= 100 then should loop this to get all the categories Code to get all products Here we need to loop through all the availabl ...; Created on 15 April 2024
5. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... key here to enable inventory tracking m_CreateBooksItem.put("item_type","inventory"); // // other less important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0); m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong()); m_CreateBooksItem.put("initial_stock",v_Quantity.toLong()); m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal()); m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...; Created on 04 May 2023
6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
7. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for ...; Created on 29 March 2023
8. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... that the new table and columns will be available to us): SELECT c."Full Name", c."Lead Source", cp."Campaign 1", cp."Campaign 2", cp."Campaign 3" FROM "Contacts" c LEFT JOIN "Contacts vs Campaigns ...; Created on 20 March 2023
9. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... Planning Need to ensure data fed into a session is not shared or available to external sources once entered into OpenAI. If I train OpenAI on a dataset, can that data be accessed by external sources? No, ...; Created on 06 March 2023
10. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... = 1500; // // now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumProducts / v_PerPage); l_AddPages = leftpad(" ", v_TotalNumberOfPages).replaceAll(" ...; Created on 01 March 2023
11. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate ...; Created on 28 February 2023
12. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... mode is only available in the most expensive subscription plan. NSFW will likely be blocked. Installing Stable Diffusion on a local server is the recommended stealth mode. Check out Matt Wolfe's video ...; Created on 11 February 2023
13. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... these kind of columns available to you: Click on Widget in the top right Under "Data Column", select any field in your table/query which is not the one to display Under "Group By", select the field ...; Created on 24 October 2022
14. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... : 5, "actualQueryCost": 5, "throttleStatus": { "maximumAvailable": 1000, "currentlyAvailable": 995, "restoreRate": 50 } } } } Additional Note th ...; Created on 14 February 2022
15. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are: Setup recurring FTP connection. Make data readily available to ZohoCRM. ...; Created on 12 January 2022
16. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... and select both tax rates Now go to a transactional module that has line items and use the product When you click on the edit icon in the line item "Tax" you will see both options available to be ...; Created on 02 September 2021
17. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... response somewhat similar to the following: // this is sample JSON with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url": "/crm/org12345678901/specific/ViewAttachment?fileId=aaaabbbbccccddddeeeeffff1111222233334&module=CustomModule1&parentId=123456789012345678&creatorId=987654321098765432&id=234567890123456789&name=dummy1.pdf&downLoadMode=default", ...; Created on 02 February 2021
18. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... Chrome profiles available from your login." Version := "1.0" Width := 400 Height := 800 BgColor := "FFFFFF" MarginX := 2 MarginY := 2 Options := "+Caption +Border +OwnDialogs" TempDir := "C:\Windows\Temp" ; ...; Created on 07 January 2020
19. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; ... item and filtering the options available for selection. Why? This was for a multi lookup with staff as the list entries. The lookup needed to filter against various forms such as Staff Rotas, Leave ...; Created on 28 June 2019
20. Zoho Deluge - Get distance between two coordinates: / Zoho /; ... as the crow flies. Update 2020 Not sure exactly when but Zoho have made available this function in Creator: = zoho.map.distanceBetween(, , ); // where unit can be "MILE", "KILOMETRE" or "NAUTICAL" ...; Created on 11 June 2019