Assuming could is required, the following 149 results were found.
-
is that my client has quite a long Creator form and instead of scrolling down while entering data, they would prefer if they could have tabs along the top to display each section. How? The way we do this is by applying our own stylesheet and overriding...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
using ZohoCRM here despite storing the record in ZohoCreator as the app and data processing is mostly done in ZohoCreator. I could have setup webhooks to go directly to Zoho Creator but I don't find Zoho Creator reliable when receiving and responding to...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
below is just for a standard template with a modern design. How? Ok, admittedly, when first designing the template, there could have been a fair few improvements right out of the gate. Then the client comes back and says things like "can we add this?",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
info r_Delete; } } } Caveat(s) I've set it to only remind on business days excluding Saturdays and Sundays but you could modify the above to simply AddDay(n) instead of AddBusinessDay(n) if your guys operate over the weekends. The task will be on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
around security. It is difficult to guess a customer's Zoho ID; some might say almost impossible. To use other fields that could be sent via the URL as a verification to be checked at the webhook endpoint would be good as well; but I couldn't spend time...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
database names used in the below script to the ones you use!!! -- SKIP MIGRATION: -- -- Each section was written so that it could be migrated separate to the rest. -- -- It is recommended to skip the menu migration and to do this manually. -- -- This...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
by most recently added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line with other search systems. So here we go, hope this helps you....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Export Joomla Users scripthttps://joellipman.com/articles/cms/joomla/export-joomla-users-script.html
Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the new phone (not fun). The Apple documentation iOS: Transferring information from your current...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
the top left to remind you what you're getting yourself into) Go to Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
column "This_Date" (3833) to column "This_Date" (3932). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
the field @GivenDate off into an SSRS parameter (note do not declare it in the SQL code if using as a parameter). You could in the SQL above change the start time (note the end time if you want the end of the day should be "23:30:00" if you have 30...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
column may vary from 1 and 10+. Not sure on why this is but it doesn't seem to affect the functionality of the above and you could always hardcode a 1.00 if its confusing. In theory, if you know the shift patterns of an employee, you could enhance the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
was a Friday. The 1st of January 2011 was a Saturday. The developer felt that as long as you adjust the script each year you could make the system last another year. Shame he also forgot the academic year ends halfway in a normal people's calendar, so...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
been abandoned by its developer. I've started writing this article because I find myself forgetting to ask something that could have saved an infinite number of man-hours (I exaggerate a little); but seriously, I needed a checklist that works for me....
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
values using single tags so we had to find a place to introduce it. On strings this has little worth, but on dates which could be NULL, this was necessary (unless we interpreted dates as strings which we don't want to do): -- SITS Output: Option 1 --...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *