Creator - Server Slow and Inaccessible
We've been experiencing off and on accessibility to our creator database. It occasionally moves extremely slow and other times won't allow us to access at all. It appeared that the issue was fixed earlier in the day, but it seems that there is still a problem. We were told that the server connected with our account was going down. Please provide an update as to when we can expect this issue to be resolved.
Access Issue
Access has been hit and miss for the last 48 hours, and now it appears to be totally off-line. Is there a Zoho site that displays service status? PLEASE HELP!
Search functionality using existing forms
Sorry as I know this has been asked a lot, just can't seem to find a simple solution. If I've already built a form inside of Zoho that I use for data entry, can I just use that form (or duplicate it as a stateless form) as a search page? So instead of using the form for "data entry", I now simply want users to be able to use one or more of the data fields there and hit a "Search" button at the bottom which takes all the criteria they entered, search the existing database, then take them to one of
Is there a way to have 2 forms be the same
Is there a way to have information entered from Public Application A to show up in a view on Private Application B? ( and be linked to a form with the "same" fields? I am thinking this might be a way to over come the Internet Explorer issues, since Explorer does not accept I frames Is by having a public application with a form A and then the information gets recorded at the private form B Any ideas on this?
Action on all records?
I see how to define a Custom Action that can optionally be invoked on selected records in the live view. What if I want this to happen without any user involvement other than opening the application or a view? So, I want to invoke an action on all records when a Creator application is opened, or possibly when a View is opened in the application. A typical action would be checking a date field in each record against today's date - if today is later than the date field in any record, another field
Public Access Feature Pending for over Five Days
Why after five days are my forms still not permitted to be public. I made the request last Thursday. This is the message I see when I try to get the web embed code for both my forms: To access the form without login, Public Access Feature needs to be enabled in your account. Your request for this feature is pending.
Can I use a form as a filter to send me to a view.
I would like to create a form that a user can select options. When I push submit I would like the fields that were selected to show in a filtered view. What is the best way to approach this? In my case I would like to select a state and city from a drop down and when the user presses submit have the selected fields filter a view.
how can i create a particular Form View
hello zoho I am create a application in which i am use some formula field, now i want to that when user enter data then after the submit button they redirect to the Form View and in this form only shows the formula fields, the view doesn't contain the user input fields. and please suggest me is there is any way by which i can group together many Fields of View : like the Form View contain - USER NAME USER EMAIL ID USER ADDRESS USER PHONE_NO. then these all four fields are grouped in one - like that
some newbie questions.
Hello, Im a newbie coming from dabbledb. Please let me ask some questions. 1. I have a table with many columns (fields). Is it possible to hide/show certain entry fields to certain users? 2. I have a field that import data from another form with more than 800 of entries. How can I multi-select these data without having to select from a long checklist or drop down? A series of search box maybe. next that appears after a search box is filled and submitted? 3. Is there a derive field functionality?
Can I create a button that mass updates a form?
I have a cash flow tracking form that includes aggregated account amounts. Is there a way for me to create a button for this form that pulls and summarizes account amounts from a transaction log form when the button is pushed or when the form is loaded? If help text exists, can you point me to it? Thanks! Ann
mycheckboxlist:ui.add(...) wipes all design-mode options
When my form On Add On Load executes ui.add(...) to add an option to my checkbox list, it wipes all the options I have set on /edit/ i.e. in design mode. Is a fix planned?
jump to a view
hi i have an app with a form where my employees enter their inventory for our store at night. once they are have completed and added/updated it i want to jump to a view where I have some specific instructions on what to do next based on the data they have entered. how would i do such a think?
ZOHO AND NEW GOOGLE APPS INTEGRATION PROBLEM
Hello Since adding a current Zoho Application to our Google Apps account via Google Market Place, our users are having constant problems logging into our application. The error message from IE is below. The message on the browser screen is Loading....Please Wait Message: Invalid procedure call or argument Line: 114 Char: 25 Code: 0 URI: https://accounts.zoho.com/openid?openid.ns=http://specs.openid.net/auth/2.0&openid.mode=id_res&openid.op_endpoint=https://www.google.com/a/e-qas.co.uk/o8/ud?be=o8&openid.response_nonce=2011-04-19T07:23:10Z-yrzL5ITQsWvSA&openid.return_to=https://accounts.zoho.com/openid&openid.assoc_handle=AOQobUcNrBSAvj9OCwpZTfnZ_itQuj4de1qisuk5v-jw7SG9VqnQfYmTPCUbQs1nuHHeN-y6&openid.signed=op_endpoint,claimed_id,identity,return_to,response_nonce,assoc_handle,ns.ext1,ext1.mode,ext1.type.firstname,ext1.value.firstname,ext1.type.email,ext1.value.email,ext1.type.language,ext1.value.language,ext1.type.lastname,ext1.value.lastname&openid.sig=6LUOx7GsvCyljMQGTAWbmbRfKlH8qSGY+OTVhNIrLhE=&openid.identity=http://e-qas.co.uk/openid?id=104986572590317029791&openid.claimed_id=http://e-qas.co.uk/openid?id=104986572590317029791&openid.ns.ext1=http://openid.net/srv/ax/1.0&openid.ext1.mode=fetch_response&openid.ext1.type.firstname=http://axschema.org/namePerson/first&openid.ext1.value.firstname=rick&openid.ext1.type.email=http://axschema.org/contact/email&openid.ext1.value.email=rick-colton@e-qas.co.uk&openid.ext1.type.language=http://axschema.org/pref/language&openid.ext1.value.language=en-GB&openid.ext1.type.lastname=http://axschema.org/namePerson/last&openid.ext1.value.lastname=colton
Looking for a Developer! Anyone interested?
I've been recently struggling greatly in trying to find the correct individual to assist me in the development of my Creator application. I had a developer I was working with that now just seems to have disappeared into thin air. I'm not ware if any of you have tried seeking a qualified developers' assistance before, but there aren't too many people who know the platform well enough it appears ;). So...... I thought I would turn here to see if anyone is interested? I would ideally like to find someone
How can i create such type of View?
Hello Everybody I am in a problem. i am creating an application that keep records on sales. In my application there are various View and on these there are various Reports. now in a View- Daily Report provide me the all over records of earning from the different locations op the today's date. It have following two fields: Location and Earning this view works well, and the report which attach with it also work fine but it's only provide me details where is sales happened. and if any location there
Boolean search
Hi, I create a search interface, but can‘t search two or more terms, someone knows how to do this? Thanks! Eloisa Puente
HOW TO REMOVE FEATURES Add,Bulk Edit,Duplicate.Delete,Search IN VEIW FORM
HOW TO REMOVE FEATURES Add,Bulk Edit,Duplicate.Delete,Search IN VEIW FORM.aLSO,IF SOME ONE CAN TELL THAT CAN I CREATE A SEARCH FORM FOR EMBEDDING IBN WEBSITE WHERE FEEDING IN TWO ENTREIS I CAN GET COMPLETE VEIW FORM.AND THAT VEIW FORM SHOULD NOT DISPLAY FEATURES Add,Bulk Edit,Duplicate.Delete,Search IN VEIW FORM.oNL YSEARCH OPTION WITH TEXT DDIPALY FOR SEARCH SHOULD BE THERE
Problem breaking up Time/Date field
I am trying to write an expression to count the number of leads set for the current date and say 9am. right now my field is Date/Time. If the Date/Time field = zoho.currentdate and Date/time field = 09:00:00. Any Ideas? Thanks!
Forms not appearing in "Edit This Application"
Hi, hope someone can help. I can't see any of my forms when i try to edit them, in "edit this application". Get the error symbol appearing in bottom left hand corner of Internet Explorer 8. When I click on it, it gives me the following error message:- Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C) Timestamp: Mon, 11 Apr 2011 13:58:50
Hi, help with another look up field value problem
HI there, thank you for your hard work!! How can I export a value from Field1 FormA to another Field1 FormB while still staying in screen at FromA? Field1FormA needs to hold same value as Field1 FromB while still on same screen at FromA I have two Forms Reserve_Ride With fields Number of Seats Total (which is set to 8 as set value) Number of Riders (Customer enters the number of rides to purchase) Current Seats Available (has a formula that has 8- number_of_riders)
HELP WITH ITERATION!!!
I HAVE A SIMPLE ISSUE AND READ ALL OF THE "HELP" DOCS AND NOTHING IS WORKING! I HAVE A SIMPLE VARIABLE THAT HAS MULTI-SELECT STRING OUTPUT. I WANT TO GO THROUGH EACH ROW AND SEPARATE OUT EACH MULTI-SELECT INTO A DIFFERENT COLUNM AND SUMS. TYPE OF ACTIVITY: SELECT ALL A B C RESULT MARY = A,BC JOHN = A,B SAM =A I NEED TO KNOW VIA A VIEW HOW MANY PEOPLE WANT TO DO A TOTAL, HOW MANY PEOPLE WANT TO DO B TOTAL, ETC.
Constraining Format for Time Input
Hi, I'm just having a issue with trying to constrain a input box to only let 24 hour time be inputted, eg; 13:30, 09:00, etc. With the code I have now it output's the alert even if the format is correct. It's probably something really obvious but I have been at it a while now so I'm hoping someone can make me look really stupid Heres the code: In_String = input.Custom_Time; //Gives variable "In_String" the value of Custom_Time inputted by user Number = "1234567890"; //Defines variable "Number" to
Got a neat tip to get calendaring form to work?
Hi there, I would like to be able to set up recurring events through our form, because of it's custom fields. (Would be great if your calendar supported custom forms someday =) Situation Volunteer signs up for an activity. Wants the activity to recurr weekly, daily or monthly. (We will want to limit to 8 weeks to not keep records on hand too long) How to set it up so that records outdated zohocurrentdate are deleted, and current records up to 8 weeks out are generated automatically for the same fields
Help with inventory formula
Hi I have a reservations system set up. There are two forms: Add New Ticket and Reserve Ride Would like to make it so that when customers select the number of riders (up to 6 riders) for a specific record (Choose Date and Time) the date/record stays "Available" until the ride is full at 6 riders and then is "Reserved" Example: (What it does now) Customer chooses record 12 march 2012 at 2pm. There are 6 seats available for that day and time record. Customer selects 3 riders at form Reserve_Ride. And
Help Help !! US Post office address verify
Is there some way to verify that a mailing address is a correct Us post office approved address and will show if it is a street, court, avenue ect. if you dont have this infomation..?
Fine-grained preferences for users working with forms
Dear all, I've been looking for the possibilities that a user of a Creator App can set individual preferences for the behavior of forms, regardless of the specific record he/she is working with. Bear with me: 1 I want a user to be able to tell the application that he does not want that specific 'on load' functions fire. These functions are embedded in a form, but using an if-statement in the form this should be accomplished (for exampe: IF this user has set in his preferences that he does not want
Zoho and Google Apps New integration problem
Hello Since adding a current Zoho Application to our Google Apps account via Google Market Place, our users are having constant problems logging into our application. The error message from IE is below. The message on the browser screen is Loading....Please Wait Message: Invalid procedure call or argument Line: 114 Char: 25 Code: 0 URI: https://accounts.zoho.com/openid?openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0&openid.mode=id_res&openid.op_endpoint=https%3A%2F%2Fwww.google.com%2Fa%2Fe-qas.co.uk%2Fo8%2Fud%3Fbe%3Do8&openid.response_nonce=2011-04-19T07%3A23%3A10Z-yrzL5ITQsWvSA&openid.return_to=https%3A%2F%2Faccounts.zoho.com%2Fopenid&openid.assoc_handle=AOQobUcNrBSAvj9OCwpZTfnZ_itQuj4de1qisuk5v-jw7SG9VqnQfYmTPCUbQs1nuHHeN-y6&openid.signed=op_endpoint%2Cclaimed_id%2Cidentity%2Creturn_to%2Cresponse_nonce%2Cassoc_handle%2Cns.ext1%2Cext1.mode%2Cext1.type.firstname%2Cext1.value.firstname%2Cext1.type.email%2Cext1.value.email%2Cext1.type.language%2Cext1.value.language%2Cext1.type.lastname%2Cext1.value.lastname&openid.sig=6LUOx7GsvCyljMQGTAWbmbRfKlH8qSGY%2BOTVhNIrLhE%3D&openid.identity=http%3A%2F%2Fe-qas.co.uk%2Fopenid%3Fid%3D104986572590317029791&openid.claimed_id=http%3A%2F%2Fe-qas.co.uk%2Fopenid%3Fid%3D104986572590317029791&openid.ns.ext1=http%3A%2F%2Fopenid.net%2Fsrv%2Fax%2F1.0&openid.ext1.mode=fetch_response&openid.ext1.type.firstname=http%3A%2F%2Faxschema.org%2FnamePerson%2Ffirst&openid.ext1.value.firstname=rick&openid.ext1.type.email=http%3A%2F%2Faxschema.org%2Fcontact%2Femail&openid.ext1.value.email=rick-colton%40e-qas.co.uk&openid.ext1.type.language=http%3A%2F%2Faxschema.org%2Fpref%2Flanguage&openid.ext1.value.language=en-GB&openid.ext1.type.lastname=http%3A%2F%2Faxschema.org%2FnamePerson%2Flast&openid.ext1.value.lastname=colton
Zoho Freezing
Hi, Zoho is freezing everytime I try to access the script for Bookings (Raft), and I have to refresh the page to get it going again, cant view script at all. I cant really seem to do much to change it, am I able to provide access so support can take a look? Thanks for any help.
[error] remove characters from elements in a multi select field
Hi, I have stringlist variable (multi select field) containing different elements, such as type1, type2. I had to import excel data in this field and because of input variations I now end up having similar elements but with or without special characters around them: type1,[type1],(type1), type2, (type2), etc. I would like to remove the brackets in the example above (so as to end up with harmonised elements) but I am not sure how to do that. I managed to get the following: for each tobeupdated in
csv reading is unavailable because cells containing newline are not quoted
I want export in csv BUT result is unavailable to read because I have multiline fields. Please, make full compatibility with specification RFC 4180 which use other programs. Csv format details: rows are delimited by a newline cells are separated by comma cells containing comma, " double quote, or newline are quoted; quotes are escaped as ""Zoho Creator are not quoted multiline fields. This is breaks 2.6 of RFC 4180. Thanks.
Date-Time Field
Is it possible to import data into the date-time field. I've tried many times but no luck
Apples Oranges Bannanas Inventory
Inventory Question Example: I have people that want to buy 100 different apples each quantity of apple in stock is 8 Have 100 Different Apples on Form A Form B has Purchase Form with Lookup for the apples on From A How to get Form A stock levels to reduce by number input on field in form B? what are the choices of field expressions to get the stock level of apples to go down and be 0? Can you post some scripts examples?
How do you share DEVELOPMENT with other users?
Sharing applications is OK in Zoho Creator but other users don't seem able to EDIT applications (just data). If this is possible, is there some way to find out who made changes to what and when? Thank you.
Copying data from one field to another in the same form
Hi: I am a new user to Zoho creator. For the most part "deluge" is very intuitive. However, I am stuck trying to figure this out - I have a multi-line field called "Billing Address" I created a checkbox called "Same As Billing" I also created another multi-line field called " Shipping Address" If the user checks the box "Same As Billing". I want the input from "Billing Address" copied to "Shipping Address". How do I do this? Thanks, Ram.
Schedule when records get below any number
Hi, is it possible to make a scheduler so it reminds you when there are below 30 records left. For example I have huge database of bar-code entries which are classified by categories. One category has around 100-300 bar-code entries in it. And I have many categories. What I want to do that scheduler would send an e-mail to me when entries in any category gets below 30. So I know that the stock is low and I need to take an action. Thanks in advance.
Google Calendar HTML View - Broken?
For over a year I have had a link to a Google calendar embedded in an HTML view (so that the users can see their Google Calendar within my Zoho Creator App). All of a sudden this appears to be broken. In Firefox this will just not display and in IE8 I am getting the error "this content cannot be displayed in a frame". Is this a Zoho issue or a Google issue? Is there any way to resolve this?
Formula Field Not Saving
I understand that a formula field will not be seen by the form user - only on the view. However, after I successfully create a formula field in the form editor, then leave and return to the edit form page, my formula field does not persist (and subsequently does not render in the view). Any thoughts? I've tried repeated the behavior in Chrome and Firefox.
Need formula help
I have a field with a number 9 to 12 digit number. the first two numbers and the last three numbers represent a store number and a sales ID. I need a formula to break them up in three seperate fields for Store number (first two digits), Sales ID (last three digits), and order number (middle digits between 4-8 digits). Thanks!
How do I call a function from an expression with current record as parameter?
So I want to do this in an expression field: thisapp.mynamespace.myfunction(currentrecord) But, alas, how do I pass the current record? Cheers and THANKS for any help! And yes, I know "on update" and it doesn't fit my needs.
File upload feature hangs when used to update record
So, I have a inventory app where I'd like to store pictures and update the pictures when needed. I've created a form and used a formula to display the pics in a view using the following formula: ("<img width='100' src='http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Image_Upload + "&sharedBy=" + zoho.adminuser) + "'/>" I pulled this from the KB article: "How to render the images uploaded in Zoho Creator." It works when I'm just adding a record and displays in my default view just fine.
Next Page