Use a String-list rather than multiple "OR" statements
The question I have is if I can make an arbitrary string list: ZOO={"cat", "dog", "bird"} And reference that against a database: For each row in DATABASE [ZOO.contains(animal)] { //some code } ...would return true if the animal column is cat, dog or bird. I cannot figure out how to do this, or if it's even possible. The only way I know how to do this is using lots of OR's, and it looks inefficient: for each r in DATABASE [((animal == "cat" || animal == "dog") || animal == "bird")] {
Empty second column displayed in form
I have a form in my application ('PlayerEntity') in which I moved all the fields from the right side/column to the left side of the form. When I edit a record the second column still displays. Except for a text in a field of type Note that streches accross both columns it is empty. Can you do anything about this? Regards Filip
Criteria-based URL Redirection On-Load Briefly Shows Form
Originally posted here, and now re-posted as a separate bug to track. Problem: If a form's on-load script has an IF statement that checks for some criteria (i.e. date-time, ZOHO signed-in user ID, IP address, etc) and performs a URL redirection based on this criteria to some other page/form/view, the original form flashes for a second before the redirection. Issue: I can stop the page loading to prevent the redirection thus exposing the form. Also, the application just seems unprofessional by briefly
Help: Field values disappearing
Hello, I have a form A in which the name, registration number and other details of a student are stored. I have another form B in which the name and registration number are imported from form A and marks of the student are stored. I have a grid view based on form B in which I take the imported name and registration number from form A, and the marks from form B. As a result, in the view, the name and registration number are "non-editable" [since they are imported from form A] where as the marks are
User access to html view popups?
My app offers user to view records in a nicer way (custom html views) than the regular Creator table by providing links such as follows: https://creator.zoho.com/filip.aulin/myApp/#View:myHtmlView?zc_LoadIn=dialog&recID=1234 When I am logged in as an admin it works fine. When logged in as a user the popup seems to get redirected and shows the 'Home' screen. Is there a permission setting I missed? Thanks, Filip
Bug: Function is not being recognized in HTML view script save, though it is a valid working function
I've actually seen this same problem in different contexts a few times in recent days, and it's back now, so I'm reporting it. I have a valid working function, in this case named "getDayOfWeekName()" I'm using this function in an HTML view named "Dashboard" Loading up the Dashboard script into the editor, attempting to Save Script (either immediately or after modifying the script) will result in an error message about the getDayOfWeekName() function not being valid. See below: Yet, the function
PDF and PRINT buttons in HTML Views fail with bad URL
Definite Bug: Selecting Print and/or PDF options in Header Options of HTML View... ...makes the PDF and PRINT buttons appear in the live view of the HTML View... ...but, when clicked, both buttons send you to a malformed URL, thus no pdf or printing functionality. Please advise when this has been repaired. Thank you, Datazen1 datazen1@gmail.com Santa Fe, New Mexico US
Unable to access form for editing
There are only 2 forms in my app. I performed minor editing on one of them but cannot access it again for additional editing. The fields in the form shd appear in the right-hand side of the screen but instead it is BLANK. The left-hand side appears normal. However the 2 associated views appear normal and contain the chgs i made previously. Apparently the URL contains a digital code to determine which form or view is to be accessed. In my case the digits '15' cause the condition described above. However
Viewing records: Can I replace the standard table with an html view somehow?
Especially for views with many fields and/or fields with text in them, the standard table that pops up when viewing a record is not very readable. I would like the 'View' link (to the left of each record in a view) to open up an html view (which I designed) containing that records information. In order not to confuse my users, I do not want to include a custom action which will be triggered by a button to the right of each record. Regards, Filip.
Sending email from a filed
On a form I have a filed "votre_courriel" where people enter their own email in order to get some feedback from the application. For some unknown reason it doesn't work. I've used the "set email notification" screen and used the varaible name given by the input form still no go! the yahoo account gets the email but not de variable account Can you help Alain Montreal,Canada
A profoundly difficult weekend w/ Zoho Creator apps bugs and poor network accessibility
This has been the weekend from hell as far as my interacting w/ Zoho Creator. I had much to get done, and instead spent the weekend running in circles of desperation. I am a very experienced Creator coder and app developer. I know what I'm doing in this realm. And, I'm trying to start a new business using Creator as the core platform, and I have clients awaiting prototypes and modifications. I have a training to give to the staff of one client tomorrow -- but some of the main Creator-driven
Bug: View is displaying duplicate columns that don't belong there
I have a new view that is displaying duplicate columns. This view was a duplicate itself of another form. The original form is called Message Board, and the duplicate form is called Feedback. It is the Feedback view that has the problem. This view shows a strange inverted repetition of the 3 intended visible columns: There are only a few fields in this form/view, as seen here: Editing the view shows that it only expects to display 3 columns: Which is further confirmed in the column properties:
User security / permissions
Hi, I'm sure this is straightforward, but I'm afraid I'm stumped on this one! I'm building an app that would have one or two "admin" users. These users would be responsible for adding / deleting / editing records in the database. They would have special screens that only they should see, for making changes to the data. No-one else should be able to see these admin screens, or be able to modify any data. But everyone in the world should be able to view all the data in the system. The public, anonymous
How to view Records 1 by 1 as a Form that I design - that looks like Data Input Form?
We have our data input Form designed and some data entered. Now we want to review the data record-by-record or lookup records but it seems like... a - We can only see the data in rows... one record per row... b - or as a single column... Question 1: Can we not drag the fields to anywhere on the screen we like so a record may look something like this... Company Product City State Phone Fax etc etc Question 2: The above has fields from a single record
Tables, how to do?
I would try to develop an application using this program: is it possible? I know visual basic for application and access 2007, but I woul create a on line application. Is this a proper tool? and how to learn? books, articles etc? Thanks martino
NEED SOFTWARE CREATED FOR BUSINESS
Scenario:1.) previously registered customer comes to our website or 2.) receives email with link from us that takes them to a web page with 50 bits or information that represents 50 of our clients. the customer picks 6 things they want. the 6 things each have a code. the customers username and the codes associated with those 6 items are LINKED/MATCHED with the correct clients and sent to only those clients through encoded/anonymous/temporary email. the client receives and is able to view the customers
How to get around requirement that view containing images for website must be "public" view accessible by un-logged-in users
I've setup the home page on a website (here) to display images that have been uploaded to a Creator form/view called "Images". But in order for the images to display on the home page, I must make that "Images" Creator view "public" -- because leaving it private does not allow the images to display on the home page. I suppose I understand that. However, it creates a serious problem, and hopefully you can advise me on a work around... The client organization must log in to access several Creator
openURL delug task doesn't work
when embeding a view for Blogposting with Google,I noticed this issue, openURL doesn't have any effect for options "new window","same window","iframe"... only popup window works,even that sits with-in Parent Element ,where User has to scroll left and top to see results. How to solve this issue demo: http://zohocreatortest.blogspot.com
Parse HTML 4.01 Transitional as XML?
Is there any way to getURL on a page that is HTML 4.01 Transitional, and convert it to XML to use XPath? Or is the only way to parse it as a string? Thanks.
BUG: Publishing Creator app to Client with "Source" set to "No", client can still edit source!
When I publish a Creator app to a client, and indicate "No" for "Publish with Source", when the client receives the application, he can edit the application! This is a bug. See the following screenshots: 1. Here I've published to my client (w21data) with "Source" = "No" 2. Here, the client has received the published app, but has Edit options! (clicking Edit allows for Source changes to be made by the client). THIS IS BAD. A bug. I have shared the target application to Zoho support, on both
New Entry Not Being Selected in Picklist when Passed in URL
If you have a picklist which is not a lookup that is a listbox, radio button, checkbox, or multi-select; the entry is not being selected when the entry is being passed in the URL, unless the entry existed at the time the form was created. This problem does not occur if the picklist is a lookup. For example, suppose you have a listbox which is not a lookup named LISTBOX that has 2 entries named A and B that you added during edit mode when the form was created. If you use the ui.add() function in
Cannot not open On Edit On Success script
I cannot access my On Edit On Success script for my application: http://creator.zoho.com/carlgifford/vacation-rental1 Form: Rental_Agreement I just cycle with "Loading" message. Can this be fixed? I have a lot of work completed on this form! Thanks for your assistance! I have shared this application to support: http://creator.zoho.com/carlgifford/vacation-rental1
Federated Login option showing even if set to "No" in Application Settings
As the subject line says, my application is still showing a Federated Login option even after I've turned it off in Application Settings. See the following: 1. I've set "Show Federated Logins" to "No" for my application 2. But, attempting to log into an embedded view of that application still shows the Federated login options. I do not want the Federated Login options to show. Is there something I'm missing? Thanks. Please advise. Datazen1 datazen1@gmail.com Santa Fe, New Mexico US
Can a view criteria use comparisons with data from a record in another form?
I'm trying to set up the criteria for a view based on fields in a record in a separate form, but it seems like you can't do that. I've tried everything I can think of. Is this possible? How would you do it?
automatic creation of records
hello i'm new to evaluate zoho creator. I was trying to add records automatically in a table, according to a record in an other tabe. Ex : In formA user selects a number for 'recurring amounts', a start date and an iterator ( day, month, year ) : up on these values, a certain number of records should be generated in formB. I didn't find the way to do that ? ( seems like for-next, or do-while constructions are not available in zoho creator, am i wright ? ) Somebody have suggestions thanks frank
Placing Button on Form
I somewhat new to the developer side of ZoHo Creator .. so maybe I just can't see an obvious thing .. but .. How can I add a simple button to a form to spawn off another web page? -bob
Single Line Text fields showing as multi Line
Noticed this morning that when editing the definition of a Form ... if I click on the Edit this Field link for a Single Line Text field, the resulting popup form shows the current value for the dropdown labelled Field Type: as Multi Line The visual for the field is still for that of a Single Line Text field ... but I am concerned about making any changes (to other properties of the field) in case it corrupts Client's Application data. @ZOHO Creator Team ... please investigate and advise ... - when
Converting a date/time string to the right Zoho date/time format
I have a date/time string in the format of "2010-08-01T18:07:22-06:00". I'm trying to convert it into a date/time variable in Zoho. I'm using the .toTime() function on the string like this: datetime = datetimestring.toTime("yyyy-MM-ddTHH:mm:ss")When I execute the script, it gives me an error that it's "unable to update variable datetime." So there is an error in converting the string to a Zoho date/time. I'm thinking it might have to do with the timezone on the end of the string (-06:00), which
Zoho Invoice is make with Zoho Creator?
Are all types of forms, lists, features that can be seen in zoho invoice can be done with Zoho Creator? Thaks for all.
Function Insert into
Hi, I have script which insert the data in to different form when condition happened, from last two days it stop working, i have gone through the script, it's fine no change has been done. Please do the needful. I have already allow access to support. my form name to_do_form (application penta_crm_10). Script start from line no 115 to 141. Comment // Auto Cash Entry in Finance Thanks.
Zoho Mail add on for Zoho Creator
Hi We have just developed a CRM in zoho creator. We want this CRM to manage emails like the zoho mail add on does in zoho crm, can this be done, if so how? It must be possible if you guys have been able to integrate google apps mail in your zoho creator helpdesk
Does Zoho Creator support Regular Expressions?
I need to parse an XML feed, but I need to use regular expressions to filter out the data I need from the XML, as it is spread throughout strings. I need to apply regex in conditional statements to get exactly the data I need out of the strings. Does Zoho Creator support Regular Expressions? If not, how might I get precise patterns of data out of a string in XML? Thanks.
Error: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
Hi, I have sent this message once before, but cannot see a record of it, so I apologise if you have received it multiple times. I am receiving the following message whenever I try to access the scripts tab in Creator: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' The error occurs only with one of my applications, and I think it is related to a problem with a view "Send midday messages" (not "Send Mid Day Messages"). I accidentally removed all columns from the view, except for a related
How to manage users in a Creator application
Can anyone help me find out how I can mange users in a Zoho application I have a time management system and I need 3 levels of authority (e.g., User, Supervisor and Admin). When a User logs in they can only see their tasks in the appliaction and update their tasks and they can't say run reports in this application. When an Admin signs in they can see all the tasks of all users in the application and they can run any report they want. How can I create these different levels of user and allow them
User application
Hi, how can i upload user application in Zoho ? Once done, are they running even if i disconnect my account ? Thanks Massimo
Mac Safari and Chrome browsers remain unusable in Creator's Free Flow Editor mode due to text artifacts (images included)
As seen in the screenshots below, Creator Free-Flow editor cannot be used in either Mac Safari or Mac Chrome due to uncontrollable text artifacts in the editor window. Works fine in Firefox, but sometimes I need to use Safari or Chrome. I know this problem has been reported a good while ago, but since Safari just released its 5.0 version, I did a fresh test. datazen1@gmail.com Santa Fe, New Mexico US
No data available
Hello, I copied an application and then imported data into the application. The views are functioning fine but the reports are saying that there is no data available. Is there a time delay between importing data and when the system will index this data so that reports will function? If there is such a delay, what is it normally? If no such delay, would you please assist me? Dion
How do I edit my Forms for the database function when it suddenly disappears?????
Hi, I apologise for lack of detail I'm new to the world of Zoho and have limited computer skills! I've recently created a database on Zoho Creator using the form to create a user friendly application. The application is working well but for some reason I am no longer able to edit the original form - it doesn't appear to load it anymore. Does anyone have any suggestions as to how I make it spontaneously reappear? Many thanks in advance! Ben
Uninformative error messages
Sometimes when submitting a form, an error message that provides no useful information is generated... see example below. I'm not asking for help w/ this particular error -- I can muddle through solving it -- but can't Creator be made to always provide some kind of info about any given error so it's not just a vague uninformative error message? Surely at the time the error is thrown, the compiler knows what threw the error, or at least some contextual information that would be useful. Thanks.
Want to disable a view for a form
Hi, I am developing an application where in only two forms are involved. I need only one view and want to disable the other. To say, if the first form is the place where entries are made, then the datas needed to be stored in the view. The second form will display the datas from the first form with few manipulations from the view on load. Here I am not able to proceed.
Next Page