Template Issue
Hello, How do I make Deadline_Date (Due Date) visible on my "Add Request" form? I tried enabling it on a bunch if views by selecting it in "Column Properties" and "Set Filters". This pertains to the Zoho Help Desk application. Thanks
Why is Zoho re-writing my code?
In my application NewINZDB2, I have a form called frmEvent. Each time I try to write the following code: //Contact if (input.cboContact == "New Contact") { varContactData = tblContact [intEventID == input.intEventID]; varContactName = varContactData.fmlaContact; varContactDetail = varContactData.strAddress + "\n" + varContactData.strSuburb; } else if (input.cboContact == "-Select-") { varContactName = ""; varContactDetail = ""; } else { varContactName = input.cboContact; varContactDetail = input.strContactDetail;
Look Up Field to Link Another Form
When trying to use the look up field in a stateless form to link to a regular form not all the fields already existing in the regular form is displayed for selection. Please help. Thanks, Jasmine
problem with openUrl and Internet Explorer
Hello, I have an application where the openUrl works perfectly with Firefox but it doesn't work with Internet Explorer. Here is the line I use, I open a URL and pass some parameters from my form to another page. openUrl("http://www.gpsopleiding.nl/bevestigingv2/?email=" + input.emailadres + "&cursus=" + input.Cursus + "&datum=" + input.Cursusdatum + "&geslacht=" + input.Geslacht + "&achternaam=" + input.Achternaam, "new window"); This all works fine with FF (it goes to the URL) but on the same
cannot add new column to a view
I am unable to add any more columns from the column properties. I can do it for many views but certain view have stopped working an i cannot add more columns. I can select them as i should be press done and it will say please wait. After a second i will redirect to the preview section but the columns are not added. What should i do? Whats wrong?
No data available
Hello, I copied an application and then imported data into the application. The views are functioning fine but the reports are saying that there is no data available. Is there a time delay between importing data and when the system will index this data so that reports will function? If there is such a delay, what is it normally? If no such delay, would you please assist me? Dion
Modify Edit Record Appearancein a View
So i have a really large form. I have many views. One of my view I have set up to see certain data from the form, only about 4 fields. I want to be able to quickly change a couple fields inside this view. I have only included the 5 fields in the grid view and it looks fine in that view. The problem is when i click on the edit button it opens the edit box that has every field from my form in it. It is very long, i do not want to need to look through all the fields. I just want the items from that
Importing form data dates
I have been trying to import some data into my creator form but cannot get dates to work properly. The dates do not show up after the import even though they were selected to import and proper formatting was used. I got no errors during the import. I know the format is correct because there is an error message if it is incorrect. Please help, i don't want to manually set all these dates!
i like this site
It is not user friendly But i like this site Can u make this as user friendly and i have problem with this site i.e can this website update the datas For example : If i am creating a pivot table for the particular datas. If i am updating in the mastersheet it is not updating in the pivot table
Records pricing
Creator is an excellent application, and I've been able to create web based forms that are quite workable for my organisation. The pricing, however, is another matter. The limit on the number of records is much too small. This would be a deal-breaker for us. We would have to spend too much money for it to be workable. At the premium level, we would need about 100.000 records for it to make economic sense.
Fetch all data for a given "Index"
As I enter data into a form, I need to look up all data that was previously entered into the same form. All of the data will have a unique Index key. As I enter the additional data, I need to compare the new data being entered with past data that was entered. I will need to fetch multiple field with all records previously collected for a given index key. Once all fields for all records has been fetched, I will need to run several IF statements. I know I will be using a fetch script. I just
Zoho Creator Mobile Access
I'm trying to access Zoho Creator on my iPod Touch (ios4). When I go to http://creator.zoho.com/mobile, I'm prompted for my logon information. After entering it, and clicking "Sign in", everything just stops working and I'm never able to get logged in. Is there a problem using Zoho Creator Mobile on an iPhone running ios4? Thank you for your assistance or suggestions.
Input fields...
Trying to figure out how to search for text entered in an input field on a web page if exists in my zoho database. Don't need to show a list to the user, just to verify that a value entered does exist in the database. Where do I begin?
Scheduler Not Working
Hi, my scheduler has usage limit to use, all my shcedules are enabled, but ther are not being executed? any idea how I can fix this problem.? Any help would be greatly appreciatted.
Email integration in Creator
Hi Guys, Anyone has integrated Zoho Mail in a Creator app ? I'd like to send and receive mails from a HTML contact view. (maybe similar to Zoho CRM). Any leads will be appreciated. Thanks Pascal
I Used a Multi Select Field - Now how do I set Criteria values for that field correctly for the view?
Here's what I have. A list with various forms of cancer and deadly illnesses. I used a multi select field where the data entry person could select multiple types of cancers or illnesses that the person had. Now, they've come to me needing something else. They need to create a view for everyone who has breast cancer, another view for everyone who has any type of cancer other than breast cancer, and a third view for all the names that have some illness other than cancer. So, if a person had Breast
How do I edit my Forms for the database function when it suddenly disappears?????
Hi, I apologise for lack of detail I'm new to the world of Zoho and have limited computer skills! I've recently created a database on Zoho Creator using the form to create a user friendly application. The application is working well but for some reason I am no longer able to edit the original form - it doesn't appear to load it anymore. Does anyone have any suggestions as to how I make it spontaneously reappear? Many thanks in advance! Ben
How I can have 3 main colums under Forms section?
If I add new form it comes automatically with 2 colums, and I can drag and drop vields there. I need 3 colums there...how I can do it. thx G.
Fetch Records: syntax for fetching all
How do I fetch all records for a Form? I've come up with this: all_records = MyForm [ Added_User != null ] ...as Added_User will always have a value. Is there a better way? Kevin
Import/Export
I export a Creator database, both as CSV and Excel format. I import them to a copy of my application in either format and the data is incorrect. Dates are missing and fields that were edited (updated) have the old data in them. Also, in the view before I export them the decimal fields all have 2 decimals, but the export file shows some with many more decimals. Where is it getting the old data from? Aren't records getting updated in real time? I keep trying to like Creator, but it continues to appear
Backup failed and reports are now not working
Hello, Backed up my application. Zoho reports that the backup failed and now my reports are also giving me errors saying, "View/Table is not present in the database."
When can I expect feedback?
I reported a problem on Friday and it was replied that I would receive feedback once the problem has been resolved. I have tried private messages, reposting and still no joy. When can I expect feedback and my application to be functional? Why can we not get progress reports? Link to original post: http://help.zoho.com/portal/en/community/topic/backup-failed-and-reports-are-now-not-working
Can't install applications or add users
Every time I try to install an application from the marketplace I get an error. I have only one application installed (but had others installed yesterday that I deleted). I am able to duplicate the application and also able to create new applications. Also when I give a user access, it sends an email to the user but does not allow the user access. The user does not show up in my shared list.
Missing Kansas in state dropdown list
The state dropdown list does not include Kansas (KS). Could you include that please?
Creator drop down assistance.. I'm sure this is needed by someone else too
In Creator I need help not selecting a drop down item if I have already used it. I have a list of phone numbers and also a list of extensions(a few thousand. I want my list of extensions to be associated with each phone number. After I pick a number I want to see only the extensions that belong to it. After I pick the extension I want it to be removed from my drop down, or marked so I know I have used it and don't pick it again. What are my options?
Uninformative error messages
Sometimes when submitting a form, an error message that provides no useful information is generated... see example below. I'm not asking for help w/ this particular error -- I can muddle through solving it -- but can't Creator be made to always provide some kind of info about any given error so it's not just a vague uninformative error message? Surely at the time the error is thrown, the compiler knows what threw the error, or at least some contextual information that would be useful. Thanks.
Creator formula deleting brackets on its own
I am trying to use the following formula in a formula field. Creator seems to be deleting my brackets and causing the formula to be wrong. ((Funding_Request_Amount - (Funding_Request_Amount * 0.065)) - ((Num_of_Empoloees / 20 ) * 1000)) * 0.2 after saving with no problem and going back into the formula creator has changed the formula to (Funding_Request_Amount - Funding_Request_Amount * 0.065 - Num_of_Empoloees / 20 * 1000 * 0.2) All brackets gone and formula no worky
How do I do this?
Hi, I am evaluating Zoho Creator and would like to know whether the following is possible. We work in the pharmaceutical industry and each drug has a trade price. I want to use Zoho Creator to keep track of our cost prices. The cost price is dependent on a two factors: - It could be on a list where the cost price is specified OR - Dependent on who the manufacturer is, a set percentage would be taken off the trade price. I thought about how I would create this using Zoho Creator and thought I would
Usage Limit error although no records added so far
So far, I have a simple dummy form that lets a user log in. The form is not linked to a table. When a user logs in, however, and the submit button is clicked, I add a record into another table, specifying who logged in and at what time. It seems simple and reasonable so far. However, when I run it, I get this error: Error details: Error occured while executing on click script. Usage limit reached. Your limit is 0. Your current count is 0. Please purchase Add ons or delete some records I don't have
5 character limit on currency fields
All fields that are defined as "currency" will not upload more than 5 characters. For example anything over $1000 does not upload into the system...however $999.99 will still upload. Any suggestions? FYI - The file being uploaded is a csv file
Volunteer Registration Application
Hi I have created a account in Volunteer Registration App available on Marketplace. When I add a volunteer to the list, the app sends a email to me(admin) and the person who has been added as a volunteer. The email also includes a link to view/edit the details of the person added. Unfortunately the link does not works. I can see the scripts in Send email are incorrect, but I am not sure how to correct them. Could you please help me Thanks
Traditional Chinese Character
I have problem with sending email notication with Traditional Chinese Chartacer since some of the Character cannot be present. How can I fix this? Kaman
How do I make a web form public?
Hi, I am trying to set up a web form which I want others to be ablt to load data in to. When I click the request to make public link nothing happens. Please can you tel me how to overcome this. Thank you. Darren
Main form and subform
Hi there, I've used zoho creator a lot. I am not sure how to create a main form and an associated sub form. When I crate a expenses form which includes report date, employee name, total reimbursement amount etc, and associated subform included all reimbursement detail items, like date, description, meal, hotel, etc. thanks for your brilliant work Ming zhumingca
Zoho Creator Inaccessible
I can not access Zoho Creator at all! I recently changed the default email address through Zoho Creator's Admin panel. Would this be why? Please help asap. Leo Saumure
Page Direction
Hi, I like your application. And, I'm wondering if I can change the page layout direction from the let to the right is it possible? Regards, Ghazi
No Way to Disable a Sorted Group
I have a 3-column view that looks similar to this: 1 Color Blue 1 Color Green 1 Color Red 2 Auto Ford 2 Auto Chevy 2 Auto Toyota 3 Size Compact 3 Size Full-Size 3 Size Medium When I group on the second column, I get this: Auto 2 Ford 2 Chevy 2 Toyota Color 1 Blue 1 Green 1 Red Size 3 Compact 3 Full-Size 3 Medium Notice, that Zoho Creater is always sorting on the column that is grouped. When you look at the options in the view for
problem with non logged in users viewing the database
I created this pupil register to display on my website so that viewers could see the list without loggin in at http://www.wigtonian.org.uk/pupils.htm However now it is challenging them to login- I want them to be able to view the database but not edit it I havent changed anything on my site so I am wondering what has changed to require the login?
Attachment issue in Zoho Creator
It looks I can't delete an attachment from a record. A document attachment.
Second round of problems with Creator!
Still having problems saving data in Creator... It is working Intermittently for me today, much better than last night, but right now when I go to save any change, no matter how small, I get the eternal "Saving... Please Wait" splash again.
Next Page