Run commands for Windowshttps://joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 To Access… Run Command Accessibility Controls access.cpl Accessibility Wizard accwiz Add Hardware Wizard hdwwiz.cpl Add/Remove Programs appwiz.cpl Administrative Tools control admintools Adobe Acrobat (if installed) acrobat Adobe Designer (if installed)...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const PM_NOYIELD = 2 ;#End Region ;#Region Windows Messages Const WM_NULL = $0000 Const WM_CREATE =...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 dropdown. (NOTE the "More Options" button) Click on OK to sort the values Note: Office 2010: If items did not sort, then remove the column from the PivotTable altogether, hit the Data Refresh button Add the column back to the "Row Labels" Move the field...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 Don'ts: — Do NOT create TEST as a subfolder of LIVE (this will complicate backups to no end). — Do NOT overwrite/remove the TEST configuration.php file. — Do NOT enable users access till the last step. My Standard Setup LIVE - the public...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

MS Excel - Sort pivottable column headings by datehttps://joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 and sum "Values". But because the next time this happens, I would have to repeat this, I would advise the above steps to remove parentheses.

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Creating a custom form field type for Joomla XML fieldsethttps://joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 the type name (despite copying "custom_field.php" and wanting to call my type "user_projects")!!! My recommendation is to remove any non-alphanumeric characters... In your component, create a PHP file in /administrator/models/fields/ (eg....

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 AND dirs (delete from source after copying). /A+:[RASHCNET] :: add the given Attributes to copied files. /A-:[RASHCNET] :: remove the given Attributes from copied files. /CREATE :: CREATE directory tree and zero-length files only. /FAT :: create...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 ', ' '+@CaseValue+' ') -- get position of next word SET @i = CHARINDEX(',', @CaseExceptions, @i+@CaseLen) +1 END -- remove any leading and trailing spaces SET @Ret = LTRIM(RTRIM(@Ret)); -- capitalize first character of data irrespective of previous...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

T-SQL functions to convert Strings to Tableshttps://joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 BEGIN DECLARE @StringValue VARCHAR(MAX) -- Trim and remove last pipe character SET @StringInput = LEFT(RTRIM(LTRIM(@StringInput)), LEN(RTRIM(LTRIM(@StringInput))) - 1) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput,...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Import Excel CSV file as JavaScript arrayhttps://joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 = column_values || []; // ignore row if first item is blank (allows for blank excel lines) if(column_values[0] != ''){ // remove any/all double-quotes in this column value // found this method more reliable than using regex removed_quotes =...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Convert foreign characters to English alphabethttps://joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 curl_setopt($ch2, CURLOPT_CUSTOMREQUEST, 'PATCH'); // initialize fields to submit $post_fields = array(); // remove extension $this_file_name = explode('.', $name); // submit name field $post_fields['name']=$this_file_name[0]; curl_setopt($ch2,...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 > Connections > Add Connection > Give it a name and then select Scopes > and get ERROR_invalid_operation_type Solution: Remove some scopes and test. The likely ones you want are: ZohoCRM.modules.ALL ZohoCRM.settings.ALL ZohoCRM.users.ALL or to be safe...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 using a Mac with admin privileges which would open the same popup link in the parent window. The solution however is to remove the base URL and only keep the URL as something like #Page:Notify. Do NOT add the base URL such as...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 /* // Email yourself as a test but remember to remove this before going Live. sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"TEST ebay Webhook Notification" message :m_Payload ] */ return r_CreateRecord; Save the function While...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 Name the workflow, I'm calling mine OnLoad Add New Action > Deluge Script: And I add the following to my deluge script, to remove the label "Tabs": v_Css = ""; v_Css = v_Css + ".zc-Tabs-label{display:none !important;}"; v_Css = v_Css + "";...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 is important that this field will never be hidden (it cannot be seen on the front-end of the application but it must not be removed by Creator). If you know the code to remove this field, then you know what I mean. In Workflow mode: add a workflow to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 as well as the snippets when receiving the webhooks and storing them. Why? We found that Shopify would intermittently remove our webhooks. This would make the entire synchronization of the system go out of whack and some records would slip through the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 4 days after the lead creation time and assigns it to the specified user (full name of user was given in the brief but removed here for privacy). Finally, we delete any of these tasks when they get transferred to the contact record. Step 1: Workflow on...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 m_PastEvent in l_PastEvents { // // convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?) if(!isNull(m_PastEvent.get("scheduled_on"))) { if(m_PastEvent.get("scheduled_on").contains("...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *