Assuming customers is required, the following 27 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 Creator
- 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 Creator
- Language: *
-
+ (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 Analytics
- 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 Creator
- 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
-
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: *
-
- Type: Article
- Category: Static Items
- Language: *
-
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 Deluge
- 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 Books
- 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 Books
- 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 Analytics
- 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 Other
- Language: *
-
and then to push the attachment from ZohoDesk to ZohoAnalytics using the API. The use-case here is that a client wants customers to submit ZohoDesk tickets and upload photos of the problematic product to the ticket. They then want an Analytics report to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
of March 2024 ZOHO.CREATOR.init() .then(function(data) { var config = { appName : "joes_quote_builder", reportName : "All_Customers", id : "123456789012345678" } ZOHO.CREATOR.API.getRecordById(config) .then(function(response) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
like every other business. Page of Copyright © My Company Ltd. All Rights Reserved. Additional Notes to Self: Some customers will want a column for VAT/Tax (Display amount and then percentage beneath in smaller) Line Item Totals have been added to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
"ZohoSign Documents", download the attachment Go back to the contact record, and upload the file to the attachment... Some customers say this is unworkable and takes far too long, especially the part of adding the various field placeholders onto the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
notification template within ZohoBooks. 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
The Brief: We would like the survey data to be generated as a chart and embedded in a PDF brochure we send out to our customers... How? Well fulfilling the brief (whether it's the right tool for the job is a different issue), let us synchronize Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- 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: *