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 false is required, the following 61 results were found.

  1. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    = {1,2,3,4,5}; // loop through times you will chance it for each v_TimeTried in l_TimesTried { // init b_BadWordFound = false; // get attempt v_Output = thisapp.generateRetrievalCode(); // see if can use contains but check for word for each v_BadWord...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    note the lowercase P l_ProductDetails = Product[Product_Name == v_Name]; b_Exists = if(l_ProductDetails.count() > 0, true, false); if(!b_Exists) { // insert into Product table r_ProductCreate = insert into Product [ Product_Name=v_Name...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

    OutputContent, %PreferenceFile% NameStart := InStr(OutputContent, """name"":""")+8 NameEnd := InStr(OutputContent, """", false, NameStart+1) NameLength := NameEnd - NameStart ClientName := SubStr(OutputContent, NameStart, NameLength) LV_Add("",...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  4. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

    Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); // yields 15-Apr-2020 17:00:00 Additional The reverse (date string to unix seconds)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    of you may be asking why not use openUrl with a popup parameter, such as: openUrl("#Form:My_Confirmation_Popup?zc_Header=false","popup window","height=144,width=555"); The reason being, is that the top solution offers a very generic popup box that can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

    r_Record); } } // // now sort list in descending order and action each record l_SortedKeysDesc = l_SortingKeys.sort(false); for each v_SortKey in l_SortedKeysDesc { m_ThisRecord = m_UnsortedRecords.get(v_SortKey); info m_ThisRecord; } Recap The original...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

    checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this end, I have thought of an alternative that I now use frequently in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name == "eBay API (Sandbox)"]; //info "Sandbox...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

    "id": "123456789000000004" }, { "Currency": "USD", "id": "123456789000000005" } ], "info": { "count": 3, "more_records": false } } Amazing! Let's go one further for a lookup field, in this case the account name field on the quotes record: // // build up...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    product id... if(!isNull(input.Shopify_Product_ID)) { m_Product.put("id",input.Shopify_Product_ID); b_CreateProduct = false; } // // title and HTML m_Product.put("title",input.Listing_Title); if(!isNull(input.Full_Shopify_HTML_Code)) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

    m_ActiveList.put("Sort","ItemID"); // // exclude other lists m_Exclude = Map(); m_Exclude.put("Include", false); m_Params.put("DeletedFromSoldList",m_Exclude); m_Params.put("DeletedFromUnsoldList",m_Exclude); m_Params.put("ScheduledList",m_Exclude);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

    m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present"); m_Params.put("capture_method","manual"); v_DescriptionString =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. ZohoDeluge: Check Shipment Status via DHL APIhttps://www.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

    } } // // return response return v_ShipmentStatus; Alternative get request: r_ShipmentDetails = getUrl(v_Endpoint, m_Header, false); Not done yet! Of course, it would help if when something was delivered, that was conveyed back to the system that asked,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

    "business_timing": [ "09:00", "15:00" ] } ], "daily_timing": null, "week_starts_on": "Monday", "same_as_everyday": false, "id": "123456789000000123456789", "type": "custom" } } Tidied Up Want that in a practical format for use in ZohoCreator? Preferably...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    to UTC. b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") != zoho.currenttime.toString("HH:mm", "GMT"), true, false); info b_IsDSTInEffect; // v_TimeZoneOffset = if(b_IsDSTInEffect, "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

    ", " and "}; for each v_Exception in l_Exceptions { v_LastName = v_LastName.replaceAllIgnoreCase(v_Exception, v_Exception, false); } v_LastName = v_LastName.trim(); // // join all together v_FullName = trim(v_FirstName + " " + v_LastName); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

    // // upload the file r_UploadResponse = zoho.workdrive.uploadFile(f_UploadCsvFile,v_WorkdriveFolderID,v_UploadFilename,FALSE,"my_workdrive_connection"); if(!isNull(r_UploadResponse.get("data"))) { // looping but only have 1 upload so getting permalink...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    function I'll give it the following code (amend the org ID and connection name): // // initialize b_ValidResponse = false; v_EstimateID = "-"; v_OrgId = "123456789"; v_Output = "Unable to process request"; // // evaluate v_Intent =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    m_ZBooks_LineItem.put("rate",v_ListPrice.toString().replaceAll("^(\d+\.\d{2})\d*$", "$1", false)); Works a treat at truncating but still does NOT match how ZohoBooks does it. ZohoBooks rounds the .545 to .55 and .544 to .54... so let's abandon the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Joomla Development: Possible XML Filtershttps://www.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

    absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true or false WORD Strips anything that is not letters (including numbers) ALNUM Forces the value to be alphanumeric (Letters and numbers...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 41 - 60 of 61

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.