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

  1. Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

    I worked 45 minutes on setting up a Joomla 2.5.x demo site; I started at 9am and finished at 9:45.", "Monday morning, I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

    To view these or output to screen: print_r($credentials); Worthwhile Note(s) Allowing the scope to access the user profile also sends through a JSON Web Token (JWT) under the variable "id_token". This will be included in the response from the Google...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  3. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

    this will simply tell you what the link is to go to. Agree and note the code parameter passed in the URL (ie. "&code=..."). Also note that any generated code immediately expires any previously generated code. Refresh Token With the code you have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  4. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    appear to be included in any sync... This method would be enough if the action was instantaneous and the attachments were also attached to the Sales Order in Books... but it isn't and doesn't. It only attaches the file(s) to the CRM record. See my...

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

    July 2020 ; - Initial Release ; Date (v1.1): 10 August 2020 ; - Checks for duplicates done by searching its own column. ; - Also checks for duplicates if file exists. ; - Leaves original file as is. ; ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  6. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    ] } ] } Updating with REST API v2.1 The new process doesn't just require you to add in this custom field per line item, but also requires a change to the other fields in the line item. There is an additional note that when using v2.1, you no longer post...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

    you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have "Num Lock" on/enabled. Typing a special character is 3 easy steps: Hold down the ALT key (preferably the...

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

    Which results in a map that I can give a Product SKU to and it will return the Shopify Product ID to me. You may have noted also the precarious method in retrieving the product variant SKU (this will error/fail over if a product doesn't have a variant)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

    exception, Invalid statement found Line:(20) However, I'm not bad at producing errors so here's another snippet that will also cause the error: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

    only 1 graphics card. Why? This took me a good few hours to get working so I thought this article could help others. It's also a chance to show off my build. Although not high budget like lots of YouTubers I drew inspiration and advice from, it's my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  11. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

    being ideal. Instead, let's use a CRM function to store the conversation between ChatGPT and the CRM User. This way, we can also ensure that the data shared can be controlled/monitored. Create a CRM Module called "GPT Chats" (singular: GPT Chat) Modify...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

    I had this formula which seemed to do the same thing but unnecessarily moved the pointer to the start of the week. It could also error eventually if Zoho made it possible to change the start of the week (this is in ZohoCreator; I'm aware that some of...

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

    } } } } // // email the invoice (using template and updating comments/history) - also marks as sent m_Params = Map(); // recipients is a list of emails unlike contact persons in invoice request m_Params.put("to_mail_ids",l_ZB_InvoiceRecipients);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

    function that will work on any CRM and possibly be quick to adapt to a module other than products. This function will also try to delete the duplicate but if the duplicate is the one used in a transactional module record (eg. quotes, sales orders,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    survey. GENERAL was the first page asking for lead/contact name when I have this prepopulated from a ZohoCRM integration. Also note that the question number comes from it prefixing the question per page that the client did when setting up her survey...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

    ZDK.Page.getField("Unit_Price").setValue(v_ProductPriceFormatted); // and if we don't want/need to check, just round em (also means you don't need the above function to count decimals) var v_ProductCost = ZDK.Page.getField('Purchase_Rate').getValue();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

    use of this website may give rise to a claim for damages and/or be a criminal offence. From time to time this website may also include links to other websites. These links are provided for your convenience to provide further information. They do not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  18. Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

    which we think you may find interesting using the email address which you have provided. From time to time, we may also use your information to contact you for market research purposes. We may contact you by email, phone, fax or mail. We may use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  19. Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html

    a test pancake to see if you're using the correct amount of batter. I find 2 tbsp is about right for an 18cm/7in pan. It's also helpful if you spoon the batter into a ladle so it can be poured into the hot pan in one go. As soon as the batter hits the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  20. How To Make Chocolate Chip Cookieshttps://www.joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

    about 4 dozen cookies. Source: http://www.videojug.com/film/how-to-make-chocolate-chip-cookies {youtube}h-gYZfuIiYY{/youtube}Also see Vegan-Style Chocolate Chip Cookies

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
Results 21 - 40 of 134

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.