Search - Joel Lipman .Com

1. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... on filename changes, I run this bit of code to get the internal and current file name: // // get original document file (optional) - you need your own record ID here v_ZC_DocumentRecordID = 1234567890123456789; c_ExistingDocument ...; Created on 25 March 2024
2. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... Update 2023: This solution has been superceded by instead directing the ZohoTicket Attachment trigger (internal webhook in ZohoDesk rather than on Ticket Edit) and creates a row in a ZohoCreator report ...; Created on 05 December 2023
3. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... "Fn - eBay - Get Active Products" and give it the internal name as "fn_GetEbayActiveProducts" without any arguments. Something to note in the below is that it asks you to set an estimated number of products ...; Created on 01 March 2023
4. ZohoCRM: Import Attachments: / Zoho /; ... database and column B contains the filename as downloaded from the 3rd-party database. And an internal file where column A is the ZCRM Record ID (eg. if Contacts module then the CRM Contact ID) and column ...; Created on 16 January 2023
5. Zoho Creator: Change Radio into Tabs: / Zoho /; ... = ""; // align radio options horizontally v_Css = v_Css + ".zc-Tabs-group .choice-table-row"; // fix internal padding ("Quote" was higher then other radio options) v_Css = v_Css + ".zc-Tabs-group .choice-table-cell"; // ...; Created on 22 October 2021
6. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... + v_ListingPublishKey + "/" + v_Filename; URL Syntax #4 The following won't work for the example below as it doesn't have the publish/public key, but it can be used internally: // DOESN'T WORK ...; Created on 17 October 2021
7. Zoho Projects: Deluge to Submit Custom Fields: / Zoho /; ... = ; m_Params = { "name": "My Happy Project", "flag": "internal", "milestone_id": 98765432109876540, "tasklist_id": 78901234567890130, "person_responsible": "20211234567", "duration": "1", ...; Created on 17 June 2021
8. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... ]; v_NewCreatorID = if(r_HoldInCreator.trim()!="", r_HoldInCreator.toLong(), 0); if(v_NewCreatorID != 0) { // re-get this record (to get the internal file ...; Created on 02 February 2021
9. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... of your widget: Name: to whatever you want Hosting: I select “Internal” though the benefits of “External” could be for development updates (untested). Widget File: upload the ZIP file from your dist ...; Created on 24 October 2020
10. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... the link name of your subform v_FieldName = "myField"; // put here the link name of the field in that subform v_PermalinkCode = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKL"; v_FileInternalName ...; Created on 15 May 2020
11. GDPR Privacy Policy: / Static Items /; ... the information we gather We require this information to understand your needs and provide you with a better service, and in particular for the following reasons: Internal record keeping. We may use the ...; Created on 14 February 2019
12. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... the web? I have tried adding the following to my headers: This does nothing: // add these to the header: DOESNT WORK mb_internal_encoding('UTF-8'); mb_http_output('UTF-8'); mb_http_input('UTF-8'); ...; Created on 25 January 2016
13. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file // header('Content-Type: application/json'); // seems to cause 500 Internal Server ...; Created on 28 March 2015
14. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
15. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... but for the time being they are on the internal storage (like most apps). If you want to backup the files for the hangar, they are stored in this apps files folder: /sdcard/Android/data/com.joellipman.quadcopterapp/files/hangar/ ...; Created on 24 October 2014
16. T-SQL: Parse an XML value: / Transact-SQL /; What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...; Created on 27 March 2014
17. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about ...; Created on 07 March 2014
18. MS-DOS: Copy folders without overwriting files: / MS-DOS /; What? A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal ...; Created on 23 February 2014
19. Proposed Budget i3 PC under £200: / IT Support /; ... 4 x S-ATA 300, Micro ATX, PCI Express 3.0, AsRock XFast USB, AsRock Instant Boot) - ASrock £37.58 Hard Drive Western Digital Caviar Blue 160 GB (7200 rpm) SATA 8 MB 3.5 inch Hard Drive (Internal) ...; Created on 26 January 2013
20. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... := 0; -- v_char_at : internal variable for string indexing v_rand_param1 VARCHAR2(50) := ''; -- v_rand_param1 : parameter 1 for dbms_random function v_rand_param2 ...; Created on 22 August 2012