Search - Joel Lipman .Com

1. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; .joellipman-alt-code-table{ width:100%; max-width:400px; margin:0 auto; border:1px; } .joellipman-alt-code-table td:first-child{ width:40px; } .joellipman-alt-code-table td:nth-child(2){ width:300px; } What? ...; Created on 03 June 2021
2. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? ...; Created on 09 May 2019
3. SITS: Export field code and name: / Extensible Markup Language /; ... code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter ...; Created on 12 August 2014
4. Alternative method of displaying Unicode in Autohotkey GUI: / AutoHotkey /; Well yes you could just use the Unicode version of Autohotkey. If you're looking for some up and down arrows which is all I wanted, then you don't have to use Unicode and you can use the Chr() function: ...; Created on 29 September 2011
5. Code Troubleshooting Checklist: / Web-Development /; So I've started this list to make sure I don't spend so long anymore on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web ...; Created on 03 June 2011
6. UTF8 Unicode PHP MySQL for International Characters: / Personal Home Page /; This is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international ...; Created on 22 October 2010
7. Language Codes: / Joomla /; ... and narrow-minded to think only English speakers will use Joomla! CMS. The below is for reference only: Language Codes af Afrikaans sq Albanian ar-sa Arabic (Saudi Arabia) ar-iq Arabic (Iraq) ...; Created on 13 September 2010
8. Creating a Top 10 chart with less code: / Personal Home Page /; ... PHP script to loop through the results of the above query Display the value of column1 and CountOrder The old code would have been: echo '# | Search Term | Count' . "\n"; # ...; Created on 18 February 2010
9. This file contains HTML or script code that may be erroneously interpreted by a web browser: / Hypertext Markup Language /; The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making ...; Created on 08 October 2009
10. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... + v_BooksOrgID type :GET connection:"joel_books" ]; for each r_Currency in r_Currencies.get("currencies") { m_Currencies.put(r_Currency.get("currency_code"),r_Currency.get("currency_id")); } info ...; Created on 24 September 2021
11. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... the following request to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678", "currency_code": "GBP", "reference_number": "Salespersons ...; Created on 22 September 2021
12. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... article to go through various methods I tried to prevent this from happening: First - Off: The one workflow to rule them all In the first instance, we don't want large amounts of code to be copied ...; Created on 19 September 2021
13. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... (similar to team name) and wanted any Opportunity record to have a field showing the user's Division. This would help in reporting later down the line. How? The following code snippet will get the ...; Created on 01 September 2021
14. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons in Zoho Books, and retrieving the salesperson_id. Also I have a connector to ZohoBooks called "joel_books". The ...; Created on 30 August 2021
15. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); The slightly longer answer to describe this might be better explained if you consider the following snippet of code: // ...; Created on 26 August 2021
16. ZohoCRM: Process all records of a module: / Zoho /; ... doesn't matter as long as it's a field to update In your code, sort a list by "Modified_Time", loop through and update each iterated record. (see sample code below). Go to the list view in CRM and filter ...; Created on 24 August 2021
17. Xero API: Send Multiple Invoices: / Xero /; ... "TaxAmount": 48, "AccountCode": 3610, "DiscountAmount": 24, "Tracking": [ { "Name": "Activity", "Option": "ELEPHANT" ...; Created on 15 August 2021
18. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; What? This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting ...; Created on 30 July 2021
19. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... Add your deluge code that should: Validate the fields (checks mandatory fields have been entered) for example: // // check mandatory fields have been entered l_Errors = List(); if(isnull(input.Record_Name)) { l_Errors.add("- ...; Created on 27 July 2021
20. Zoho Creator: Add a subform while creating a record: / Zoho /; ... a quote record and include a subform containing the line items. You may have tried code where you add a record first and then add the subform afterwards (insert into [...]) but it can be done all in one ...; Created on 14 July 2021