Assuming going is required, the following 149 results were found.
-
to #__banners -- ----------------------------------------------------------------------------- -- For BANNERS, we're going to do the following: -- 1) Create banner-category assets -- 2) Import banner categories -- 3) Migrate banners from J15 to J30 --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
you want to create the monitoring system. Preferably use the workspace that has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select "Dashboard": Then in the top right of the dashboard, I'm...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
that at the time of this article, API v1 is deprecated (so no authtokens) and API OAuth2.0 is in full swing... we're still going to cheat. How? 1,2,3 steps really. First we're going to set up a Creator form to receive the JSON. Secondly, we'll create...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
tweaking the function and getting it to understand basic mapping and attachments. How? As per our use-case above, we are going to create a button off the contact record which when the user clicks on it will generate a PDF of the merged template and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
default sort order (as in the first time you view the page) is the order in the admin panel (not even by most recent). I'm going to show you how to do this by title in ascending order without installing any 3rd-party extension as well as by any of the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
created one plugin which I can install on any number of Joomla 1.6 sites and it does all this for me... Neat huh? Folder I'm going to shove all these files into a folder which I will then compress and install using the Joomla! CMS Extension Manager. I'm...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
I use to list step by step on how to set up a custom domain for a Zoho Creator customer portal. In this example, we are going to use a subdomain of a company which has the domain joellipman.com. Why? This took me a bit of going backwards and forwards to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a field called "Customer's Time Zone" on the lead record in ZohoCRM. It should be auto-populated... How? As mentioned, we're going to use the address on the Lead record; use Zoho's GeoCode function to convert this into a latitude and longitude, then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Setup a webhook in Xero. [Optional for Method #2] Setup a PHP script on a server that will validate the Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
How? Again, there is a caveat in that the subscription you have or your client has, needs to be Zoho One. Because we're going to use Zoho Creator as a middleware. Just to add to the pain, I'm going to make my function in Zoho CRM: Overview Create a REST...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
we want to get the stock level and then use this data to synchronize with data held in Zoho Inventory... How? So we're going to use a ZohoCRM function to get this file which we can run on demand. Why not in Zoho Inventory or any other Zoho app? Because...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
are already articles out there that document this but I use this more and more and 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
do the below in because I went through rocketheme's instructions once and it didn't work. I then carried out all the changes going up and down the document, double-checking I had done everything their instructions said. For demonstration purposes: I am...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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 mon-sun along the top), "Order"...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
in the "Fill > BackgroundColor" properties row... Done! Borders: I'm putting this here because often enough, if I'm going to make the report pretty with alternating rows, I'm probably going to look at the cell borders as well. I want a bigger border at...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
-1, e.EventFinish) --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION 100) 1. Create a new report: We're going to run the wizard here but without it just add a matrix with [time] in the "column" and [room] in the "row" and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
"Available Values" as suggested by Stack Overflow to gets its value based on the first parameter but ended up with an error going on about "forward dependencies". This is obviously going to error, so continuing on their solution, setting the "Available...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
for SSIS. How? You can search my site for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first attempt based on snippets...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB