Assuming customers is required, the following 26 results were found.
-
or the system calendar that the appointment is at 10am. How? So adding a datetime field and calling this one the "Customers Appointment Time" is the wrong first step. Reason being is that datetime fields hold the time zone they are set in (ZohoCreator >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
with a pre-built description, tags and inventory details. This means the app needs to be able to sync all of its products, customers, and orders with Shopify as a 2-way integration as the Zoho app needs information from additional apps installed on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
while recovering from the backup I’d made silently. I guess it’s part of the “underpromise/overdeliver” thing… but several customers were intensely relieved when I was able to “work my magic” and save their business/thesis/whatever.″ Rates: Charge...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
you may want to avoid reading the rest of this article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in person and could only see the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
new lines (the "CHAR(10)" as with other cell data). Quite a lot of spacing (the height of one text line), but our customers were complaining it became too convoluted and cramped when refreshing data and preferred the end result with this change. Note on...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
+ (MAX(if_null(t2."Credit Margin incl Tax", 0)) / MAX(t3."InvCount")) AS "Profit incl Tax" FROM "Invoices" i LEFT JOIN "Customers" c ON c."Customer ID" = i."Customer ID" LEFT JOIN "Account Managers" absp ON absp."Customer ID" = c."Customer ID" LEFT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of all Customers Remove the list of unique ones from the "all" list to be left with just the duplicates. The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html
connection with any product or service that is not JoelLipman.com's, in any manner that is likely to cause confusion among customers, or in any manner that disparages or discredits JoelLipman.com. All other trademarks not owned by JoelLipman.com or its...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
that your store will run using two domains your master domain name and shared secure domain which may be used by other customers of your hosting company. Dedicated SSL means that you will have your own SSL certificate which enable you to run your store...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
possible) and then have IE6 and IE7 as separate browsers. If I was at home I'd just use Virtual PC with Windows7 but my customers are on XP and I have to emulate their environment as accurately as I can which I can do by setting up my work computer to...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
been made to avoid the use of functions, stored procedures, temporary tables, etc. This allows broader compatibility and customers who do not have DBAs to run this themselves. Personally I grant the user who will be executing the script full privileges...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
I like to include a "Did-you-mean" section which I also use for any AJAX suggestion feature (be flexible with us as some customers have asked how does it get that word and why is it relevant? (when it isn't, the sound matches and then it's a typo on the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
Thursday Friday Friday */ This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer literate so the SQL query had to do the bulk of the work. The SQL query we send to the database has to...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
going to have to go back to the beginning and try that again."... This isn't a solution that sounded good enough for our customers. The Workaround we actually went with Our Stored Procedure would check if the unique identifying number (in our case...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
facing version of your site QA - for clients who need to test enhancements that you've developed. (referred to with the customers as TEST). BACKUP - an exact copy of LIVE (preferably from a daily refresh - and inaccessible to non-administrator users)...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form to allow customers to make a booking based on the configuration and appointments in a ZohoBookings instance. How? The getAvailableSlots...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
> Preferences > Packing Slip Settings > and Enable "Delivery To": Then change the Shipping Address Format either under "Customers and Vendors" (although this applies to all templates) or under the specific template. I wanted to do this for just the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
had added 3 custom fields: Payment Method, Payment Date, and Last Four Digits. They needed these because sometimes their customers needed to know what card they had paid with (if paid by card). The customer wanted payment method and payment date to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to improve email deliverability from a ZohoApp and methods to check. Why? Not sure how I came across it as most of our customers don't use ZohoMail, but there is a Zoho Toolkit to run some checks on the email deliverability for a customer:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF