Search - Joel Lipman .Com

1. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; What? This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in ...; Created on 08 October 2021
2. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; What? So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a ...; Created on 06 May 2019
3. Select unique values in Microsoft Excel column: / Excel /; ... This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the ...; Created on 03 July 2012
4. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... + v_ConditionDisp + " "; // // unique item reference if(c_Quote.Quote_Reference.contains("Q-")) { v_ItemDescDisp = v_ItemDescDisp + "Ref. " + c_Quote.Quote_Reference + " "; } %> ...; Created on 07 May 2024
5. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... How? My team of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of all Customers Remove the ...; Created on 12 July 2023
6. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... artistic, unique, award-winning photograph, Canon EOS 5D Mark IV DSLR, f/8, ISO 100, 1/250 second, close-up, natural light, professional, flattering, headshot::3 black and white, grainy, deformed, watermark::-2 ...; Created on 11 February 2023
7. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... Another single line text field Candidate x JobOpening Name: Mandatory name field that we will use so as to create unique records The connection Within any syntax editor of ZohoRecruit (where you ...; Created on 08 February 2023
8. ZohoCRM: Import Attachments: / Zoho /; ... the reverse process, the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" ...; Created on 16 January 2023
9. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... ZDK.Page.getField('Skillset').getValue(); var l_AlreadyListed = Array(); // loop through subform rows and check if column "Skill" has unique values for (var i = 0; i < l_SkillsSubform.length; i++) { ...; Created on 09 December 2022
10. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... owner, and that it is unique for every Kindle device. Finding your Kindle email address. That’s assuming you are not aware of yours. However, if you know your Kindle email ID, you can skip this ...; Created on 29 June 2022
11. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... Here's the Creator form to hold the Attachments: Parent Record (a single line that will be a unique ref to prevent downloading the same record again and again) Document Name (a single line that ...; Created on 11 March 2022
12. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... a slightly transparent red background (if they do, then add the field again and delete the one highlighted in red - alternatively give it a unique name in the record). Then map the fields using the dot ...; Created on 21 October 2021
13. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; What? A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! ...; Created on 09 March 2020
14. Copy a Wordpress Site for Development: / Wordpress /; ... 'localhost'); /** * Authentication Unique Keys and Salts. */ define('AUTH_KEY', 'my_auth_key'); define('SECURE_AUTH_KEY', 'my_secure_auth_key'); define('LOGGED_IN_KEY', 'my_logged_in_key'); define('NONCE_KEY' ...; Created on 08 March 2015
15. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... about you: • If shared, your public name (not unique and only the first name) • Your selected aircraft (by public name or \"anonymous\") What joellipman.com stores about you: • Your login/username ...; Created on 24 October 2014
16. XML Schema Reference: / Extensible Markup Language /; ... namespace to a document key Specifies an attribute or element value as a key (unique, non-nullable, and always present) within the containing element in an instance document keyref Specifies ...; Created on 13 August 2014
17. T-SQL concatenate an incremental row number: / Transact-SQL /; ... QualificationRef 001 00101 001 00102 002 00201 -- Qualification Ref is a unique number using the -- Employee Number concatenated with a 2 digit sequence -- number ...; Created on 24 May 2013
18. AwStats Data Parser (ADP): / Product Documentation /; ... as to your unique visitors (referred to as visitors), the visits these generated (visits), the number of files/scripts/images requested (hits) and their filesize (bandwidth). Purpose: To extract ...; Created on 03 April 2013
19. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... positions) Needle1a := "My Unique Table Heading" ; Needle1a is a marker for a unique value in the whole content Needle1b := "" ; Needle1b ...; Created on 30 March 2013
20. Export/Import Database using MySQL Workbench: / MySQL /; What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? ...; Created on 05 February 2013