Search - Joel Lipman .Com

1. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with ...; Created on 05 December 2023
2. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... = Form[ID == 1234]; r_Download1 = c_Form.myFieldWithFile; ***/ l_Downloads = List(); r_Download1 = invokeUrl [ url: "https://www.w3.org/WAI/ER/tests/xhtml/testfiles/resources/pdf/dummy.pdf" ...; Created on 20 July 2023
3. 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
4. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... ed to the sales order.", "documents": [ { "document_id": "12345678901234567", "file_name": "dummy.pdf", "file_type": "pdf", "file_size": 13264, "file_size_formatted": ...; Created on 15 May 2020
5. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... (dummyIndex INT); -- Alter temporary table structure to match given table SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and data ...; Created on 03 August 2012
6. Prefix Line Numbers in a Text File: / MS-DOS /; ... file) original_file.txt is your original file (obviously change the name to your file) temp.txt is just a dummy file which should be empty for clarity results_file.txt is the resulting file, it ...; Created on 18 July 2012
7. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; ... are so very fond of. You will need to use your own head to match the datatypes for including a dummy row. Also note that because I don't have any options matching the ID above ("000000-0000-..."), this ...; Created on 14 December 2011
8. T-SQL Record Separator: / Transact-SQL /; ... different to previous row)... Stage #3: Use dummy separator row Thinking logically, Stage #2 overwrites data in the last row of the day (the one marked with a separator) which happens to be data ...; Created on 11 October 2011