Accessing view from public website on the free plan
Hi I have used the Zoho free evaluation plan to create a simple view. I want to embed this view in my website page to allow users to search my database. When I tried using the share option, I got the message below: "Due to security reasons, enabling public access is disabled temporarily for the trial and Free Edition users. If you need this feature, contact support@zohocreator.com." Could you help me with this? Thanks.
Changing Field Names via Form Definition
When the form is in edit mode, you can change its name and display string, but you get an error if you try changing the name through the form definition. If you make lots of changes all at once (as I did when I applied a naming convention), it's cumbersome.
Report Formula
I want to calculate projected revenue by using "opportunity" data, stored on one form, and "pricing" data, stored on another. Is this possible?
IE8 warning for HTTPS forms
IE8 gives the following warning when loading an https form: Do you want to view only the webpage content that was delivered securely? This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage. This will scare away some people from entering info. Is there anything I can do about this?
Form formating
Hello, I am new to ZOHO but am finding my way around fairly easily. I am building a application which has a couple of lenghty forms in it. Is there anyway to change the format of the form to 3 columns so that i can fit all the fields on 1 page? Thanks Steve
making database public
I am a new user and would like to activate my public features to embed my datatbase on a web page. It is required for a class assignment. Thank You, Tamika Harris
BIG Trouble
I cannot view any of my applications nor sign-in to them via direct links. Something is terribly wrong in the lats few minuses at ZOHO Creator!
Question from Carolyn
Are we using this feature?
No access
We are no longer able to connect us to our application. The login page is blank!
Why has ALL my Created Database Applications CEASED to EXIST???
Dear Sir, Why has all my created applications suddenly ceased to EXIST???!!! Is there a way I can recover / download all database entries particularly on the following: http://creator.zoho.com/revenueriser/saint-monique-inquiry/view-perma/Saint_Monique_Inquiry_Form_View/ These info are critical to my business operations, please reply ASAP. Erickson
Database form is broken - can't edit or delete.
I have a form that has broken. I created it OK from an XLS upload, but when I tried to change one field, the form stopped displaying. I suspect my change was not accepted properly and now I can't delete the form. How do I delete the form ? I was trying to change the "Year" field title to "Season" and the max digits to 4. URL : https://creator.zoho.com/info.collegians/form/4/edit/
How do I hide fields from public users?
Hi all, I have a form which I have embedded in my website. All of our users need access to every field on the form, however I would like to hide some of the fields from the public users completing the form via our website. Any ideas? thank you
Format a Number Column
I have a simple count routine in an application that updates number in a column. The highly unsatisfactory rendering (at least in Firefox) looks like this: Please don't tell me I have to render them as text to make it look better
Cannot import anything!! AT ALL!!!
I am trying to import some data into creator. It is created in Excel. Not too much data, only about 20 lines into 10 fields. But this is something that I need to do daily, so I need the import function to work. I have tried this in Safari, Firefox, IE, on Mac and Windows. I have tried to import using the Excel file, and pasting data in XLS, CSV, TSV format. I hit submit, get the Importing data message, the view reloads, but nothing has been added. I tried importing using the migration tool
Set Filters does not work with all fields
I have a straight forward app that was working in all aspects. I went in and changed some script then all of a sudden 1 of my saved "Set Filters" under a View no longer works. I reviewed the filter .. and it had incorrectly placed "Modified User IP Address" as the selected field. I went in and changed the field back, but every done I click on "Done", the filter resorts back to "Modified User IP Address". It appears that some fields in the drop down list always resort back to "Modified User IP
Anyone else having problem with Filtering??
I am wondering if anyone else has this problem with filters. I have been on the phone with Ruben all week and apparently their developers are working on it, but I am not seeing any progress. ~ I have a form in which the user enters staff position and names (POSITION TYPE). ~ My main form allows the user to select different people of different positions to assign to a task(TASK). The fields are five lookup fields from the Position type form. ~ In the view of the Task form, under filter, it is combining
Adding/Editing fields in the database after uploading
Hi, Is there any way to add/edit fields of a database once i had uploaded the database while creating the application? Thanks
lookup multi select not working
I'm linking 2 forms: 'musicians' form needs a field called 'Availability' which looksup dates from a 'calendar-type' form and allows selection of multiple dates. This works fine for singleselect, but is not working with checkboxes or multiple list: - on Add, it appears to submit successfully, but the data doesn't load in view - on Edit, displays message 'invalid entries found, please correct and submit again', and also 'null Failed to update data.' Help! Thanks.
href in a formula field
As I am not a "real" programmer, I could use some help with this one. I copied the following piece of code from the Zoho CRM application that is available in the market place: (("<a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=\"#View:Detailed_Lead_View?lead_idstr=") + ID) + "\">View Details</a>" This code is placed within a form's formula field. The application then places the field in a view, which allows the user to click a link to open a view.
POST the XML String Without A Form
How do I post the XML String Without A Form?
Saving scripts has become REALLY slow
My script for On Success in only about 150 lines. It takes about 2 minutes to save each time. I copied the entire code to clipboard and deleted it from zoho, it took only a few seconds to save. I coped the code back to zoho and it took only a few seconds to save. But now again, even if i just make the smallest change, it takes about 2 minutes to save.
Site
very very good
Control over the default sort order
The default order for sorting of records in a view seems to be the inverse of the order they were entered in. Is there a way to arbitrarily change the default order?
Is there anyway to calculate an exponent in a formula field?
I'm trying to calculate simple interest: (Principle * (1 + 0.08 / 365) + fee) ^ (Todaysdate - Issue_Date) It's saying '^' is not valid.
Using additional email address in mail to scrip
I would like to send confirmation emails on successful submission from my app. So far the only email variables I can see are adminuser or loginuser. How can I setup another email and make sure it's coming from it?
Currency field won't maintain the initial value and required field settings
Here are the steps to recreate the problem: 1. Create a normal form along with a view. Add both a Single Line field and a Currency field to the form using the default settings. That is, when creating the Currency field, do not check the box titled, "This is required field", and do not give the Currency field an initial value. Use the default Decimal Value of 2 points. 2. Access the application and enter a record. Add data only to the Single Line field, but not the Currency field. 3. Edit the
Script Builder hanging in Loading....
Every time I access the script builder whether it is a function or a form, the web browser gets stuck on the "loading..." section and everything else becomes non-responsive..., I have tried both Safari and Google Chrome on OSX... If I try another application everything is ok.. So it is something specific with this application? What can I try?
Script Saved - but not
Hi, I create a HTML view to allow user to print a card from a Creator Database. When I save this view, system return that it's saved or modified. When I access at this view I see that really are not saved. So the system do not accept my html script. Any help? Thanks Misca
Updating a table
Hi Folks - I have a Flight Record form that uses a Lookup field to a Customers table. If this Flight Record form is open and a new Customer is added, the new customer's details don't show in the Lookup field. Somehow I need to be able to refresh the lookup. Any suggestions please? Many thanks in advance for any help.
Zoho changing view critieria upon save
Hello, In the criteria of my view, I'm designating: Teams_of_interest.Department == "Communications" But when I save the criteria, zoho changes it to: Jobs_Selected.Department == "Communications" Has anyone seen this kind of behavior before? Thanks in advance!
Refresh Code
Hi Support, Please advise if zoho creator has any refresh window code for a form? Thanks,
Auto refresh
I have a large table in Creator in which the data is constantly changing (input by many people) throughout the day. I am trying to display this on a big screen and have the table auto refresh every 30 seconds. Does zoho have this capability? My current solution is that I have embedded this table into an html file on my server, and I have the html auto reload itself with this code: <META HTTP-EQUIV=REFRESH CONTENT=30> I tried making an HTML view in zoho and entering this code at the top, but it
So I was thrilled with the ease but nothing shows up when I try to access?
So each page shows up? The whole project shows up? However when I try to access the application either thru the page or thru an email, I see the menu down the left hand side, but clicking on it does nothing? I go back and check each page, all the info I inputted is present. What did I miss?
View criteria allowing invalid formula.
This is so frustrating! Why does the advanced criteria editor allow a relative field from another form to be entered into the criteria but have zoho modify the users criteria on save? Support please explain why you allow users to develop view criteria in the advanced criteria editor only to save the criteria and have it be modified. It makes no sense to me. And it's a big waste of my time. The view advanced criteria editor is buggy in this sense and I believe you need to take not of it and get it
Sending email - Quota
I know that Creator allows 500 emails to be sent per day. If I need more than that, I know that I have the option to buy more. However, currently, I do not know how many emails will be sent per day. So I would like to know how you billing works. ~ If I reach 500 emails in one day, does it just stop sending any more? ~ Is it possible to have the system just charge me the $20/500 emails when the quota is reached? ~ Do I have to purchase a few thousand just in case it happens to go over the limit?
Exporting data
How do I export the data from my zoho creator database? I'm worried I might accidentally hit the reset button while entering data and lose it all. Do I have to upgrade to a paid account to do this?
Line Feed in multiline field on stateless form
I am trying to inset a line feed into a multiline text field on stateless form using script called from a button. I have seen other posts on this topic but have been unable to get this to work. When the user click the button, I would like the multiline field to populate with text and input fields seperated by line feeds. Following is the script i am trying to run with no success: RateTextProperty = "Property: " + input.Property + "<br>"; RateTextRate = "Rate: $" + input.Rate + "<br>"; input.Rate_Text
Automatically open and filter a view
I've created a Jobs database whereby you can create Tasks and assign them to Jobs using a unique Job number. I'm trying to find a way whereby when a Task has been created against a Job, after the Task has been submitted, the Task view automatically opens but only displays the Tasks assigned to the Job in question including the recently added Task. I've been trying to do it with 'OpenURL' but not sure if this is possible. Any ideas? Martyn
ePortfolio Application
Someone should develop a K-12 ePortfolio application
Arrange multiple fields in a single line
Hi Everyone, I would like to arrange multiple fields in a single in on a form. The values would be alligned. Example: Checkbox 1 field Checkbox 2 field Start Date Calender End Date Calendar Radio Button 1 1 Calendar Calendar 2 2 Calendar Calendar 3 3
Next Page