Any chance 'Type' is an undocumented restricted keyword?
I've created two forms, "Institutes" and "Orders". Think of Orders as organizations; Institutes as types of Organizations. The Institutes form has only one field, "Type". Its values are used when creating records in the form named "Orders" such that any value in entered in the Order's "Name" field also will have an associated "Type". To do this, as would be expected, a drop down list in the Orders form exists, named "Institute"; it is dynamically populated with all of the "Type" values found in the
Enquiry Form in Website
I have approx 500 properties on a website and I want to embed an enquiry form that will update my database aswell as email me the enquiry. I would like the received email to be from the enquirer so that I could reply. Also each property has its own reference i.e VA50, R1030 etc and I need a way of being able to tell which property the enquiry is about. It is easy for me to adjust the html code on each page to suit but I do not know how to do this with a form that is embedded. Any suggestions greatly
Hide formula and multiple select fields!
Hi I would like to hide 3 "multiple select fields" via script in "form action" and under "load" because I would like them to be depending (and visible) on the value on user input of a dropdown. I though get the message; Error at line : 34 hide/show/enable/disable fields is not applicable for formula and multiple select fields How can I then hide this on load? Br Dennis Skouboe
Show only current week in a view
Hi, First, I'd like to thank you a lot for this application and for the great support you're providing. Here's what I want to do: Is there way to show only current week in a view ? I created a timesheet form and I want my employees to fill thier time. I want to give them a list of thier records of the current week (since last sunday). I put a SUM to show them the number of hours made in the week and I allowed EDIT for them to edit their records. Thanks in advance. Pascal
Support Team - your email is bouncing
Just thought you should know that all Send Mail scripted email and mail I try to send to support (add edit access, etc) is getting bounced back.
Share Error
I have shared my application with one user to see all my forms and views. They can see the forms, but receive the following error each time they click on a view: "You are not authorised to access this view in Zoho Creator. Go to Home" Please Help! nofinvest
Form won't load??
https://creator.zoho.com/kwasserman/work-order/ I'm in the process of creating a form for my sales reps to enter in project specifications. I'm attempting to hide fields until they are necessary. The form is still a work in progress... however, whenever I try to access it, it just hangs and the form never loads. What am I doing wrong? kwasserman
Big Issues for uploaded files and other bugs on creator
- ds scripts exported cannot be easily imported again, double-bytes characters seem cannot be supported. - files uploaded can be accessed withou any user login!!! This is terrible! The URL looks like: http://creator.zoho.com/DownloadFile.do?filepath=/xxxxxxxxxx.doc&sharedBy=<owner_name>; - and even when the application was deleted, you can still access the files uploaded!! - document title cannot be displayed for mobile.zoho.com for double-bytes characters netron
Error!!! Please help!
I cannot view uploaded files under the view: http://creator.zoho.com/caudillc/view/6/29FWmX6PfBvy7xwyFWDPCV4PknUDw1qPmOngHtb8RaxYKmxhQRnG4HSrDyW7GZPV2VvmrNnsDFUQdRQGFfXCFM1pVpZqUPDu6On4/ Everyone receives the following message: You are not authorised to access this file in Zoho Creator. Go to Home I have not changed anything to this application in months and this just started happening the last couple of days. caudillc
Simplify Date Input
Is there a way to have a "Start Time" and "End Time" entry function simplified/rounded to the nearest 1/4 hour? thx!
for loops? not for each though
I wanted to know whether deluge could use for loops in them... and if there was something that could give me the equivalent of syntax's in java.. cuze know the most about that language.. somethign like the normal.. for (int i = 0; i < somenum; i++) {} for my quiz application.. i would like it to compare values to a list of answers in the database without typing the same thing for each question.. the public apps "quiz" application works but it only has 5 questions or something... what if i wanted
Attached file
Dear Zoho, Since today, I can't access anymore to my attached files, I have the following message : You are not authorised to access this file in Zoho Creator. Go to home. (I'm the owner of the application, and logged on) hotline
Is it possible to pass a column as a parameter?
string get.getColumnVariable(column Column_Name, string variableName, column Column_Name2) { if (count(Student_Info_Form [Column_Name == input.variableName]) > 0) { myCol = Student_Info_Form [col == input.variableName]; return myCol.Column_Name2; } else { return ""; } } something like that so i can basically get info from different forms by calling the same function.. (more global variables i guess) thanks
fields marked hide
I hide some fields on my form but on the confination going to the clients email it shows up, why? meirto
Simple App To Take Two Inputs and Create A Text Output
I want to write a simple application with two multiselects and a text box. The user makes selections from the two multiselects and hits "go", and the text box displays an output that I create in a script, using the multiselect information. How can I do this in the simplest possible way? Thanks in advance.
Hide all fields?
Is their an easy way to hide all fields... instead of manually typing "hide fieldx" a for each loop?
How to reference the row being deleted?
when on delete, and in on validate, how do i get the row that is being validated to be deleted? im using basically the same code from the auto_increment sampleapps for my applications Student_Info_Form is just a form with a "Number" field which is hidden and stores the auto incremented number so basically i want the numbers to update when a entry is deleted, and all the numbers greater than the number deleted are subtracted by 1, and the max value also -1 as well. on delete { on validate { for each
Chart
Hi, When I try to create a graph view I found no way to group same fields, therefore, the same fields will repeat on the x axis no matter they have the same value. For example: If I have a register with "namefield" = X with value 1 If I have a register with "namefield" = X with value 1 If I have a register with "namefield" = X with value 1 Instead of showing me a pie chart (for example) with only one field and total 3 and 100%, will show me the three times the same field with value = 1 and 33.33%
Presetting a From from an external URL
Hi there, Congratulations for ZOHO Creator, I am really impressed about it! I am designing a Demo where part of it runs on my local machine and communicates with ZOHO in order to simulate the whole workflow. I have solved most of the problems for the Demo, but still, I want to be able to call a ZOHO Form from an external URL. My Zoho Form has an ID Field which is unique and once selected from a pick list it shoud publish all personal data related to this ID. The form works as expected, but now I
bug with Safari
When in Safari/webkit browsers, the editing of the email address doesn't work. I just get a big black screen. refreshing/reloading makes it go away, so I can do other things. tara
using a script
How can i make my form so when either someone loads the form or if they submit in it. That will will check all the entires to see if any are a week old, and if they are to remove them? And could someone show me how to do it? Thanks!
Need help creating app from xls or tsv
When I create an app from a xls or tsv it allways seems to mix around the fields and columns... Is there an easier way to do this? I can use some advice. Thanks for your time. Gonzalo info
Error while executing on update script in bulk editing
I'm working on a database with aprox 10.000 records. When I try to make a bulk editing I always get this error message: Failed to Update Data. Error occurred on executing deluge script View error details Error details for airports Form Error occured while executing on update script. Error Occured in process I can't understand what this mean exactly, but I haven't any on update script scheduled. If I try to edit records one by one everything goes well. I allowed edit acces to support. The application
Lookup field not sorting data
I reported this ealier and I'm hoping that know that I got the Zoho paid subscription you might try to fix this bug. I got a website where I'm using the lookup field to select the country, state and city; and the problem is that the data is not sorted out, even when I selected the data to be sorted when I created the form. Please visit my website where you can see how the data is not sorted. Please try as follows: -Country = United States -State = Georgia -City then you will see that the cities are
hidden fields not hidden
I have marked a date field hidden and when I view it on my website where it is emended it is not hidden. How can I make it hidden?
Status of Edit/View Bug
Support Team - Can we get a status on the bug where - in a view where only certain records show (e.g. those where loggedin user == creator) - when the user edits a record and submits, ALL records show up after the submit (i.e. the criteria seems to reset)? This is a highly critical bug for those of us who use a restricted view to allow access to only certain records. With the bug as it is now, security is compromised as any user can edit any record after editing a visible record. As it stands, I
Text field desapear when I enter the appl.
Hi The "add notes" field act sometimes a bit strange, if I wanna change at a text field, change does not appear, sometime the text simply are gone. I have a case where the text suddenly is gone. If I go back to edit mode, I see the text field and it is empty. I try again to input some text into the "add notes" field. This works fine so far. In the edit mode the new text is visible, but when I go back to the appl. the text is gone. If I then return to the edit mode - the text in the "add notes" is
Hiding the "Powered by Zoho Creator" logo (link)
I love zoho creator, is allowing me to do things I didn't know how to before. I working on a website that allows employees to see parts, and some other information with zoho creator. I'm spending a lot of time and effort putting all this information together and I'd like to prevent peolple to know about zoho to avoid the competition at least for now. Is there a way to hide the "Powered by Zoho Creator" logo (link) from the bottom of the forms or I have to get a paid for subscription in order to disable
Restoring a form from the database
I tried to modify the size of a field in my form and it has deleted that field and all of the following ones. I have a large database of yearbook submittals for my school reunion. How can I rebuild the form to continue entering data and to edit existing records? pangze
Wrong syntax?
Hi I have put in some code in "on user input", but my "last" else if (input.replorob == "Select"), does not work in the application. Do I have to write something else? see full code; if (input.replorob == "Yes") { show plain5; show stock_old; show stock_scrap; show stock_transfered; show replaceold; show replacenew; } else if (input.replorob == "No") { hide plain5; hide stock_old; hide stock_scrap; hide stock_transfered; hide replaceold; hide replacenew; } else if (input.replorob == "Select") { hide
Adding hidden fields that can import variables in the form
Hi It would be nice if we can create hidden fields in the form, that are used to capture lead source tracking codes. The lead source trackign codes could be parameters on the URL ot the html page tomgalanis
Pre Defined data in form fields
Hi, I am interested in placing an enquiry form on my website which will add data to the database. The user can fill in name, contact details etc. But I need a way to populate a field with a reference Number to a particular Vaction rental property so I know what property they enquire about. I cannot rely on the user putting in their own subject line. The html code for embedding the form into a website does not allow for this so it seems. I have tried using formmail and adding data via email but this
Simplify date and time
I have created an input screen that asks for a "start time' and "end time" for projects. Then, the program is to automatically calculate how much time is spent on the project. I want the times simplified so that I enter only hours and minutes, NOT seconds. It would be even better if the inputted time was automatically rounded up to the nearest 1/4 hour. How do you do that? Also, is there a simple way to have the total time calculated?
How to change a username (zoho.loginuser)
Hi, Is there a way to change a username (zoho.loginuser) and keep the same email (zoho.loginuserid) ? I asked my user to change his Nickname in his User Account but it doesn't seem to work. He still have the old username in the upper right corner. In Deluge, I have also the old zoho.loginuser. Do I have to close the account and open a new one ? If yes, will I be able to open an account with the closed account email ? Thanks, Pascal
Help help!!! - my form is gone
Hi We start work within 1-hour and my form is still not yet to see. I have made a request yesterday, but I still not have an answer. Please help ASAP! Br Dennis Skouboe
Admin Rights to other users on Zoho Creator?
Hi there: I have created an application using Zoho Creator. I now would like others within my workgroup to be able to not only import data, but also create new fields within the application. How do I do that? The only roles that I can assign the other users are "User" and "Developer", neither of which allow change rights to the application. Can't I give admin rights to my workgroup users? Please help. mihirn
Help - My form loops!
Hi I try to enter my form but it is not possible it will not show up. My appl. is the MMDT request system ver. 2 You have the access! Br Dennis Skouboe
Problem with Creator form in IE 7
I created a long form (40 fields) in Creator using Firefox 3(RC1). Works fine, both when accessing through ZOHO creator and when embedded into my website. However, when I tried to view the form using IE7, it doesn't work properly. When trying to view the application, the form doesn't display any fields; just the header and border. When trying to edit it, only the first page-full of fields are shown. Any ideas? danleigh
Percent Field to string - too many decimals
Hi - I have a percent field that I then concatenate to a string field so that I can add the "%" character on the end (like Percent_Left = Percent_Holder +"%"). Although the percent field is limited to 2 decimals and displays correctly, when I add the % symbol and pass it to the string, I get 10 decimal places. Is there any way to limit this so I either remove the decimals from the string or only pass along two decimals? Thanks! nwpkms
Possible to Script Tab Display
Hi - Does anyone know if it is possible to use deluge scripting to display/not display a tab based on logged in user? When I view the entire script for the app, I can see the "page {" text, but can I do something like: if (loggedinuser==owner) show tabname.page
Next Page