Search - Joel Lipman .Com

1. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... The deluge function So this function will return the word "delivered" or whatever other statuses there are for a package: /* Function: String fn_DHL_CheckShipmentStatus(string p_TrackingNumber) ...; Created on 21 March 2023
2. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... module which then allows you to link the Candidates to the Job Openings; but my client needed to be able to query this via API and the "Associate" table or whatever it is, was not visible in API... How? ...; Created on 08 February 2023
3. ZohoCRM: Import Attachments: / Zoho /; ... complete! Lastly, you will be pleased that the files to attach are in your CRM but unfortunately so are a ton of duplicate contacts and whatever else you had to import. So go into a listview of the ...; Created on 16 January 2023
4. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... Microsoft Store (if you don't get prompted, just go get it and install it). Install it > Agree to whatever > Restart your PC Weirdly, the BIOS will load up on my one monitor connected to my motherboard, ...; Created on 12 March 2022
5. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... but you can call it whatever you like): string DataCleansing.fn_DecodeHtmlEntities( string p_StringToDecode ) { // initialize v_StringToDecode = ifnull(p_StringToDecode,""); // // map string ...; Created on 27 January 2022
6. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... off a scheduled workflow of a call/meeting Login to ZohoCRM > Setup > Automation > Workflow Rules > Create Rule Module is "Calls" Rule Name can be whatever you want, I'm calling mine "Calls - Send SMS ...; Created on 16 December 2021
7. Zoho Creator: Change Radio into Tabs: / Zoho /; ... (Form Event) When to trigger workflow User input of a field Choose Field Tabs (or whatever you named your tabs radio field) Name the workflow, I'm calling mine OnUserInput_Tabs Add New Action > ...; Created on 22 October 2021
8. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... the line tax option of zero tax (or whatever you call zero rated tax) in the line item. Again this is included in my v2.1 example above. Should be submitted even if tax at line item level is 0. Trigger ...; Created on 17 May 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 /; ... > New Workflow Select your form Run when Created or Edited When to trigger: User input of a field Choose Field: ZohoBooks Sales Order Ref Name it whatever: eg. OnUserInput_ZBSoRef Put the following ...; Created on 15 May 2020
11. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
12. Android: Replace return key with done, go, send...: / AndroidOS /; ... taking the user to the results of searching for the text they have typed (in whatever context is appropriate). IME_ACTION_SEND // the action key performs a "send" operation, delivering the text ...; Created on 03 November 2014
13. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
14. Generate a Timesheet in MySQL: / MySQL /; ... environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at me. What I want: ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday ...; Created on 05 December 2013
15. Reorder Columns in a Table: / Databases /; ... a template and depending on if you are using MS Internet Explorer... Can't get it working? I use whatever is most useful and Google's Chrome is the fastest browser I have. Here are some ways to do ...; Created on 22 July 2013
16. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... (or whatever your script is trying to do). Method #2: FileSystemObject ComObjCreate UserFolder:="C:" -- to return file count in a folder ItemCount := ComObjCreate("Shell.Application").NameSpace(UserFolder).Items.Count FileCount ...; Created on 04 June 2013
17. Convert Decimal (Person Days) to Time in Excel: / Excel /; ... it would appear can book whatever time, eg. 5mins). 30 minutes for us translates to 0.07 in person days (a person day being 7 hours and 24 minutes or 26640 seconds). How? The answer was always ...; Created on 13 February 2013
18. Inline Labels in Form Fields using Javascript: / JavaScript /; ... in the below field. Now click on it and it disappears, allowing you to type normally. Clear whatever you type so the field is empty and click somewhere on the page (not on a link as this will take you ...; Created on 21 August 2012
19. Joomla field types clear my html: / Joomla /; ... - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no wonder customers have difficulty following. How? So it's the field on the XML file /models/forms/whatever.xml which needs the filter=raw ...; Created on 09 August 2012
20. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF ...; Created on 01 August 2012