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

  1. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    to the above code retrospectively without proper testing. Aggregate of total amount may be unnecessary as this could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

    You will get a warning that you are selecting a field that is already being used in a rule. Seems that I can't select the same field in a third layout rule... Easy without coding and probably everyone figures this one out but I thought I'd add it here...

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

    for coql v_SearchName = v_ProductName.replaceAll("'","''",true); // v_KeepID = 0; // // get other products with the same name (set in order of oldest first and keep only first one, delete the others) m_SubParams = {"select_query":"select id,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. 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

    but it beats the accounts staff having to enter the adjustment each time. The create invoice process would be treated the same. The below are all the various methods I tried to resolve this but the truth is that I do not have a clue how ZohoBooks comes...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    of quoted items to invoiced items (i console logged out this line item and copied each of the fields hoping they had the same API name in both modules) o_NewLineItem.CUSTOM = o_ThisLineItem.CUSTOM; o_NewLineItem.Config = o_ThisLineItem.Config;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

    the following so that it makes sense to a trainee: "" // wait for completion and if paragraph is ok Could you do the same with the attached please? Feel free to include details of what you know of [Video Topic]. Give the transcript to some popular LLMs:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  7. 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

    query above to only return the latest responses that a respondent has completed; this means that if they have completed the same survey twice, this only returns the latest one they completed. SELECT i."Attempt ID" AS "Survey Response", max(i."Survey")...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

    appropriate. 5. Click on 'Save' button at the bottom of the page CAVEAT: If you have multiple contacts in your CRM with the same email address, then you're stuffed. ******************************************************************************* */...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

    next to Sales Order (creates a new sales order) on the quote record, the fields auto-map. The client script below does the same for invoice as the quote lookup is a custom field on the invoice. How? First, we'll setup a client script specifying what...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

    Dates and Times to include timezone of Xero instance for accurate time comparisons - Map Xero tax rates to Zoho tax rates (same names in Zoho) - output to console if debug mode enabled More Information:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

    " + v_Count_Updated + " from " + v_Count_FoundInXero; } return v_OutputMessage; } Caveat(s): Tax rates have to have the same name in both CRM and Xero The code above is for EU / UK clients only (change the TLD as applicable) The code above accounts for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

    folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  13. Making a CD copy with only one drivehttps://www.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

    the copyright notice and click on OK Select the SOURCE AND DESTINATION tab Verify that both COPY FROM and RECORD are the same drives Select the ADVANCED tab Check that COPY SOURCE CD TO HARD DRIVE FIRST is selected Click on COPY and wait for the CHECK...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    table (jos_vm_prodcut_price)... Don't do any of these things! After modifying tax rates and ensuring these were all the same, we also found that this was due to a country not being specified under the Store configuration within VirtueMart.

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
  15. The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

    to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits :c) This is "a day in the life of New York City". {module title="Youtube Embedded Video -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  16. Set default parameter dates to start and end of monthhttps://www.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

    to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  17. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM a_pretend_table WHERE a_condition=true ) AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  18. UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

    I could map the UNC path to a drive letter and then link to it (eg. I:\myFile.doc)but what if other users haven't mapped the same drive letter to the path? Then they won't be able to use the link. Why? As soon as someone suggested I setup WebDAV to do...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  19. Free Translator API using Googlehttps://www.joellipman.com/articles/google/free-translator-api-using-google.html

    has added itself to the fray pretending to offer free services but in the small print, you will find they too charge the same price. How? The Google Translate API still actually exists. Just don't try to exceed your free quota: Visit...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  20. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

    the results above. The second formula is converting person days into hours and then dividing by 24 (which should return the same decimal number).

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 161 - 180 of 183

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.