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

  1. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

    Microsoft's SQL Server Reporting Services as a replacement for website applications. We only did it because we have more staff trained in SSRS than in bespoke third-party software and the ability to support/develop outweighed the cons.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

    boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  3. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

    authorised personnel could refresh the data on the Excel spreadsheet and they would then save as PDF and send to appropriate staff. Other Issues I usually felt that CHAR(13) goes hand in hand with CHAR(10) and although it displayed and printed properly,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

    interface as per an agreed template. Back-end administration interface for managing the website (GUI based for non-technical staff. Web-based for remote working.) JoelLipman.Com will create 2 development sites ("play" sites) which the project manager...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  5. Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

    social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so actual editing of the feed would be done on the respective...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  6. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

    then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked the requested dates as leave. [Warning: red herring ahead] For this process, we setup connections...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    about half-way, the rest we guessed on our own: Our use case, is that we are developing a Zoho Creator app that will help staff log time and then push the creator record to Zoho Projects. How? For the following example, you will need to have setup a...

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

    then to click a button which copies it to the remaining working days. How? So I have a form with 6 subforms which list staff/employee shifts from Monday to Saturday. The form I have looks something like the following: and displays as something like...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

    10 minutes before m_ScheduleCall.put("Reminder","10 mins"); // not sure if this does anything. hopefully notifies the staff user m_ScheduleCall.put("send_notification",true); r_ScheduleCall = zoho.crm.createRecord("Calls", m_ScheduleCall); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

    This is too many steps for some. Instead, we've been asked to create a button that sits on the view page of a record and the staff simply click on and it does all the aforementioned. How? The difficult part here was to figure out how to convert the CRM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Deluge: Generate a loop or list of any sizehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-a-list-of-any-size.html

    for any numbers of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member for the upcoming week. How? As mentioned, using leftpad takes 2 parameters, the first is the string to start with,...

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

    in ZohoBooks off the invoice module to initiate your Stripe terminal to take a payment. Why? Just to make it easy on the staff at a counter or on the phone. They bring up the invoie in ZohoBooks, click on the button, and the Stripe terminal will ask for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

    pipeline on deal creation within CRM based on the department specified on a user's profile. Why? A client asked that when staff create a deal/opportunity record in CRM, the pipeline is automatically pre-selected based on the user. How? So there's a bit...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    = ""; // // the generic signature for all users with merge fields enclosed with square tags: v_RecodedSignature = " [AB-StaffName] [AB-JobTitle] [AB-MobilePhone] [AB-Email] www.joellipman.com " + v_Icon_TwitterHTML + " " + v_Icon_LinkedInHTML + " " +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

    to upload to a Zoho Desk support ticket as an attachment. The ticket will appear in a Quality Control report in Zoho Creator Staff can access the report via Zoho Creator and export it to PDF. They can then send the PDF to the supplier. Technical...

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

    I use before this to generate the invoice, also updates an invoice, I wanted to keep the action of sending separate so that staff can control that without the worry of updating an invoice and re-sending it.

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

    != null) { v_Email = c_Quote.Email; } v_QuoteDate = c_Quote.Modified_Time.toString("dd-MMM-yyyy"); c_AddedBy = Staff[Zoho_Creator_User == zoho.loginuser]; if(c_AddedBy.count() > 0) { v_AddedBy = c_AddedBy.Name; } break; } } %> /* page sizing */ @page {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    has been added which is a lookup to the Sales Order module. This means that on a purchase order, and per line item, the staff can specify which Sales Order the item relates to. How? At time of print, adding the lookup to the line item will automatically...

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

    email (at least in a web-based email client such as outlook or Gmail), they should get something like the following: Your staff will, of course, see the estimate status as accepted or declined in ZohoBooks.

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

    duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication feature for leads and contacts but not for products. How? There may be a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 21 - 40 of 46

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.