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
Problem with MAC
I have a problem with MAC when I edit a client, the foreground window is too large compared to 2 weeks ago, before this problem was not there. With windows I have not this problem, can you help me, here is my mail. mobileinfoc@gmail.com
ZOHO CRM and CREATOR LINK
I am a ZOHO CRM user. If I create a form in ZOHO Creator can the information be automatically sent to ZOHO CRM?
Problem with Report (not showing some data)
I think I found another important bug with Reports. I am using the Color filter in one of my reports, but it seems the report is only showing me countries starting with letter S to letter Z, The rest of the countries (letters A-R) are not being shown. Here is a link to the Report: https://creator.zoho.com/glajman/countrybeta/#Report:Country_Donations_Report I think this is a bug. Any help? Thanks!
imported excel data and add them up in formula field
My 'Total' Field is not working. I imported all the date from my excel file. I can't figure out how these imported data are adding up automatically and show the sum result in my 'Total' Field.
Zoho Creator - Vincular formularios
Hola! estoy realizando una base de datos con zoho creator y tengo un problema. POr un lado tengo un formulario con los datos de empresa y por el otro tengo un formulario con los contactos de estas empresas. Querría vincular estos dos formularios para que quede toda la información ligada. Como puedo hacerlo? Gracias, Sandra
Sending a mail from a form - Messed up formatting in text
Hey, I've just recently started using the form editor which is great. I've got everything working but I have one problem. I have a form that I've set up that it will send an email with the form data to me. The problem is that the mail message formatting is all messed up. Looks like this: " This is a support request generated from the help web form: User submitted dataName: : USER NAMEYour email adress: : KILlop@.comDescribe your problem: : Please help me soon I will need it. " Of course I want it
Bug with radio buttons
ZC Team, I just discovered that if if you have a form having as a first field radiobuttons (I'll name it radiobuttonsfield), with choices let's say {"a", "b", "c"} where "a" comes first, and if at on load you put input.radiobuttonsfied = "b"; or input.radiobuttonsfied = "c"; guess which will be the value shown for this field? The value will be "a" regardless of the input value from the script... it will show the value of the first radiobutton. Please, fix this as soon as possible. Regards, George
Unable to add decimal field control to a form - it disappears.
Unable to add a new decimal field to a form. There is one form in my database that will not permit me to add decimal fields, despite many attempts. Is there a problem with the decimal field control?
Export View to Excel
When I exported my View to Excel file, some dates appeared in Excel as negative values ! Kindly check the attached file, rows from 277 and below.
Scheduler Working Correctly?
I have a custom schedule set-up to run weekly: Weekly { execute event on '2010-04-11' at '07:00' on monday weekly } Which is intended to find all records meeting some criteria and send an email for each rr in SCHEDULE[(DUE_DATE >= zoho.currentdate && STATUS == "Open")] { sendmail [ from:zoho.adminuserid to:rr.USER subject:"Notice for " + rr.AREA message:"You are scheduled for " + rr.AREA" ] } But it only sends email for the first instance on the list
Submit Button
Hi ! I have create a form, all work well, but i have only 1 problem. If my customer click more than 1 time the submit button, i recive more datas than i need :( Is possible to set that the submit button can pressed only 1 time and execute the "on submit script" only 1 time ? Thank you and sorry for my bad english.. Simone
iPad usage not working
Unable to see my forms from creator on my iPad. How do I correct this?
Bug in Reports
I'm not sure if this belongs in Creator or Reports forum: I have a radio button with a number of options. One of these options had quotes.When a user selected this radio option, the report (as a pie chart) for this selection count got re-titled to the user's name! Once I deleted the quotes, the pie chart displays the title properly. So it seems quotes are messing-up your back-end code. I made a test app so you can see the strange bug... http://creator.zoho.com/niskypto/test/
Can not Select Text in HTML View Freeflow Mode under IE v7
I had reason to access ZOHO Creator from my IE v7 Browser (instead of my usual practice of using Firefox) ... when trying to edit an HTML View using Freeflow Mode ... I could not "select text" with my mouse ... tried it (unsuccessfully) in a couple of Applications ... same attempt under Firefox worked just fine. Gaev
Next Page