Assuming there is required, the following 217 results were found.
-
Why? The use-case is simply that my client wants to make it easier for their customers to accept or decline a quote. Sure there's a portal and you can probably do it from there but this is a one-click accept or decline then done. One of the biggest...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
There's documentation out there but as this took me a couple of days to simply install a JS widget hosted by Zoho and pass the record ID via a button to it, I'm adding it here in case I need to refer to it in future. Why? We have an Accounts module...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
needs updating... I'm writing this in case I ever have to upgrade other people's Joomla CMS and if it helps anyone else out there. How? There aren't too many steps but this is what I went through and I might amend this if I see any new issues: Preamble...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
"DC_This_Date" (3833)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. All this blab actually means is that there...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Put in a value for "NoRowsMessage". This solution hides the entire Tablix which kinda defeats the purpose of having anything there. I want my end-users to have faith in my report. The report just returning blank can also mean "I don't know". I want the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
(request reference) number. The Report We start off with our detailed report page which lists all the details of a student. There is a textbox linked to an action which will open another report (the confirmation page) and pass through 2 parameters (the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu (when you...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
used on the website. The website was working fine and I was able resume my click-happy habits. It's a given that in my test, there was only 1 user (me). There are reports though that some people set up websites with NO 3rd-party items whatsoever... For...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
report, export to a Crystal Report, which in turn we export to Excel: Note that as this is from within a web application, there are no extra options or dialogs to select. The export had to work from this point on. I can't take any credit for the below...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
1) In column G put the formula: =MID(B1, FIND(F1, B1)+1, FIND("°", B1, FIND(F1,B1)) - FIND(F1,B1) - 1) // if there is a space between the two =MID(B1, FIND(F1, B1)+2, FIND("°", B1, FIND(F1,B1)) - FIND(F1,B1) - 2) In column H put the formula:...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
so there are more fun things to do out there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
1 monitor), then MS Windows will almost remember which apps were open on which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app on their second monitor. So...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
is the third time I wrote this program, simply because I reghost all my computers (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media files (all legitimately :) and...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
crash, database performance was at an all time low and analysis revealed it be incorrectly designed. Interestingly enough there is a Bug Tracker for Remository that they use (not Joomla! integrated though?). Joes Bug Tracker (JBT) is a Joomla! CMS...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first note is that there is something that can emulate a random number... well it's not...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= v_Name.toLowerCase()];... Returns the error: "Expression is not allowed in left side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
!important;} .fa.fa-close::before,.fa.fa-close::after{background:#999 !important;} 2. Trigger the notification There are several ways to display this as a popup, the first use example is on report workflow (click of a button in a report row) but I've...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the Stage in Creator (so a user can change the stage in CRM and it would reflect this in the equivalent Creator record). There was also a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *