Remove country code
Hi there, I am based out of Australia. I have a phone number field that is defaulting to Australian country code +61. Since all the phone numbers in my zoho records are in Australia I would like to remove the country code from the field? Can you please
Field Navigation Order
Field Navigation Question. Is there a way to change to the field navigation order within Creator. I have a two column form and fields seem to tab or flow based on when I created the field instead of the natural flow order of the input fields, can I change this order to make it a more intuitive input flow for the users?
Where do I find the Hex color code for the default chart themes?
Hi As it's not possible to change the colors in the charts, I want to add identical colouring to the numbers (on Panels) below, but I can't find the Hex values anywhere. Can someone point me in the right direction please? Karen
zip.extract() throws error 'Error at null' for uploaded file.
here is my code - zip = input.image_file; file_collection = zip.extract(); error: Error at null
Mail merge template on Quote module
Hi! Is there a chance to Zoho offers mail merge templates for Quotes Module in te near future? There isn't on native product.... only on custom module? Will I have to create a "custom quote module" to acess mail merge template? Tks Paulo
Customer Portal URL
I added the domain in the Customer Portal URL area. But when accessed by the new domain, the application does not appear.
Can you put a Currency field's symbol on the left of the field?
My currency fields show the correct symbol (£) but they put it on the right of the field (see screenshot). That's not how we use the currency symbol in this country. Can you change the currency symbol to appear on the left? Many thanks Steve
Export image fields as public accessible link
Hi there! I have a database with product master data and 3 image fields. I need to export/analyze the database through ZOHO Analytics and retrieve a public accessible URL of the product images. Example: Product name: iPhone 8 Plus 64GB Product image 01: https://www. ..... Product image 02: https://www. ..... Product image 03: https://www. ..... Do you guys have an idea how to achieve this? My workaround is to upload the pictures to ZOHO docs and paste the public to a text field, but that is
Page editor frozen
Hello community, I hope you are very well. I´m having a problem a problem with my apps. I have a form with a few records, and I am trying to make a page with some indicators, so I went to the page editor, i took the "New Employees this month" Panel from
Print calendar?
Is it possible to print the calendar in Creator? It only lets me print a list or summary
Hide or archive records?
I have lots of date-driven records, so I’d like to hide or archive records at the end of each month. How would I do that? I don’t want to delete them.
Fetch Leads from crunchbase.com
Hello! Say for example I would like to integrate third party websites like crunchbase.com with Zoho, is there any way that I can do this, perhaps via API or customising via Deluge Scripting? Cheers Zhili
Zoho Creator Published Form on Wordpress Page
Hello folks, I tried to embedd a published form from Zoho creator over iframe and with the permalink into my wordpress page but the form isn´t displayed. The frame is loading and says: creatorapp.zohopublic.com has refused the connection. Tried also over
Compound Primary Key
I need to create a table of team members and I need to ensure that no team member is entered twice. How can I make the combination of first name and last name unique. Thanks!
Error Occurred. We are sorry for the inconvenience...
I just opened an account and started a sample app and upon doing so, have continually received the following message. Error Occurred. We are sorry for the inconvenience. Please try after some time or refresh the page and try again. I have refreshed and even deleted the app and recreated from scratch but continue to get the same error. I would like to evaluate this application for a non-profit and it appears we might be able to make it work but first impression has not been good. Hopefully there
Print records
There must be a way of printing a batch of records and specifying which fields to display for each record? I have in mind printing to PDF, where each record occupies a separate page. Is this possible?
Address Autocomplete Using Google Api
Hi, I have long been looking for a solution to replicate something similar to Salesforce's Address Autocomplete feature using Google Api. See below image, when you use Search Address, there is a pop up that then uses Google Maps Api to Auto Complete the address, after selecting it, it populates the fields "Street", "City" etc. This is now a default feature of Salesforce and I could only find a custom version of this also for Salesforce https://github.com/benedwards44/sf-address-autocomplete Would
"Unexpected error"
Hi One of our customers are reporting that when she filters in reports she gets a prompt saying "Error Occurred. We are sorry for the inconvenience" randomly. I was asked to get some more info from the customer and it looks like it doesnt look like what
Lookup field data in Deluge
I have a workflow email with various field data ... when the field is a lookup from another form the email displays a code number eg 40540007788. How do I get it to display the actual field data from the lookup field rather than this number?
Field Link Summary Page for Creator
Just an idea to have a page similar to the CRM's API reference page for Creator Forms. Large Forms require us to build the reference table ourselves for third party integrations. The script editor's suggestions in Creator are helpful, but there is no
UPS Tracking API Certificate Change
Hello, I received the following email from UPS about a change to their API certificate. We use invokeUrl in Zoho Creator to track UPS shipments through the UPS API. My question: Is this something I need to worry about, or is it handled between Zoho
Custom Domain?
I just don't find it anywhere.... followed the instructions as on this page: https://www.zoho.com/creator/help/general/zoho-creator-for-your-domain.html There is no way for me to add/edit my custom domain. Please can you clarify as I am testing the system and upgraded to paid version and still no luck.
Passing Parameters to a View via URL
I need to pass a variable from a "passive screen" to a View screen. The data is to be used in the evnt that a user wants to "ADD" a record via the view screen The value that needs to be passed is not a constant (like 1234) - the value will not be known so the openurl can not have a constant passed through. How do I use the openurl command with a variable to be passed - not a constant. http://creator.zoho.com/zchelp/employee-manager/#Form:Employee?Employee_ID=<variable name> Here is the instruction
How to view Record ID in front end of a report?
Hi, I would like to see the Record ID of a record in the frond end of the application (May be in the detail view of the Report). Where and how can I see this information? (I know how to fetch it in the back end)
Export Creator Share Details?
Looking for a way to export "Shared Details" for my Creator application. I've ~180 reports and views for which I need to see who currently has access. Manually opening each and copy/pasting who's has access is proving very time consuming.
Adding a report using information from 2 forms and a subform
New to Zoho Creator 5. I am trying to create a report using the data from a form and a subform. Is that possible in Zoho Creator and if so, does anyone have any tips on how it can be done? Thanks in advance,
Email all fields, not just edited fields
Hi, I'm using Deluge script to send a confirmation email to customers when the fields in a form are created or updated. When the fields are updated the email only sends the updated field, not the whole form. Which doesn't work for me as the customer wouldn't
Rendering image and XSS configuration
Dears, I've a view that from 2010 until 2014 was rendering correctly a upload field to show images. Fromo 2014, in the view only is displayed the html code: <img width='64' height='75' title='Foto' alt='Foto' src='http://creator.zoho.com/DownloadFile.do?filepath=/1431032894626_foto.tif&sharedBy=misca'/> I read that maybe run with XSS configuration in Security App options. But with new Creator version is it not possibile. Any solution? (I can't at the moment use the Image field). Thanks a lot Mike
new fields not showing up
don't know if this is a bug or a missed setting. I created a database with various fields. I realized that a few more fields would be needed, so edited the application. The added fields are there - sadly, they do not appear on the 'shown' database with data. any fix, or do I need to recreate from scratch? btodd
Help me write a script to email all my entries in ZOHO CREATOR
HI, I think it's a simple thing to do.. but can someone show me how to email all my entries. What email does it come from? Will I have to have an email from Zoho or can I type in my own from who they see who it's sent from? Please help. I am a detail person so please write out as many steps as possible even from starting on the homepage. Thanks!
Complete a number of forms offline and then upload them afterwards
Does anyone know of a way to complete records offline and then add them to your creator database afterwards? Could it be done through an external application? Any help/suggestions with this would be greatly appreciated. Thanks, Eamonn
Sort sub-form fields in report
Hi, I have a form which contains a sub-form as well as lots of other fields. One of the fields of the sub-form is a date field. I want to be able to create a list report from this form which puts each entry in date order. I can see how to sort the data
have date field default to current date
How do I program a date field to default to the current date? hughes
Automatic Approval
Hello, Is it possible to create automatic approval workflow in Zoho Creator? for example if submitted form is not approved, after several days, I want it to be approved or rejected automatically by the system.
Basic Loops
I'm using a Count database with several records to trick Creator to make an iteration process that allows me to replicate what a FOR NEXT or REPEAT or WHILE process would allow me to do. Is there any plan to have a LOOP of some sort in future releases. This would be so helpful. Additionally: It would be great to allow the INSERTING or APPENDING of records as this would allow for the creation of a very sophisticated programming environment. Finally: A link in with your other products that would allow
List of all Projects to Creator
I'm looking for the simplest way to keep an updated list of Project names and status as records in Creator. I have one portal and am looking just for the following data : Project ID Project Name Project Status I would like to run this from a scheduled
Random Number Generator
I would like to create a "Magic 8 Ball" type script where a person enters a questions and then a script generates a random number then pulls that numbered from a database. i looked through the documentation but it didn't cover anything like this.
Need an sample coding for Custom action buttons for view record-summary view (template)
Pls, add "Custom action buttons" in record-summary View (which are specified for this View)
Using creator as a backend for a web application
Hello. I am considering the possibility of using a creator application as the backend for a (fairly) simple NodeJS web application. I've looked at the creator api and this seems like something that could be possible. Is anyone else using creator in this way? Does it work well for this?
Success message after updating record via edit record
I have set up a stateless form so that the user can pick a record from a picklist and then be taken directly to Record Edit mode, using the guidance given (http://www.zoho.com/creator/help/views/editing-records-via-record-id.html) However, when the user clicks on Update at the bottom of this page they are taken to a page with the message 'Data updated successfully' (https://creator.zoho.com/appcreator/jsp/successpage.jsp) which leaves the user stranded, instead of the usual pop up message. Is there
Next Page