Restore failed / Error Occurred
Hi, I am trying to restore a recent Backup of my main Application (called DEOR) including forms and data to another application with a different name. I get the "Restore in Process" message, but after 10 minutes this is the what I get: Every time creates incomplete copies (no reports) of the original application which I am not even able to delete: Please, I need your help urgently. Thanks, Ceasr
Portal Emails
I have setup the Customer Portal, along with all areas. I have tested and works fine, except for customers email when they do not have a "Gmail account". I can receive the emails if they have a gmail type account, but not from others, like Yahoo, hotmail, or even customer based extensions. I have even tried the notifications area as well. Any ideas?
Execution of form On Load
Form On Load function has.. .... alert("hello"); ... alert("goodbye"); ... When the form loads guess which order the alert messages appear? Thats right goodbye then hello. Errrrr?
Create a Custom Module
Hi, I am working for a client and have a custom requirement. I need to Integrate third party library in ZohoCRM and client prefers it to be in the form of "Extension" which he can install in multiple ZohoCRM instances that he is having. Can you please let me know if this can be achieved? Thanks
HTML page to create record
Hi, I'm very new to Zoho Creator, is it possible, in Creator, to create an html page that users can use to create/edit records? We are finding that the 2 column CRM modules and Creator forms are very restrictive in terms of layout. I have created an HTML page with multiple columns but all I have found is that you can import data into the page from existing records where the input method would be a 2 column form. Our data is working data that is constantly changing and updating, not data that is
Creating picklist in code referencing form in other app
This is weird. I can have a lookup field which references a form in another creator app... but cant have descending order within the lookup field. I looked at the syntax for how the form lookup is declared and figured I'd try and manually build the lookup field contents mylist = othercreatorapp.formname[formfield == input.myfield] ; The above errors with Form 'formname' does not exist in this app! Whereas the form definition has type = picklist values = othercreatorapp.formname[formfield == input.myfield].ID
Is it possible to embed a pivot table report into a record summary?
Hello, I am trying to build a record summary that includes a report I have already created in the record summary along with other information. Is it possible? Thanks
Attachment
When i add attachment as link ( Record Summary as PDF link in Zoho Creator ) in zoho crm it shows as 400 Bad Request How to change that Name? The link that i have used was "https://app.zohocreator.com/parath2/management/report/Management_Report/exportRecSummary?recLinkID=" + input.ID Anyone Solve this
Custom Report looking for differences between records
I'm having a hard time figuring out how to create this report. Let's say I have these forms. Product ID Name Package Template ID Template_Subform Product Package ID Package_Template Package_Subform Product There are other fields in the Subforms, but they're not important. I would like to find out which packages don't match the template. So it's something like: Show me all packages where Package.product not in Package.Package_Template.Product Thanks for any help.
Set Display in a Lookup field to a field in another form which is itself a lookup field
Is it possible to set Display in a Lookup field to a field in another form which is itself a lookup field? Say I am setting the lookup field to connect to the auto index number in another form since it is unique but I want the user to see a combination of a Customer Name + Lot Number since that make more sense for him. How do I do this. Any ideas?
Complex formula in Creator
Hi I have a formula in Excel: =0.3*POWER(EXP(1), (-5*x)) "x" is the only input. Exp(1) is equivalent to the mathematical constant e. Is there a way to render this in Zoho Creator in a formula or in Zoho Reports? thanks.
Matches Function issue:Fetch record task,unable use Matches in criteria
Using Matches function for a crateria to Fetch record do has a bug or not supported for example matchedRecords = formName [Single_Line.matches("abc.{4}d")]; abc.{4}d is regular expression return variable matchedRecords contains all record from in formName. it means regular expresstion do not work。 how let regular expression do work in matches function at fetch record task?
HELP SALES FORM
USE THE ZOHO INVENTORY TEMPLATE BUT BY ADDING SALES I MADE THIS ERROR, BUT ONLY ON SOME ITEMS, HELP!!!!! :(
Intermittent Math Errors
I have a simple app which works perfectly over and over, then, randomly, it makes a math error. I'm talking about simple addition and subtraction. Maybe it is a processing time issue. Perhaps the next entry is happening while the last one is still processing? Regardless, it makes our scorecards unreliable in the eyes of the users. Help would be appreciated... Our techs use the app/form to walk through a checklist. The result is a number of "passed" items and a percent passed score. Basically, at
PDF View first page blank
When I create a PDF view from a HTML view, it is creating a blank first page. Following is a snippet of the view code: htmlpage Rental_Agreement_HTLM(ReservationNo) displayname = "Rental Ageeement" pdf = true content <%{ RentalAgreement = Rental_Agreement [Reservation = input.ReservationNo.toLong()]; PropertyInfo = Propery [Code == RentalAgreement.Property_Code];%> <table width="100%" cellspacing="1" cellpadding="1" border="0"> <caption><b><%=PropertyInfo.Property1.toUpperCase()%> RENTAL
MIME type may not contain reserved characters / Internal Exception
Good Afternoon everyone, When I try to call SOAP request, it responses with the exception messages 'Internal Exception' map validateXML() { xmlString = ""; xmlString = xmlString + "<soapenv:Envelope "; xmlString = xmlString + "xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" "; xmlString = xmlString + "xmlns:ec=\"http://ec.gob.sri.ws.recepcion\">"; xmlString = xmlString + "<soapenv:Header/>"; xmlString = xmlString + "<soapenv:Body>"; xmlString = xmlString + "<ec:validarComprobante>"; xmlString
Auto-populate multiselect lookup field from another multiselect field
Hi, I want to auto-populate a multi-select lookup field with the data from another multi-select lookup field. Form 1 "Item" "Name" (text field) "type" (multi-select lookup) Form 2 Multi-select field "Item Name" (this lets me pull up any of the form 1 entries) Multi-select field "type" --- this is the one I want to auto-populate from whatever was on the form 1 entry. For instance if form 1 entry was: Name: Pencils Type: Office supplies Then when I select "pencils" entry in form 2, I want it to be
URGENT - Zoho ID seems to have a 1 appended to the end of some users
Hi there I have an issue where by a database that is more than 2 years old has suddenly started acting strangely. Specifically, some "Active Users" ID's seemed to have changed. For example, i have one user who's id is zoho_bear in our system, but in the active users section under Manage Users, it now says zoho_bear1 There are a number of users this has affected, but not all of them. Does anyone have any ideas? Thanks Aaron
single select radio button default value
I want to make a single select radio field with no default value selected. Then I want the field to be mandatory. In other words, the user must select one of the several items, otherwise, he will receive a message reminding him he must make a selection
Public forms not loading/working
Hi, We are getting this error message when accessing our forms that are set to public. Some accounts are able to view it while some are getting the error below. We are also getting the same problem w/ public pages w/ embeded public forms. We already emailed support@zohocreator.com regarding the issue and we haven't received reply for the past 2 weeks. Here's the email reference no.: 18938532
zoho creator plans
I have been a zoho user for more than 5 years. We have more than 20 premium users. We pay the license annually in advance. We love Zoho. But recent changes to subscription plans are not good. The jumps are very big, we do not have ways to add addons and they limit us in many ways. Please ask them as a user to reveal it, those plans are not good. It does not allow small companies to grow. We are limited in records, web components, etc.
Using Zoho Survey for quiz
Hi Have anyone ever use Zoho Survey for Online Quiz Campaign (Desktop & Mobile)? I'm looking for good online engine that can create Online Quiz and review the result in Campaign session, gather user info such as facebook email & contact number, sort user base on date and time by Campaign session (Per Campaign). If anyone ever use Zoho Survey for Online Quiz, would you mind to share some experience with us? Thanks Jack
Published view/report from Zoho Creator to be exported by any user with the link?
I have published a view/report from within Zoho Creator with a PermaLink with a long random string in it. I have enabled this Report to be exported by users. But if a user opens the link without logging in, the view can't be exported. Is this by design? This is not very convenient.
Scheduling recurring appointments in Zoho creator
Hello. We are builind an app for a corporate course providing company. The courses are or recurring nature, for example: Start date 10 nov 2017 time: 10:00-11:30 repeat: Every Friday and Wednesday this means every Wednesday and Friday, this course takes place between 10:00 and 11:30 Until: date is reached (date x) OR a number of (lets say 20) occasions have occured additional fields: location, customer, instructor Then we need to view these events in a calendar and ? or report view, and be able
Background App Refresh on iphones or ipads??
I'm not seeing an option for "Background App Refresh" offered on our mobile devices. This translates into having to come back to a report or record you were working off of as if you are opening zoho for the first time - from the top level of zoho, then click the application, then locate the report, then the record, etc. They take calls, read texts, emails, etc in between zoho updates as well. Coming back to where you left off, background app refresh, seems like basic functionality. Is there a setting
API throws error when passing (&) ampersand and (%) percent via XML
I have the same problem as described in the title and in this related discussion. The above referenced discussion seems to have been moved offline. I was wondering what the resolution was? In short, I am trying to pass (via XML) to the API a URL containing query parameters using the ampersand. The API then throws a 2830 error. Same problem happens when I encode the “&” using “&” — as the percent symbol seems to trigger the identical error. Can somebody please help? Note: I have unsuccessfully tried
"," separator in numbers
I found that in all Zoho Applications the "," thousands separator is causing the number not being recognized as a number. Can this be rectified? this is very annoying.
Multi-language
How to develop a multi-language database with Zoho? The aim is to select a language at the opening of the database and only one.
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
URL field - Link Name
I have multiple records with an entry for field type URL for which the Link Name needs to be updated. I switched to Show as Spreadsheet, so that I can quickly change each entry without having to edit each one individually. Using google chrome. Right click on field, option comes up to replace the value, enter text to replace the existing string ... but it fails to update: Just do double check I go back to Show as List, and the link name remains as it was before: How can I update multiple Link Names
Bulk Edit - wildcard to find/remove blank space
I need to remove an unwanted space in a field for multiple records. Example: TX- 12345678 => TX-12345678 A search using * for wildcard (select field, enter "*- *" shows several hundred records as desired. But then when I want to do a bulk edit to remove the blank space, the field does not show up in the dropdown for bulk edit. How can I remove an unwanted space in a specific field for multiple records at once?
Integration
which voice calling Third party applications will Integrate with Zoho Creator ? and Further Integrate with Zoho CRM Satish Kaushik Zoho Certified Developer, Net Greater Technologies,LLP Mobile: +91 956 071 6262 Email: netgreater@gmail.com Website:www.netgreater.com Skype: netgreater
Help! One to many relationship - idexing
I am new to Zoho Creator, but hope to create some simple but usefull applications. Currently I have a problem that I cant find a solution too, I hope someone can help me. I am creating an applications which makes to possible to register several "targets" in form#1 which has a one to many relationship to values ("tasks") in form#2, which again har a one to many relationship to values ("subtasks") in form#3. TARGETS=>TASKS=>SUBTASKS I am able to create this with lookup fields and subforms, but how
Invitación a AppCreator
Estimados, llevo mucho tiempo esperando la invitación para utilizar AppCreator; cada vez que entro recibo el mismo mensaje: "AppCreator - Your invite is on its way! You have requested an invite to sign up for Zoho AppCreator. Thank you for your interest. While we are excited to have you on board, there are a couple of things we need to do to make your experience comfortable with us. We shall send you an invite as soon as we are ready." Podrían indicarme por favor en qué estado se encuentra mi solicitud?
Feature Request - Total application count
Hi there, In the usage details section of the dashboard it would be very helpful to have a total application count to tell you exactly how many applications you have. We have hundreds so actually counting them up is extremely difficult. I'm sure this feature would be beneficial for most users Thanks
Is There a Way to Turn Off Picklist Filtering
Hi, I have a lookup field "lessons" that I want to be filtered by a lookup field above it called "modules". Here's the thing: I also want the option to choose a lesson regardless of module. Is there a way to create an option to switch the filtering "off" from the form? Thanks,
Importing two linked tables
I have not found any information on importing two linked tables. Say I build table Suppliers and table Products. Now each of these is a table in Excel. I have a unique Supplier_ID column in the table Suppliers. In the Products table I use this ID to reference the supplier. Creator has a built-in ID field for each from. Since it is an auto-number field, I plan to use that to link tables in the Creator. Is there a way to import Excel tables into the Creator so that data from both tables are properly
Next Page