Any issues with Zoho Creator and Java update 25?
Some users report data entry issues beginning this weekend. Trying to figure out if this is a Zoho issue or related to Java 7 update 25 which was released this weekend. Data bases which were working just fine as recently as Friday are not now and we did not make any changes this weekend to our tables or Deluge scripts. Wondering if the new Java update is not compatible with Deluge?
Formatting Record in view
Good morning, I need technical information and I can not find an answer. By inserting a new record, I can ask for a verification of those already entered and make them change? Example. I put the record name (single line) double (decision flag) I already have a record (1) entered: name = "Andrea", double = false I insert a new record (2): name = "Andrea". The system can understand that there is already a record with field name = "Andrea" and enter on (1) Double = true? Or write the name field in the
Export field definitions from a form into an excel spreadsheet
We are trying to rationalize two databases into one. I would like to take my primary data entry form in Zoho Creator and export the data definitions including field type, length, drop down choices etc. Is there a quick and dirty way to do this? Thanks
Default Report Page displays Unwanted Records
Hi, can anyone assist me with this one please? When I open a Report page, it by default displays some records, even though it hasn't been specifically searched for. Because people will pay for viewing the records, I would like them to only see what they have searched for and nothing else. I would really appreciate any assistance on this.
dynamic form fields?
Hi, I'm building a form with Zoho Creator for users to register. Users might be from all around the world, so I want the form to offer different pulldown menues to chose from depanding on their input of the My Country field. E.g. if a user chooses USA another pulldown field shows up to select a state - for UK a pulldown menu shows up to select a county etc. It all gets stored in the form data table. I was able to achieve this functionality by the "On User Input" script for Country where I hide or
How can I combine multiple databases into one view
How can I combine multiple data views into one view.
Problems Sharing Application
Hi I shared the forms and tables with users but when they click on the email with the link they received the get a message "You have login as XXX. You are not allowed to access this application" Why does that happen? Help please! The application is ready but I cant use it! Raul
Lookup Import 2 or more fields
Greetings Community, I am having 2 forms , 1 form is customer form that contains 1) first name , 2) last name 3) Autonumber ( unique value ) Data is already imported to this form. The tricky part now, the product form contains lookup field from customer form that contains 1) last name , 2) first name 3) Auto number ( unique value ). No matter what i tried, i can't import anything in the products form when i am using more that 1 fields on the lookup field. When i am using ONLY last name its working.
OnLoad Get Url Variable
I have a view that is filtered using a url variable. Example: https://creator.zoho.com/app/app#View:Contacts?Contact_ID=1159827000001018003 When I click the "add" button from the view header I want the add record form to pop up but also call an "onload" script that uses the Contact_ID that is in the parent window url. Is this possible? All i am trying to do is grab the url variable before the new form loads and pass it to the new form.
Read More Option on Blog Creator
Is their a way to do a read more option on blogs or any type of other features.
More buttons on regular forms
When a form has lots of field I break it into multiple stateless forms with Prev & Next buttons to move from form to form using the openurl statement. Each form reads & writes the data to a Master form. This does work but is complicated. There has been discussions about being able to create buttons on regular forms similar to what can be done with stateless forms. This would give us the ability to use show/hide to mimic several pages. When the user clicks on Next then all the fields from page one
Compare two views, to find an offer to match for a demand
Hey, my name is Jo and I am from hamburg, germany. Thats my first topic in this forum ... At this point I am trying to create a database with zoho creator. I have created 3 Forms: 1. Offers 2. Inventory 3. Demand with the same attributes and the current views. BUT: I want to create a View (or Report? ), which find the best "offer" (offers plus inventory!) to match for a demand and propose this one / show it. I would say, the program has to compare attribut per attribut and try to find accordances -->
Compare two views, to find an offer to match for a demand
Hey, my name is Jo and I am from hamburg, germany. Thats my first topic in this forum ... At this point I am trying to create a database with zoho creator. I have created 3 Forms: 1. Offers 2. Inventory 3. Demand with the same attributes and the current views. BUT: I want to create a View (or Report? ), which find the best "offer" (offers plus inventory!) to match for a demand and propose this one / show it. I would say, the program has to compare attribut per attribut and try to find accordances -->
Zoho Creator to SQL DB
This might be a dumb question but, Is it possible to submit & pull data to a SQL DB hosted at my company headquarters using Zoho Creator. I want to be able to create an application in creator, and then submit data to my SQL database automatically, without having to export/import manually. Also, When i view the report, I would like to pull some data from the SQL database and display it in a custom formatted view (HTML view) Can i do this?
Change text
Hi, I have a field in a form called job_ref. I cut and paste the job_ref from an email. the ref would be say HYG287/1/101 When I paste it into my form I want the / to be replaced with a - can anyone please help. Thanks Nigel
Permalink in new application builder
Hi, how can I get a permalink with no log in required? it seems that this feature has changed with the new application builder. When you follow the "publish" link you get to a new window where you have a check box for a no-login option however this seems to do nothing... Going back to the old builder does not help either as this option seems to be disappeared?... Thanks Luis
Need some information/assistance
I want to know whether there is a way to access Zoho CRM database through Zoho Creator ?
Is it legal to copy a form from another application?
Is it legal to copy a form from another application ? I am thinking that contact form it's a common form widespread across multiple websites and we can create a contact form in our website without to have copyright problems, this thing is applying on any form existing in any application ? I want to copy only the structure of the form and reproduce in my web application (which it's not a Zoho Creator Application) without to take code, style (look & feel) and to add/remove fields after needs. More
Restrict users
How do I restrict users from changing certain fields in a view, while allowing them to change other fields in that view. Any help much appreciated.
JSON API Ignoring filters
I have a view that presents some data to an external software client as json. On the url we filter the returned records using a named column in the view. As of this morning the column we provide is no longer filtering the records and returning EVERYTHING in the view. I've raised a support call but the customer who is using the software client has now had the remaining confidence in Zoho blown out of the water (we had BOTH of the creator outages during the pilot) this morning. The view hasn't been
disable subform
I have a CHANGE HISTORY subform on my TELCO ORDER FORM at https://creator.zoho.com/essistmgmt/form/1696/scriptbuilder/ I have disabled the subform disable CHANGE_HISTORY; I want users to see the CHANGE_HISTORY but not modify it However, when I tested it, users can Add New rows & delete rows. How can I prevent them from doing that but still see the change history?
Create windows folder
Hi, When I create a record, there is a field called job_code. lets use the job code "axg101" For each record I create a folder within windows and call the folder the job code which in this case is "axg101" Is there a script that will automatically create the folder for me and name it whatever is in the job code for that file? Thanks Nigel
view criteria help
I can't figure out the logic to create a view that would show me records that have an ArrivalDate and a DepartureDate that occur on the same date. I need to be able to show Units that where the Guest will depart and another guest will arrive on the same date to the same unit so I can mark them with priority. Example Fieldnames: | ArrivalDate | DepartureDate | UnitNumber| | GuestName Thank very much.
Requirement of Developer Edition (User Edition) in Zoho Accounts.
Dear Zoho Support Team & Developer Community As a Developer, I want to explore my idea in front of you; It is required that Zoho should be start a Developer (user)edition for the Developers, By that way it will be a good support and inspiration for the Developers and also Zoho will be more popular and affordable by the Developers/Enterprises. This same trick is also used by the SalesForce Corp, and today you will be seen that where they are, they have a large community of Developers, and also they
How do I set the value of a check box field
Hi Guys, I have a field Checkbox_1 which has one option call "Yes". How can I set the value of this in script?
USER CAN'T EDIT INVISIBLE FIELD IN A PUBLIC FORM
Hey, I have a public form. Inside this form there are some fields visible and some are invisible. The public only see the visible fields and submit, it's ok. But when my users edit any record, they can't see the invisible fields. I already set the permissions in the view and allowed everything to my users includingthe invisible fields. But it's not working. Help please.. Thanks Mustafa
Upgrade plan & Addon upgrade?
Hi, I have an question but i couldn't find answer. I need to upgrade to have 5000 record. I want to use Add On upgrade but i wonder could i have backup option? Is backup option included for Add on upgrade? KimSonCraft.Com Thanks you!
Set field value to field in a different form
FormA contains a string field (Line1). FormB contains a lookup to FormA (Choose FormA) and a string field (Line2). On success of FormB, I want to use FormB's Line2 as the value of FormA's Line1 For example: FormA's Line1 is null FormB's Line2 is "apple" When I hit FormB's submit, FormA's Line1 is now "apple" I have tried (On Success) FormA.Line1 = input.Line2 which gives me Only SubForm related fields can be updated and FormA[ID == input.Choose_FormA].Line1 = input.Line2 which gives me Improper Statement Error
Zoho Creator funtion Report
Good morning, I am generating a report in Zoho creator and need to create a visualization of certain records by status, status is a Dropdown, how do I make the sum of records by Status? EX: cont ("Status_Orcamento" == "Failed")? And another thing, how do I count the number of records in the view. Ex: Number of requests and requests that is a form. Thanks, sorry I do not speak English.
Automatically match fields in Zoho Creator with Zoho CRM
Hello, I have a table created in Zoho Creator and table in Zoho CRM called "Contacts". Both tables have a field called "company name". I want to import data to Creator from my .xls file and I want to match "company name" field so that it would be possible to click on the name of the company in Creator table and it will open information in Zoho CRM about this company. Now in Zoho Creator table I have the field, which is "Zoho CRM" type. And everything works perfectly as I want, but the problem
Any known issues running Zoho Creator apps on Windows 8 or IE 9?
We developed an application using Zoho Creator. We have over 80 users who regularly access the databases. We have not experienced any problems, but one user who recently purchased a new computer with Windows 8 says that the Zoho apps do not work. She says she is experiencing constant freezes while entering data and slow transition times between pages. Is anyone else experiencing issues running Zoho Creator apps on Windows 8?
Application Settings - Application Custom URL
Hi all, Would you know how the Application Settings - Application Custom URL field can be used? For example I set it to be: demo.mydomain.com? The Application Link field is set to: subdomain.mydomain.com/admin_user/app_name. My DNS provider yells that subdomain.mydomain.com/admin_user/app_name is not a valid domain name. Is there a help page for this settings? Many thanks,
Cannot modify application URL
By default, the application is accessible at a location identified by a URL like: http://creator.zoho.com/[USERNAME]/[APPNAME] Now, the application was created using the above [USERNAME] which is points to a person. We'd really like to share URL that contain our company's name. Here is what we were offered as an alternative: 1. Create a new user, recreate the application using DS EXPORT-IMPORT. 2. Transfer the application along with the data using instruction at: http://kbase.creator.zoho.com/general/publishing-applications-to-another-account
Next URL feature is not working.
When accessed using the URL http://creator.zoho.com/[USERNAME]/[APPNAME], the Next URL upon logging out works absolutely fine. But we've converted the primary account to a domain account, added a sub-domain to point to ZC. So when I use the URL http://[MYSUBDOMAIN].[MYDOMAIN].COM/[USERNAME]/[APPNAME], the Next URL upon logging out is NOT working. -Varun.
Date, Selection or Text from Main Form Fields to SubForm Fields
Hello. I have 1 main form which is unique by date, selection (drop down menu) and the name, in which there are about 5 subforms. How to make so that in Subform the report I saw date, selection and the name of the main form? Now I see only records created in subforms, but I don't know to what date^ group of people (selection) and to what client they concern.
Converting a STRING to a STRINGLIST
I have a STRING that was created from a STRINGLIST, but after the STRINGLIST was reset, I need to go back in and turn the STRING back to the STRINGLIST. Here is my code: input.Extra1 = Extra2.toList(); input.Perm1 = Perm2.toList(); Extra1 is a STRINGLIST Perm1 is a STRINGLIST Extra2 is a STRING Perm2 is a STRING I get the following error: The template variable Extra1 is of type STRINGLIST. But you are trying to update it with an expression of type LIST Any ideas?
Adding text on a form
I need to know how to add text on a form beside the fields. I need to add some text on the begining of a form, when I have to explain something about the form and also I need to add some text below on the form, when a new subcategory of questions will begin. To be more clear I added two pictures when you can see with blue and red the text I need to add. Thank you for your help. Cosmin
Subform Add Row any way to not Add Row based on a condition
Hi in the add row script area of a subform is their a way to "cancel" the add row, say for example the user has entered some data which is the same as the row above, i can see how to alert them using a for each loop but i still cant stop them from adding the row so something like if condition == (don't add row) or if condition delete last row added thanks
html script performance
I've seen several old posts about poor html view performance with complex code. My html view has 1550 lines of code - i suppose that qualifies. The first time the view loads, it takes around 30 seconds. After that, with any change in parameters (it's in an iframe to display data based on dropdown criteria), it's near instant with no performance issues. Any ideas what's going on that first time, and if there's anything I can do to pre-cache it or whatever it's doing? All the posts I found were
Deluge Console
Please, Very ofthen you need to make some queries to calculate, fix or check something in application, make some relinks and so on It will be very useful to have Deluge console - you enter some deluge code (only one line) and get result or make some changes in Application. It's not very comfortable to create every time a new function in script section, run it once and then delete it.
Next Page