Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming script is required, the following 99 results were found.

  1. URL Alias uniqueness with PHP & MySQLhttp://mail.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

    JoomlaCMS or WordpressCMS It creates a unique name to use in URLs I want that Why? These are used as inputs to server-side scripts for the sake of search-engine friendliness. There are no silver bullets here but I want to block any character that isn't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  2. Zoho Deluge - Get Refresh/Access Token API v2http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

    and record editing when compared to API v2. How? Note that this is using Zoho Deluge and not another server-side script such as PHP to send the requests via API. Following standard OAuth 2.0 procedures, we will get a Code to generate a Refresh token,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  3. Zoho Deluge - Compare time and currenttime with timezonehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

    two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused problems if comparing two datetime values. In this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. AutoHotkey: App GUI Listview to Rename Fileshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    AutoHotkey file and execute it, it will popup an app with 3 buttons: 1st to generate or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to A_ScriptDir) to specify what folder to...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  5. Zoho Deluge: Search Records with Special Characters (COQL)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

    the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company name. The issue is that if you use zoho.crm.searchRecords() this will work...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    v_LineItem_Name = r_QuoteDetails.Product_Name; v_LineItem_Desc = r_QuoteDetails.Product_Description; v_LineItem_Price = r_QuoteDetails.Product_List_Price; v_LineItem_Quantity = r_QuoteDetails.Product_Quantity; v_LineItem_TaxAmount =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho Creator: Copy Subform to other Subformshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

    code I create a workflow that when the decision box "Copy Monday to the Other Days" is clicked it runs the following deluge script: // only run if true if(input.Copy_Monday_to_the_Other_Days) { // init c_Tuesday = Collection(); c_Wednesday =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho CRM: searchRecords with sorted resultshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

    Set the record ID to your own record ID. Set the list of pages to the number of pages you want to search. Keep in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    for this). But we also want to push an image from Zoho Inventory to eBay. How? Again, there is a caveat in that the subscription you have or your client has, needs to be Zoho One. Because we're going to use Zoho Creator as a middleware. Just to add to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator: Disable/Hide the add and delete subform row buttonshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

    mode: add a workflow to the form whenever it is created or edited, on load of the form; I call mine "OnLoad". For Deluge Script, add the following: // // CSS overrides v_CssNotes = ""; // // this line hides the delete/cross icon next to each row...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttp://mail.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    v_Endpoint2 type: POST parameters: m_Params.toString() headers: m_Header connection: "zanalytics" ]; info r_AddRow; } Save Script and Save the workflow Change the field type to image in the ZohoAnalytics report: Go to the Attachments Data Table in Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttp://mail.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    the invoice, this had to be added (don't ever remember having to do this) as contact_ids (array/list). Instead the below script will show you how to use this API having a few email addresses as the recipients: A sample code snippet: For the below, I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Webhooks & Shopify API: Keep Disappearinghttp://mail.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

    our custom notifications exist // note that installing other apps may create similar webhooks so you need to make sure the script below is looking for your custom webhook for each m_ThisWebhook in r_ShopifyWebhooks.get("webhooks") {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    m_CreateEvent.put("zohosign__ZohoSign_Document",r_ZCrm_ZSDoc.get("id")); m_CreateEvent.put("zohosign__Description","Sent out for signature"); r_CreateEvent = zoho.crm.createRecord("zohosign__ZohoSign_Document_Events",m_CreateEvent); } } // // over to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Outputting PHP files into different file formatshttp://mail.joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

    to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type: text/plain; charset=utf-8'); header('Content-Disposition: attachment;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  16. Increment a column in MySQL using the UPDATE queryhttp://mail.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

    Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article' Combined with a PHP script this could be a few lines for something really small. The quick trick to this is to do it all in one query: UPDATE table1 SET...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  17. SSIS: Add Reference Microsoft.SqlServer.TxScripthttp://mail.joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

    This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  18. VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

    A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  19. Zoho Deluge - Regex to Strip all non-numeric charactershttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

    demo a regex and a one liner, here's a typical regular expression (match all characters not from 0 to 9) in a Zoho Deluge script: v_PaymentTermsNumber = v_PaymentTerms.replaceAll("[^0-9]",""); // yields 30 And if working with money/currencies, a one...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 81 - 99 of 99

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.