SQL Alias error?
I keep getting this error: Whenever a table alias is defined, kindly use table alias name before the respective columns used in SELECT query I don't know where I've went wrong. SELECT Distinct "Book Title", t1."Author" as 'Authors1', t2."Author" as 'Authors2', FROM "SET1" t1 LEFT JOIN "SET2" t2 ON t1."Book Title" = t2."Book Title" WHERE Authors1 LIKE '%John%' OR Authors2 LIKE '%John%'
View bounce details in CRM
After we send a campagin in zoho campaigns, we need to be able to see in Zoho CRM which contacts have hard bounced vs which contacts have soft bounced. How can we make the bounce type available in CRM?
Add Record to creator report from JS widget
I have created an HTML page to get the location. I need to get this location and insert it to report name called "Location" in Zoho creator. this is the error that I'm facing, POST https://creatorapp.zoho.com/widgetapi/companyname/developer/form/Locations
Zoho Campaigns Connect to Bigin account to sync contacts.
Dear Sir I have a Bigin Express Account but when I open Campaigns and click on Associate Accounts I am unable to sync Bigin Contacts into Campaign Contacts. Please assist
I have trouble with Add mobile phone
When I sign up for an account and add a mobile phone. It's always alerting "This mobile number has been marked spam. Please contact support." But I sure my phone is the first time register in here. This is my phone number "+84366182228" and +84563143333
Creating Client Company user duplicates companies in Books
I have only just realised why I'm seeing two entries for some of my customers in Books - when I add them as a Client Company in Project, it seems to create a new customer account in Books. This is obviously a problem when the Customer already exists in
Task Billing Types in Project Android app
There appear to be two problems when setting Billing Types in the Android app: The field names are "technical" and need tidying up (see Screenshot_20210616-162223_Zoho Projects.jpg). You'll notice this applies to several other fields too. The billing
Update Module giving error
Hi Community, Im using zapier to upgrrade module entry but I'm keep getting an error "Unable to create entry in module: Events. Error : Invalid data for the field participant. Detail : expected_data_type long, index 0, parent_api_name Participants"
I have changed my MX records but still I am not able to receive mail?
Domain: www.montemt.com.br The DNS server is publishing the same MX zones registered in the DirectAdmin panel: https://mxtoolbox.com/SuperTool.aspx?action=mx%3amontecmt.com.br&run=toolpage
eM Client having bad gateway for CardDAV Sync
Hi all, I keep getting this error on the CardDAV sync from my eMclient. Here is the setup page: Anyone to help me here?
My Zoho mail is blocked from sending
I got a message that my account is locked "Account Block Information Your account could not be unblocked. There was an error when unblocking your account." I tried unblocking but no success can you help me with this problem!!!
punctuation after a backtick behaves wrong
When I mark something with a backtick, and if I continue with punctuation, it doesn't become a code.
Zoho one, unable to change ownership of app(s)
Hi guys, I currently have this problem, I am unable to change ownership of apps in my zoho one. the error says that "sorry, this operation is not supported." can anyone help me with this ? thank you screenshot attached.
Most of the data deleted from Form but still the account space occupied is high
We made a form and there were almost 8000 +entries and even after we deleted around 7500 data the space occupied did not changed. Any clue?
Zoho Signin Page to Forums Takes Several Minutes in Redirection
I have been observing this behavior recently for the past few weeks.
I can't connect to the plug-in Zoho CRM for Outlook
The plug-in installed, i try to connect with my login Zoho CRM but the pop-up "Please specify a valid Email and password" while the Email and the password are valid. Can you help me pls.
ZOHO MAIL CONFIGURATION
We could not configure Email and SPF & MX records are not verified. Their account is in Cpanel. Though we placed all the records in DNS. it's still not verified.
Making more than 1 change in Subscription creates a problem
We have monthly subscriptions that are updated more than once a month. Once we make a change for the incoming month and try to make a second change we run the risk of losing the original changes if we don't first make a note of the new changes so we can
Extremely Slow Email Delivery
My outbound emails are taking a long time to send. Especially those with attachements. Any suggestions or internal issues?
Zoho Social Reports: Cards keeps re-arranging automatically
The feature in Zoho Social where I can create my own dashboard under the reports tab keeps re-arranging the cards automatically. I have been using Zoho Social for almost two months now and I was able to curate a number of reports with the cards being
The contact form in my website has stopped working!
Address not found
I am facing an issue that whenever I am sent an email, the sender is getting the attached message. Please can you help urgently as this is a major issue. Many thanks, Jake
Remove "Tax Inclusive" wordings
Hi, I would like to remove the wordings of "Tax Inclusive" from my Zoho Invoice. I have also selected "Excluding Taxes" under preferences but it still appears. Could you please advice. Thanks.
Zoho Books (Timesheet) : «The time spent for the day adds up to more than 24 hours. Please check and retry.»
I'm having trouble almost each time I try to star timer or log time, system says : « The time spent for the day adds up to more than 24 hours. Please check and retry.». I didn't even loggued time for this project since several days. What's th problem?
Walkthrough Breaks
Zoho Creator Walkthrough seems to be closing after step 2
Invoice Draft Number Problem
Good morning, i have a zoho invoice standard subscription, and i have a huge problem with invoices, if i create a draft of invoice the number of invoice is reserved for this draft.. but i need that the number is assigned when the status of invoice changes from draft to active.. is possible? An other solution in my case is to create an estimates from the projects time entries (not an invoice draft).. Is There any solution? Your sincerely, Marco
Unable to send Messages in my zoho mail account .
Please Help me i Cant send Messages in my zoho mail account . Any time i try to send Messages In my zoho mail account.It will throw this error . "Unable to Send Message Email Outgoing Blocked ,Please Wat should I do."
Solved: Zoho Databridge JDBC driver problem with European time zones and MySQL
If you are running in problems with following configuration: - Zoho Analytics and Zoho Databridge - MySQL on Windows server - default timeZone configuration just run following commands in mysql: SET GLOBAL time_zone = '+1:00'; or SET GLOBAL time_zone
[iOS] [ASAP] Problem archiving the project.
Hi Zoho team, I hope you are doing well. Currently we are implementing the live chat from ASAP module on ZohoDeskPortalService library, we have already implemented the live chat, in debug mode works well, but now we are trying to archiving this implementation
Can't receive any incoming mail
Hello folks, I've recently setup my account (contact@recordatio.nl) with Zoho Mail. I've pointed my MX records correctly and the domain has been verified. I can send outgoing e-mails, but can not receive any incoming mail. Tried with a bunch of different e-mails/clients and even mails from Twitter don't show up, absolutely nothing. Any issues with the mailservice going on? Kind Regards, JM
Sites looses connection with instagram
Hello, Zoho Sites regularly looses it's connection with Instagram. It is fixed by refreshing the account in Zoho Sites. It is not feasible to manually check the connection throughout the day and the refresh. This is a problem. Hopefully, Zoho can get
how to connect a zoho campaigns worflow with a blueprint of crm zoho
Muy buenos días a todos, me comunico con ustedes porque llevo un tiempo con el problema, he creado un flujo de trabajo en campañas de zoho que su final de programa es cambiar el campo de título por interesado y, el blueprint que tengo se inicializa cuando
Turning on the option to tax shipping appears to remove the tax applied to taxable items
It appears that turning on the switch to tax the shipping amount causes only the shipping amount to be taxed instead of taxing both the shipping amount in addition to the taxable items.
Code less bot builder issue: cannot disconnect single edge in the middle when multiple buttons go to same block
In the code less bot builder, if there are multiple buttons all going to the same block, it is not possible to disconnect a single edge in the middle because clicking on the Scissor icon only removes the lowest edge. This is because all the connecting
Can send email but not receive them in Zoho email
I am currently using Zoho email to send and receive email. Managed to send email to other email address but cannot receive any from them?
unable to send message reason 553 relaying disallowed
My Domain Lamontana.pk Expired after newal. email not sent Error is "unable to send message reason 553 relaying disallowed"
[zoho creator v2 api] File upload error
I would like to use the V2 API to upload files, but the following test code gives me an error. //////////////////////////// code:3660 message:No file found in the request. Please include a file and try again. //////////////////////////// Please let me
Help Center users can't be removed from groups
Hello, Zoho One user here. I have the following persistent problem: when an end-user (Help Center User) is added to a group, it can never be removed from it. When editing the user and hovering over the group name, it shows the red X, and when you click
Meu domínio está sendo usado por outra pessoa
Registrei um domínio .com.br no Registro .br Ao iniciar a configuração do meu e-mail, recebo a seguinte mensagem: Este domínio já está associado a esta conta "m*****o@d*****".
Zoho Desk unavailable
Hello, I cannot enter in my Zoho Desk workspace, after loading for a while, the following message appears, translating for English: "Sorry for the trouble. Please try again after a while or report your problem in the feedback form below". I wanted to
Next Page