Search - Joel Lipman .Com

1. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... photo to CRM: // init v_AppOwner = "joel_the_awesomest"; v_AppName = "joels_app"; v_ReportName = "My_Report"; // specify your CRM record ID for this product v_CrmProductID = 1234567890123456789; // ...; Created on 27 September 2021
2. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... I use but you will need to adapt it for your own system: // init (specify your own organization ID for Zoho Books) v_BooksOrgID = 20210922122; m_BooksCreateSO = Map(); // get CRM record details r_SoDetails ...; Created on 22 September 2021
3. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ...; Created on 21 September 2021
4. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... > Modules and Fields Hover the mouse cursor over the "Products" module and then over the ellipsis Click on "Customize Tax Rates" For our clients in the UK, we tend to specify the tax rates as "Standard ...; Created on 02 September 2021
5. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... this example, I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our example I am going to prefix it with "l_" (for list) and the plural of what kind of records I ...; Created on 06 December 2020
6. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... into 3 stages: Zoho Creator: Specify Custom Domain Domain Registrar: Setup subdomain and add CNAME Zoho Support: Get Zoho to setup SSL 1. Setup Custom Domain So go into your Zoho Creator ...; Created on 17 November 2020
7. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... custom javascript file referring to the ZOHO.CREATOR.init() and calling Creator records. ./plugin-manifest.json: JSON specifying service as "CREATOR". Source(s): Zoho Creator - Understand Widgets ...; Created on 24 October 2020
8. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... com.cn (China), ... v_TLD = "eu"; // my creator form f_MyImages = MyImages[Name == "Logo"]; v_Filename = f_MyImages.MyImage.getSuffix("/image/").getPrefix("\""); // specify publish key of published ...; Created on 14 July 2020
9. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to A_ScriptDir) to specify what folder to scan for files. The 3rd button ...; Created on 08 July 2020
10. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... = invokeurl [ url :v_DataEndpoint type :GET connection: myConnector ]; Solution: My endpoint was specifying COM instead of EU as per the client's data center: v_DataEndpoint = "https://books.zoho.eu/api/v3/contacts?organization_id=123456789"; r_Response ...; Created on 06 February 2020
11. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; ... month is before the current date, then set it to the last Tuesday of next month. Why? This was a request by a client who instead of specifying the 1st of every month, or 15th of each month, to say ...; Created on 27 September 2019
12. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... or account, and specifying the quantity for each. How? So depending on the number of levels, the count will be with a series if then else statements. See the results/yield section to determine ...; Created on 02 September 2019
13. MS Excel - Open CSV with Long Numbers: / Excel /; ... each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers) ...; Created on 23 July 2019
14. CSS Add Text to Breadcrumb Link with a Transition: / Cascading Stylesheets /; ... the following: /* Specify a blank prefix which is fully transparent */ ul.breadcrumb a span:before { opacity:0; content: ''; transition: all 1s ease; transition-property: width, opacity; } /* ...; Created on 18 May 2019
15. Zoho Templates - Font size is inexplicably tiny: / Zoho /; What? This is an article resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden ...; Created on 22 February 2019
16. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... WorkRng = Application.InputBox("Specify Data Range", xTitleId, WorkRng.Address, Type:=8) SplitRow = Application.InputBox("Specify Num Rows per Sheet", xTitleId, 5, Type:=1) Set xWs = WorkRng.Parent ...; Created on 11 February 2019
17. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... arrays. I can also output any of the variables and responses for debugging purposes. I can also unset multiple branches of variables with fewer commands than unsetting specific variables. Let's specify ...; Created on 02 February 2019
18. Zoho Inventory Template Issue: First Page is Blank: / Zoho /; What? So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product ...; Created on 15 November 2018
19. Display Feeds to major Social Networks: / Web-Development /; ... Replace https://www.facebook.com/myfacebookpage with your facebook URL and replace My Facebook Page with the title of your facebook page. (You may need to specify the app in the Facebook developers ...; Created on 16 May 2016
20. Accessing Apimo WebService API: / API Miscellaneous /; ... IDs to match your own solution): // specify provider ID $my_provider_id = 1234; $my_timestamp = time(); // specify company ID $company_id_1 = 1234; $company_id_2 = 4321; // specify agency ...; Created on 29 March 2016