When data is entered into a form, how to initiate a lookup field with the value of a field in the same form?
I have a form that looks up (points to) values in second form, and upon initiation of a new record I want to use the value of another field to intiate the selection on the lookup field. However, while I can do it using scripts in other parts of the application--for example on submit for a third form--I can't seem to do it within the on add process for the record itself. I've tried the following formats, marked in red, both in On validate and On success actions: for each x in <formname> [ ] {
Deleted database by mistake ;-< Please help restore
The data in Final Meaningful Use Method form "Objectives2" was deleted by mistake. I urgently need to restore it. Please Help! I did a backup yesterday. Thanks,
Why won't my Creator app be converted to "public" access?
I developed a new Creator app and have requested that it be changed from a "private" app to a "public" app over a week ago. I sent messages to support and they responded by saying the following: a) We need to know your position in the organization? What organization?? I am an individual ! b) We need further contact information on your "public profile" ? They have all my account info with email and phone numbers in my account. What more do they need? Surely thaey don't want a facebook account,
"Duplicate entry '' for key 2" but form is allowed duplicate entries.
While entering data into my product form which is linked with look up fields to other forms, i am getting an error "Duplicate entry '' for key 2" I have checked if the fields are set to reject duplicate entries which they are not and I am still getting this error. Originally they were set this way as this is what i want. However i changed it thinking it would fix the problem, it has not. Also in looking at the fields, there are no duplicate entries. I don't know but maybe this could be related
sign in instead of form
When anyone goes to my form/application they get a sign in page instead. click on red mailbox that says make an appointment at www.icaruscounseling.com The form worked great, it is setup to imbed and actually worked when I was testing it. Help some one please
How to compare values from two differing forms for specific users
Lookups are the main way, as I understand it, to draw values from one form to another. However, there are other times when other kinds of fields hold data that would be useful to link data across forms. For example, take the following forms and values: UsersForm Name EmailID Organization Sam sam@xyz.com xyz Sally sally@abc.com abc SystemsForm System_Name Organization UIO xyz IIO
Cannot access scripting [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
Cannot access action on user input or any other scripting. I get the following error: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' Please help, what can i do? I also noticed that i have a view that i cannot access. I get the same error when i try to access it to delete it. I think its a view that goes to a field that no longer exists. It is the Publisher view. You will see there are two Publisher views. Its the one that is hidden. This is in my Art Inventory Management 2.0 program.
Allow users to add new entries: form doesn't reflect all "on load" actions
The new functionality is good, but the form that is brought up after clicking "Add a <form entry>" option doesn't reflect the actions for "on load." I created a form with a lookup that counts whether a user's login is listed multiple times, and if not that particular field is hidden. This works fine in the actual form, but not when initiated through clicking the "Add a <form entry>" option. As an example: Support has access to the application: Final Meaningful Use Method. The relevant form is
Lookup Fields are Text Fields Now On Mobile
Recently the lookup fields on my forms do not come through as such on the mobile platform. They are text fields instead. Please look into this.
HELP! Error Message keeping me from editing fields
I edited 2 existing forms: "RTO Listings View" and "RTO Sellers View" and created a new view called "Shannon - RTO Listings" Now I am unable to edit any of these entries/fields for these 3 views. All the other views are fine. For example, I go into RTO Listings View, I pick any file to edit, I don't make any changes and just click UPDATE. An error message comes up saying there's an invalid field (which has happened to me before when I forgot to complete a required field)... When I scroll
Return URL
i wanted to knw a couple of things there is this form that i have created now the thing is taht i want to link it to another form in another application then once i submit the form i need it to link back to the previous form which i was filling midway
Export report data to a local file / Print report data to the local default printer
My client has two requirements; 1 - to be able to export data from a report to a local *.CSV file - mission critical*. 2 - to be able to print a report to a local printer in formats other then PDF. *When I say mission critical I do mean that if this is not available then Zoho Creator may not be the correct platform for this client. John Fergus It Management Solutions Canberra
Error in quantities while adding items to form
More than an error it is a "weird" behaviour, since quantities are added correctly to the specified field but randomly another field value is changed. In my specific case, while tempting to modify quantity in "Riepilogo_Alimenti" from the main form "Gestione Casa" ( which is a list of look-up fields with conditionals show/hide on load ) a random element quantity is variated. Specifically, adding one ( 1 ) item to the third last object in Riepilogo_Alimenti causes and increment of nine (9) in the
email autofill
How do i have the email field "auto populate" for a given form taking the email address from a different form?
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
Next Page