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

  1. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    = "(field0:equals:" + v_myRecordID + ")"; l_SearchResults = zoho.crm.searchRecords("Tests_X_Users",v_SearchCriteria); for each r_Link in l_SearchResults { if(!isnull(r_Link.get("id")) && r_Link.get("Test").get("id")==v_ID2Delete) { m_Delete = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Deluge: Zoho Bookings Get Available Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-zoho-bookings-get-available-slots.html

    l_Workspaces = r_WorkspaceResults.get("response").get("returnvalue").get("data"); for each r_Workspace in l_Workspaces { if(!isnull(r_Workspace.get("id"))) { v_WorkspaceName = r_Workspace.get("name"); } } Get the services: // // get services...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

    :"https://books.zoho.eu/api/v3/settings/currencies?organization_id=" + v_BooksOrgID type :GET connection:"joel_books" ]; for each r_Currency in r_Currencies.get("currencies") {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

    = "2020-01"; // // loop through 2500 records v_LastID = 0; l_ProductIDs = List(); l_Pages = {1,2,3,4,5,6,7,8,9,10}; for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion.toString() +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

    { l_Actions = r_RequestDetails.get("requests").get("actions"); for each r_Action in l_Actions { if(!isnull(r_Action.get("fields"))) { for each r_Field in r_Action.get("fields") { if(r_Field.get("field_name") == "Deal_Ref") { v_DealRef =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    == 200) { // // retrieve the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices { if(!isnull(m_Choice.get("message"))) { if(m_Choice.get("message").get("role")=="assistant") { // // add the...

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

    the invoice and then when it prompts for some code, you give it the snippet below. The Magic You would create a button for each terminal /* ******************************************************************************* Function: Map Take_Payment( Map...

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

    if(r_ShipmentDetails.get("responseCode")==200) { l_Shipments = r_ShipmentDetails.get("responseText").get("shipments"); for each r_Shipment in l_Shipments { if(!isnull(r_Shipment.get("status"))) { v_ShipmentStatus =...

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

    m_ShiftRow.put("close","00:00"); m_ShiftBuildUp = Map(); l_DaysCorrectOrder = m_OrgDetails.get("business_days"); for each v_Day in l_DaysCorrectOrder { m_ShiftBuildUp.put(v_Day, m_ShiftRow); } // // ok let's get the opening times...

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

    type :GET headers:m_Header connection:"my_workdrive_connection" ]; if(!isNull(r_Subfolders.get("data"))) { for each m_Subfolder in r_Subfolders.get("data") { if(!isNull(m_Subfolder.get("attributes"))) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

    of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at the top of the list print out each row with the number...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  12. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

    - incoming, outgoing servers) Send Webmail URL Allocate space for mailbox(es) Assign passwords and instructions on changing each password Website Initiation For JoelLipman.Com to do: Download latest Joomla, MediaWiki, Wordpress or other CMS version (if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  13. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

    fields, column header text objects, and summaries or subtotals) in the column by holding down the Shift key while clicking each field, until all the fields are highlighted. Right-click any of the fields, click Size, and then select Same Width. This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  14. Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

    but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in the row - unless there's a faster way) and instead of color, click on the expression button (fx) and use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  15. List all cron jobs for all usershttps://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

    non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while read line ; do echo "${line}" | egrep --invert-match '^($|\s*#|\s*[[:alnum:]_]+=)' |...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  16. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

    1 mega dataset query, problem solved… Another workaround exists where if I added the OR part to all my datasets (so where each one says if studentreference is blank then compare to studentadaccount)… Both solutions have the issue where they will return...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

    for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times taken for "data retrieval",...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

    time is newer than the destination time. /EXCLUDE:file1[+file2][+file3]... Specifies a list of files containing strings. Each string should be in a separate line in the files. When any of the strings match any part of the absolute path of the file to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  19. T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    ** Description : This function returns a table populated with a row for each string value in the space separated string ** Assumptions : None ** Inputs : @StringInput = the space separated string values ** Outputs : Single table ** Output Rows : One row...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  20. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

    my_col2_val: 'item2c,c' } ]; What I want again: Read a CSV file already uploaded with JavaScript Populate a JS array with each row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with...

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

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.