Assuming want is required, the following 282 results were found.
-
paste it into there. When you ok this you should be on the following screen: Select the Report Type: For this calendar we want matrix because we're going to group based on the rows: Design the Matrix: Ok so we want weekday in the columns (to have...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at me. What I want: ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday TotalTimeWeek ----------- ----------- ---------- --------...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and want the HTML to be indented neatly. Other examples out...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds //...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
parameters should simply load the app without resizing it to the maximum width/height of the screen. Windows 10 Mail Lastly: Want to start a built-in app in Windows 10 (not found in your program files etc) like Windows Mail? Open a run command and type:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: Originally dubbed EventViewer Chart Generator. As...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Visit the website http://revolvermaps.com/?target=setup Configure the map to the settings you want. Copy the ID reference as per the "Important Note" below. Login to your Joomla website admin panel Install this module as per usual (will auto-install) Go...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the top right: Under Portal URL, select "Custom Domain" and in the field below, enter the full domain (incl. subdomain) you want to use: Then click on "Save". If you have access to the DNS manager for the subdomain/domain of your customer portal, or you...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
have a button that loops through all the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this article because I keep...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
because my detail view on the report was displaying a report/document template. How? The quick answer is: Add the fields you want to the detail view of the report you are accessing. The detailed resolution is: Create a duplicate of the report with the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
created and click on the ellipsis/three dots icon Select REST API and enable the API Key, this will return a URL that you want to copy to clipboard or notepad for later use. Set Notification Preferences Finally, here's the function that subscribed my...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The scenario is that my client has quite a long Creator form and instead of scrolling down while entering data, they...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Zoho Inventory. Why? We're enhancing the out-of-the-box integration from eBay to Zoho Inventory bespoke for a customer. We want the photo on eBay to be downloaded and uploaded to the Zoho Inventory record for the respective record. As Zoho Books and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Date") GROUP BY invsopoitm."Invoice ID" Additional Here are some other queries that are required for the above but you may want to use the out-of-the-box modules instead: Sometimes, a salesperson or user might be generating an invoice on behalf of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
documenting how to remove the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead record to an opportunity (or Deal) record. If you are using custom fields, then just...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
would rather just find it on my site than going through multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be rendered for PDF or print format. I have another article for a different client who wants a pretty...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
admin) Go to Settings (cog icon in the top right) Click on "Performance" Click on "Extend Service" Click on the form you want the data from, in our case "Objectives" (renamed from "Goals") Note the label name in the top right: In our case, the form link...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
spend without it. This is not an upgrade; it is likely that your client may reconsider the template they are using or may want to add new 3rd-party components. If asked: "how long will it take", do not say 5 minutes. This script runs on average in 15...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *