Search - Joel Lipman .Com

1. Drop If Object Exists: / Transact-SQL /; ... of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF ...; Created on 03 August 2012
2. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; ... dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL. When I leave the 3rd and 4th parameter untouched (=""), the ...; Created on 14 December 2011
3. Sort order a dropdown list in MS InfoPath without programming: / Infopath /; So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just ...; Created on 21 July 2011
4. Add a template to the dropdown in Kunena: / Joomla /; This is what I had to do to be able to add another template to the dropdown in the Kunena configuration panel: Download your site from your server to a copy on your local disk (hard disk, flash ...; Created on 20 September 2009
5. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... file to be hosted within Zoho Creator for use by a JS widget that will download the CSV (in this case a Text *.txt) file for use by a dynamic auto-suggester dropdown; one of those fancy ones that includes ...; Created on 25 March 2024
6. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... (Bear) Vespine (Wasp) Botanical Fernaceous (Fern) Lupine Rosaceous (Rose) Backdrops Beach Car Desert Factory Forest Horizon Lake Lawn London Mountains New York Paris Piscine ...; Created on 11 February 2023
7. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report. How? We would think it similar to a picklist/dropdown where ...; Created on 18 August 2022
8. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now: / Zoho /; ... Click on “zoho.eu” this will dropdown all Zoho apps Click on “desk.zoho.eu” Click on “Clear Data” You will be prompted to confirm, click on “Clear” Then also click on “Reset Permissions” (usually ...; Created on 20 July 2022
9. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the value of each radio item will be populated using deluge and what's important to note here is that each picklist/dropdown option includes some HTML, specifically a SPAN tag surrounding the date number ...; Created on 09 March 2022
10. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... == "Customer_s_Timezone") { // loop through all the picklist values of this dropdown for each r_TimeZone in r_Field.get("pick_list_values") { if(r_TimeZone.get("display_value").containsIgnoreCase(v_TimeZone)) { v_CustomerTimeZon ...; Created on 15 December 2021
11. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... it just wants the dropdown option equivalent (eg. "10 mins", "1 hrs") Just as a refresher if this was a task and not a call: v_ReminderDate = v_SystemAppointmentDateTime.subMinutes(15); v_ReminderStr ...; Created on 18 November 2021
12. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
13. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... r_Coql; Additional If you wanted the unique values of a picklist/dropdown, then consider an invokeUrl looping through the fields settings in CRM. Source(s): Zoho CRM Developer Docs API v ...; Created on 08 October 2021
14. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... > blank Name the form, I'm going to call mine Shopify Webhook Payloads Drag some fields onto the form, this is what I did: Event Type [Drop Down: with options "Order Update", "Inventory Update", "Product ...; Created on 15 July 2021
15. Zoho Creator: Add a subform while creating a record: / Zoho /; What? This is an article to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create ...; Created on 14 July 2021
16. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... 2. Code to push Time Log entry to Zoho Projects: Example #1: Pushing a time log with a specified start date/time (requires end time field if using): // // init (from dropdowns you have made applicable ...; Created on 30 April 2021
17. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator: / Zoho /; ... i.e. Cannot match picklist option in Creator (Options 2 is split from 3) Solution: In the Creator picklist/dropdown options, change any comma to , then in your CRM code to create the record ...; Created on 20 April 2020
18. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... "$2", trim($v_Output, "_")); // returns a string return $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the value of url_alias: DROP ...; Created on 06 May 2019
19. List of Font Awesome: / Web-Development /; ...  fa-dropbox [] 4.1  fa-drupal []  ...; Created on 04 September 2015
20. 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