data validation
I was trying to validate a form with the following code: if (count(Address[Address_Name == input.Address_Name && client_code == input.client_code]) > 0) { alert ("An address with the name already exists for this client. Please enter a new name."); cancel submit; } But it is not working. Sometime the validation works and throws the alert and sometimes the user can enter the data successfully. I thought it was a really easy validation. Am I doing something wrong or there is something wrong
Even without a registration
Even without a registration, the application charges that exceeded my quota I have 6000 records and 15,000 records. How can?
Time tracking attendance
I would like to know if there is any way on a form that you can type in a number e.g. 1234 press enter then in a table it adds 1234, the date and sign in time.Also usin the same form if you type the 1234 in again it will add sign out time. Any help please? payroll check calculator
world-viewable Creator app: URL for my client?
I have a simple scheduling app built in Creator. This will be used by my corporate client. Is there any way to share a URL for the app that doesn't reference my Zoho account name? Glen
How can I do this: Public can add records, but not edit or view details of previously entered records
I have a "Public" app which allows people to register themselves for events on a calendar. For privacy reasons, I can't allow other people to edit or view those previously registered people. How might I achieve this?
How can I do this: Provide an "Admin" area only available to signed-in user
My "Public" app allows users to register for events on a calendar. I need a separate Admin area only accessible to signed-in users which allows the Admin to view/edit/delete event registrants. Any tips would be appreciated.
Change view based on drop-down?
My organization is trying to decide between QuickBase and Zoho Creator and a question will help clarify if Creator can meet our needs: Is it possible to have an HTML page which has on the top half a set of dropdowns, through which on the bottom half a different view is generated? An example would be: 1) On the top I have a drop-down list of offices that collect donations for a non-profile 2) On the bottom half a different view table is generated based on the drop down selected in 1. Additionally..
navigating through forms
Hi all— I'm contemplating moving to Zoho from Google docs, but I'm stumped as to how to do a basic action. I'm creating a test form for an employee to use when conducting telephone surveys. I'd like to start with a Multi Select question that would navigate her to another page of the form depending upon which option she selects. In a Google spreadsheet this is handled with a check box that reads "Go to page based on answer" and then there is a drop down list of all the other pages in the form. In
Error On User Input Script
I'm having this error, could someone helpme with this? Thanks Error details: Error occured while executing on user input script. Unable to update variable Address r.Address is null r is null This is the Script associated r = Store [Store == input.Store]; input.Address = r.Address; input.City = r.City;
Pasting Graphical Content into View/Form
I need to be able to paste mixed content (text and graphical) into a form field in Creator. I created a test form with an RTF field. I WAS able to copy part of a Internet Web page (formatted text and graphical content)... and successfully PASTE into that RTF field and view. No problem there. When I copy content from an open Word document from the desktop (formatted text, images, graphs)... ONLY the formatted text portion shows. The images and/or graphs do NOT paste. Can you tell me what
new sharing interface bug
Steps to reproduce: Go to "Share / Shared Details" Click on a form/view Share or unshare the form/view with a user Click on another form/view to make further changes The share/unshare/quick invite panel disappears and will not reappear I am using the current release of Chrome (12.0.742.100). Anton
Can I use the /api/xml/formsandviews/ function to list views in applications that are shared to the user?
Basically I create an application and share it with a user. I create a ticket using the user's credentials and try to use the following to list the views in the application. https://creator.zoho.com/api/xml/<application name>/formsandviews/apikey=<application key>&ticket=<users ticket> It returns error 2892: "Specified application name is not valid. Provide a correct one." This works fine if I use a ticket generated from the creator of the application - however I want to list only the views that
Any samples or advice on how to script the following ?
I have one form that has personnel with hourly rate. I have another form tallying the number of hours worked in a task. I'd like to generate a view (from second form) which multiplies the number of hours x hourly rate to get cost for the task. Then this form could sum the cost for the total cost at the bottom. Any ideas of what the best way is to do this ? Any help would be appreciated.
Using multiple forms during user registration.
I am trying to create a solution for registering children for swimming lessons. I would like to be able to split the registration over multiple pages since it is long. I have created separate forms where i collect the parent information, then the child information, then the class registration. Is there a way to pass say a customer id from one form to another? I may change the order to be Child info first that way it is a one to many relationship with childinfo being the "parent" to parentinfo as
Field not updating
For a disabled lookup field ("Problem Field") I set the value through Deluge script in the 'On User Input' event of another field (on the same form). So depending on the value selected in this field, the value in the Problem Field changes. This works fine for existing records. On new records the value remains "-Select-" until I save and reopen it. My app bmpm is shared with support (edit access). To reproduce: - go to tab 'Admin' - open view 'xxxx' - click 'Add' - In field 'Player' select the entry
Error "Invalid entries found. Please correct and submit again." Lookup Fields?
Hi, Everyone I have just completed a database and I am getting the error "Invalid entries found. Please correct and submit again." I am guessing that it might be some kind of problem with the Lookup Fields and the dynamic update I have on dropdown list. Anyone has any idea on how to solve this? Please let me know. Regards, Leandro PS: I have just submitted it to support.
waiting to hear from support
I have submitted 3 support tickets by email over the past 3 days (the most recent is 2 days ago) to which I have not yet had any reply. Should I be submitting support requests in a different way to get a more timely response?
SOLVED: Zoho settings - date format
Hello, I've noticed important and great changes on Zoho account setting. A great option is to have a Custom date format for myZoho Account. I set format to yyyymmddhhmm, this is the standard kind of format in medical bussiness. The problem is that for date fields there is no option to have this kind of format. The date is still in yyyy/mm/dd hh:mm format. Is there a way to have date fields like in medical bussiness? If is not posible through Zoho options could they be implemented through scripting?
Stringlist converting to a string
I have a string list field in one form and when I convert the form a new form opens up and then puts the detail in an html view. I am having problems writing the function so that the item that was chosen in the list appears in the html view. Assistance would be helpful! :)
Group by month
How can I group records by month, ie. "January", "February" etc, and have the records in correct date order? I can derive a new month field, but cannot get Creator to group by it in date order, instead of alphabetical order. DabbleDB does this out of the box...
The same formulas and different view records
Hi there I have a problem with my Form. There are two formulas: 1. minus za ratio 2. obrona minus minus za ratio both have the same expression as below: How is this possible that there are different View records?
Intermittent issue in accessing the views for a section of users
Few hours ago, there was an intermittent issue in some of our applications servers. Due to this, a section of users were not able to access the views. We are now bringing back all the affected servers to normalcy. This should be completed in another 10-15 minutes. Affected users can access https://precreator.zoho.com till that time. We will keep you updated once all the affected servers are brought to normalcy. Charles
Help! cannt see contents, blank pages for Views
Forms and HTML Views work fine, but the normal Views are returned with blank pages. (Firefox, IE / Win XP) They were working fine before but about an hour ago, this problem occurred suddenly. Please help! Thanks!
Today my app all views can't open
Hi Today my app all views can't open,it's system maintain？ Awaiting your settle the problem Thanks Stanley Guo
existing creator form shows blank screen
As of today (although I haven't checked it lately), I get blank screens in the form part (fill-in) of the 2 forms I have created - this happens on Firefox, Chrome and even on internet explorer - i.e. it's not linked with browser type or version. Edit shows what is should, as well as view - I can even see filled in forms when I edit an item, but still, when <i go to the form page to create an entry, all I get is a blank section of page (left pane shows and work) Any idea of what's going on?
Pulling data from another table (UPS tracking numbers)
We have two tables: Open Orders (has a Sales Order # entered at order start) Tracking Data (imported from UPS with the Sales Order # as a column once the order has shipped) Trying to create a view that will list all the line items in Open Orders and pull the tracking number from the Tracking Data table when the Sales Order # matches. Any advice is GREATLY appreciated.
How to properly declare a user variable?
How does one declare and use a non-field variable? I'm attempting to autoincrement a field, using the example at https://help.creator.zoho.com/Auto-Increment-Field-Values.html I receive the error message that the user variable is not a field. "Field x does not exist in the form " Yes the variable is not a field, that is the intent of the example cited for the Auto Increment script. I find no indication in the documentation what form of variable declaration is required. The information provided at
Creating a relationship
I am trying to do this by following your Help at Creating-relationship. When I insert the lookup field in one form and open the "select field" box for the other form, there are no user-defined fields available to choose from. Can you provide any suggestions or more detailed help on this?
Importing from Google Doc Spreadsheet
Can anyone give me some hints as to how I can import data from a Google Doc Spreadsheet into Zoho Creator? -I have tried copy/paste -I have tried downloading as csv and importing that file -I have tried downloading as excel and importing that file None will import the data. (Incase it matters, I'm on a Mac) Thanks much.
Display all columns in form view
In form view I am showing 12 columns. I have more columns. In edit mode I went to COLUMN PROPERTIES, edit NO OF COLUMNS DISPLAYED but the changes to not show. I looked in List, Summary and Grid views but no difference.
Can't create view with restricted records where date field equals null
I am trying to create a list view that only shows records where the date field is null. But whenever I check "Restricted records" and set Datefield equals null and click DONE, the criteria is not saved. How can I do this?
Sorting of foreign names of forms and views
Hi colleges, I've notices that a list of forms and views is not correct sorted. It's can be because of the russian names of it. Is it possible to solve this problem. It's quit complicete to find a form (I have two pages of them). Do you plane to translate your application on russian? Without of russian menu and so on for me is hard to present your application to other users. Thanks, Alex
How do I automatically fill the Link URL for an image field?
Hi I have an image field in a form, and I want the URL link (not the source) to be automatically updated by the input into a separate URL field on the same form. How can I do this with Deluge? I can't see a way of referencing the link box as a variable except for enabling or disabling the checkbox requiring the link. Many thanks for any help. Martin
My form view is blank
When I click on my form link, the form appears to load but the application window is blank - no form loads. The Zoho applicaiton window just displays an empty screen with only the "Insert fields" box on view. After the page tries to load, the IE 'Done' message (lower left-hand corner) shows an error which when clicked says "Grid customised is undefined" I have tried all I can think of with no success, on the other hand, this is my first day on ZOHO. The form must be there somewhere, because when
Make Help link in form
Hi everybody! Is it possible to make a button in form (or some kinde of link) to organize help window. It's quit important for complicate DB (I have already 26 forms and for is already too complicate to remember what each of it for) Thanks Alex
Auto fill from database
I am trying to create an application, I would like it to auto fill in the text boxes if I have information in the database for that category. So if I select X from the drop down list and there is information on about height, weight I would like that to be filed in, but if its missing length I would like the left blank so someone could add that information. How do I do that?
Change text color based on criteria
Is it possible to change the color of the text displayed on a view based on certain criteria? Say, if the importance level is less than 11 could I show that as red text in a view?
Back-up Application
I'm trying to back up one of my applications, everytime i try it doesn't back-up and the description say's null. However, I'm able to back-up other applications with no problems.
Getting an error "Invalid entries found. Please correct and submit again." and now changes were made.
The problem looks like this one: https://help.zoho.com/portal/en/community/topic/getting-an-error-invalid-entries-found-please-correct-and-submit-again I spent the whole day trying to solve the problem. I was creating a new form and I was getting the problem and didnt know why. When I tested over other forms, that used to work normally, and stopped to work for some reason. I need help urgently. I sent a support request already. if possible I would like to have a private support response. The problem
Adding Form Data View email with attachments/images
Hi, I am trying to add form data via e-mail with Images. Each email I will be receiving will have eight images and data about a certain product, I can organize the data to be in any specified format for the email template to work. Using the directions at https://help.creator.zoho.com/Email-Data.html#Overview I can only get the data in the email to be entered into the database. Using this feature, how can I import/add the image attachments automatically from the email into the database? Also,
Next Page