On Click Action not saving
Hello, In my Tool Tracking V2 application I am trying to setup my submit button. When I select the "Action on Click" option of the sumbit button, adn enter the following code it will NOT save. I do not receive any errors when i save it. However every time I go back to verify the code is there it is NOT. form Data_Entry { displayname = "Data Entry" store data in zc = false field alignment = left must have District ( type = picklist values = District_List.District
Inconsistency of the built in 'contains' function on records fetching
I have a form which has a lookup multiselect field having as reference the ID field of another form. This multiselect lookup field is then longlist type. But when I try to fetch a record, something like this SelectedUser = Users [AssignedActivitiesIDS.contains(45465465468465464)]; // AssignedActivitiesIDS is a lookup multiselect field the following error appears The operator :'contains' can be applied only to String or List expression.But an expression of type :'BIGINT' was found In other contexts,
Dynamic Form Selection
Ruben, Thank you for the help the other day on the phone it is greatly appreciated. I am starting this thread as you suggested. Is it possible to use a picklist in a stateless form to dynamically select which form(s) you want to enter data into? Please see the attached image for an example. Thank you in advance for your time, Jason Rapp
Checkbox behaviour
Why can I not produce a graph using data recorded via checkboxes?
WHat is the best way to do this?
I am working on essentially an inventory control application. But we actually manufacture all of the items. When the plant finishes building an item they need to input it into the data base. The plant manufactures many of the same items over and over again. We wanted to have a data base of items that the plant manufactures and this way when they finish a product it is much easier, all they need to do is tie a serial number to the new item (record). Problem is, with thousands of items how can i
Export XML
Hi there, Is it possible (or can it be made possible) to get a full XML export of the contents of a view? The existing RSS export option only contains 25 entries, so it's OK for tracking changes to data, but not for real analysis. I'd like to get the whole view as XML, in the same way that I can get it as CSV / JSON / etc. best wishes, Mo ffg
OpenURL with passing multiple values fails in Firefox and Safari
I use a function, initiated through a view's custom action by row, to pass values from a record to a form. The OpenURL command shown below (values have been substituted) works for Internet Explorer and Chrome, but it passes only the first value (main) to the form in Firefox and Safari. Is there another way to formulate this such that it can work for all 4 browser applications? http://creator.zoho.com/ito_mu/final-mu/#Form:Add_Action_Step?TempMain=,value for main>&& TempSystem=<value for system>TempThird=2.1.5-
jquery and online form conflict
Hi there, I'm using jquery-1.3.2.js for my gallery on my portfolio page. I insert an online form as well. It works fine in terms of sending emails, but when I try to type anything into any input type fields in my forms it doesn't display space between words. When I disable jquery script it works just fine so I presume the problem is with jquery. I spent ages trying to find the solution online, but no luck. I would appreciate any advice. Cheers, Kashka infinitadesign.net
iterations
hello I am new to zoho-creator and i'm working on a small application, just to evaluate the software. Is there a way to automatically add records in a form based on a value in another form. What I want to do is : form1 : has fields : value number_of_occurences starting_date iteration_type : each week, each month, each year so, on add - success, i would like to add 'number_of_occurences'-records in form2, beginning on starting_date and a new record for each week, mont, year... Is there a way to
Getting Error when submitting a Zoho Creator Form
Hello. I'm getting this error when submitting a form. 1 . [t_396699000000776035] Exception occured while setting value in PreparedStatement for the Column [PatID_396699000000800173] Check whether the datatype for this column is given as specified in the data-dictionary .[t_396699000000776035] Exception occured while setting value in PreparedStatement for the Column [PatID_396699000000800173] Check whether the datatype for this column is given as specified in the data-dictionary I've allowed access
Bug with URL Functionality Based Login
I'm making an observation I posted here into a bug report: http://help.zoho.com/portal/en/community/topic/registered-user-subclass Using functionality based urls (Ref: http://help.creator.zoho.com/Functionality-based-URLs.html), the ZOHO sign-in page no longer has a link to "sign-up for free". The user is forced to perform a federated sign-in or leave the application.
Can not delete field
In my form 'Asset' the field 'Assigned_Player' can not be deleted. When I try, I get a message listing various places where the field is supposedly used. But it is not. To make sure, I downloaded the whole app as script and searched for the field name. I found only some views and the field itself. Edit access for support is enabled. Thanks for looking into it. Regards, Filip
View with advanced, multiple criteria.
I've defined the following function to determine the Users that haven't been assigned to a Project. The function browses the Add_a_New_User table for all Users and verifies if each User is contained in the Assign_Project table. If so, the User_Name is added to userList. list lookup.Unassigned_Users() { userList = List(); for each rec in Add_a_New_User [ID != 0] { if (count(Assign_Project[User == rec.User_Name]) <= 0) { userList.add(rec.User_Name);
How may I get my view to show my photograph field as an image?
Currently it shows it only as a filename. Thanks.
Multi-Select for a Transaction Form
Form A Product Price apples 5.00 oranges 6.00 bananas 7.00 etc........ Form B is a transaction with a multi-select (apples,oranges,bananas,etc.) Deluge Script help If a customer were to buy more than one fruit, how could i get the total price of multiple fruit. ex. apples and oranges were purchased, the answer would be $11.00 Thanks for any help.
How to display submitted data?
I would like to show the user the data he just submitted through a form in zoho creator. What is the simplest way to do this. Any help is much appreciated.
One or more fields were dynamically changed
I am getting the following error message: "One or more fields were dynamically changed Try clicking resubmit" What does it mean and how can i eliminate it? It does not happen on all occasions and i cannot figure out why it is happening. I have essentially copied the Site Inventory application from market place into my application. My application is Art Inventory Management 2.0 and the problem is under Consignment Locations -> Consignment Location Edit access to support has been turned on.
How to make serch application?
Hi! I made some data bases in zoho creator. And I want to make serch application on my database. Purpose is some customers could serch something that they want. Thanks!
Backup for Creator Database Fails
I am trying to backup one of our databases, and I consistently get the message that the backup fails. No reason is given. Any suggestions?
Error msg when trying to save code
I am trying to enter the following code into the On Success event of a form: //Populate Sources_Usernames field (used for dynamic views for external users) for each person in input.Source_Player { if (count(frmPlayer[Name == person]) == 1) { recP = frmPlayer [Name == person]; if ((recP.Username != "") && (recP.Username != null)) { if ((sourcesUsernamesStr != "") && (sourcesUsernamesStr != null)) { sourcesUsernamesStr
Problems with Back-up
I have problems with back-up process. It started but it nevers ends. Is any log to see which form, view or script is blocking the back-up process? Any solution? Thanks Sergio Galiano
Update in Creator
Hi everybody, I read the support and it is explain that we can't do a big update while importing data in Z Creator. That's what I want to do : I upload my CSV file and I'd like Z Creator to update old entries (using an ID column for exemple) and add new entries at the same time. My CSV files will be between some to thousands of entries I'd like to know if somebody found a solution. If not, I'd like to know if it is possible for Z Sheet to communicate with Z Creator in order to do my updates in Z
how view can opens other forms?
I have a form Called "Contracts" that have the n° of contract, quantity , client. exemple: contract n°1 , quantity: 200, John..... a contract is delivered in parts contract 1, delivery 1, quantity: 152 in november delivery 2, quantity: 048 in december. I Want to People view All Contracts and them add a Delivery order. -------- I Was trying like this: Made a form called "contracts" with contracts info. Made a form called "Delivery" with delivery info. Made a middle form called
security while sharing application
how can i give limited access to a database application to my users? also how do i stop users to further add users of a specific database
Reports Creator : missing fields
Hello, I have a form with 33 fields. All field are showed on 2 views. When I tried to create a report, the list shows only 27 fields. I can not find out why ? Could you help me ?
Error occured while executing the script
While trying to view company or contact entries using Contact Manager application with only 1220 records, I see the following error: Error occured while executing the script. The execution is stopped since the number of deluge statements that can be executed in an action has exceeded the maximum limit. You can view your usage limits here. My usage limits report: S.No. Particulars Your quota Used Remaining 1 Records Count 100,000 1,220 98,780 2 File uploads and Attachments 7,168 MB - - Any suggestions
___How to "set Email Notification" in VIEW when in EDIT form
Hello, When editing a FORM there is under "More Actions" the "set email notification" when data is submitted and an email is sent out automatically. Can that be done in a VIEW when click on Edit and form pops up for data input... when that data is saved can an email automatically be sent out just as is in the "set email notification"? I noticed the Views Configuration has "More Actions" but doesn't show "set email notification". However, on the left panel under "Actions" / "Custom Actions" can
Preview Email
Is there a way to preview an email before it is sent? We would like to see if everything is included and formated properly before it is sent. Any plans to add a table to an email? This would help keep everything nicely aligned. Herb Wexler www.PreventingMediocrity.com
Move Save Script button to Left on Form Edit
Sometimes the Save Script button is off the screen. Having it always on the left would be useful. Herb Wexler www.PreventingMediocrity.com
api ticket field is blank message?
On submitting my form i got the following message in my log. What is all this talk about ticket field being blank? I assume it has to do with my api settings but everything seems to have been sent properly from creator to zoho invoice and i dont see any problems. This is happening in my submitted grant application. I tested the app a few times with no problems then all of a sudden had this message, not sure what if anything changed. On success - log messages: Record(s) added successfully1879870000000700012010-09-23
Calendar Form
In Creator you have a template for a contact form. A calendar form might be a good idea too.
Settings not saving
Hello, I have started on a new revision to one of my applications. "Tool Tracking v2" In form "RFC 5x5" there are two fields that I can not get my desired settings to save. First field: Description: Unable to save the Initial Value, or the Hide this field to others option. Second field: Part Number:Unable to save the Initial Value, or the Hide this field to others option. This feature is working in other forms with no problems. Edit access is already granted. Please Advise. Jason Rapp
Creator email notification
I created a form on my website for contacts and calendar requests. In the email notification, can i create a script that would add the new contacts to my contact list and add a new calendar request to my calendar?
view mutiple related fields?
I have one form, Called "Contract form" with one mutiple lookup called "delivery n°" the "delivery n°" form have some info like, quantidy, delivery date etc. In the "contract view" with related fields turned on, i cant see all quantidy and delivery date, just the info from one of the many delivery n°. what can i do to see the contract n° and all of the multiple delivery n°& related info? thanks.
delete project
how to delete project ? thx
Data Dictionary Again
3 or 4 times I have encountered these data dictionary errors while working on various apps. Once they occur you can't continue. They seem to clear themselves up after some time. I have asked about what causes them and have never received an explanation. It would be nice to understand if it is something I am doing so I can avoid it, and if there is anything I can do about it. Nothing I do seems to get past it once they occur. 1 . [t_591877000000035043] Exception occured while setting value in PreparedStatement
Easy Edit of fields from Search View?
I have been using and Excel spreadsheet with only 4 colums. Thought it would be easier to switch to a database program. However... When I search records... and get the results... I would like to be able to change a field "directly from the search results"... instead of having to press "edit"... THEN change a field. Is this possible? -Brett
need a sample formula in which sqrt works
Can somebody post a easy sample formula in which sqrt works? My formula sqrt(feldname) does unfortunately not work... SY Georg
Optimizing Creator Forms for Mobile Browsers
Is there a way to optimize forms for mobile browsers? I'm just starting out with Creator and it seems like a brilliant product. I've got a few basic forms that I would like to start using to capture data in the field. I can open them up and use them on my iphone but I have to do a lot of zooming and scrolling. Is there a way to make my forms "recognize" if I am mobile or on a PC and format the manner in which it displays accordingly? Hope this questions makes sense. Thanks! JG
Need help in creating a registration form
I want to create a registration form such that the form opens up on my website. The data has to be stored on my website and I want to send thank you mails to the registered people.
Next Page