Functions fired on client side or server side
Hi: As we know, for a database driven online application, usually we write code and the code will run back on the server, but sometime we use script (such as: javascript) which can run on client side. I am a little bit fuzzy on Deluge, I noticed from Deluge help: 'alert' can be used only in 'validate', 'on load', 'on user input' and on click actions (so I suppose it runs on client side). How can we choose or tell if we want to run the code on client side or server side? (for example, some validation
Display field from other form based on other field in form
Sorry; cryptic thread title, didn't know how to call this... I think I saw threads relevant to this in the Forums in the past, but I can't find these back. Sorry. Hi -- Let's say I have four forms : - Projects - Dates - Tasks - Users Basically, When I enter a new task, there are mandatory date field + project field. Then when I assign a task to a user, I would like to be able to retreive the corresponding date and project for this task in a user view, for filtering/sorting, without having to manually
Limit the # of Formulas in a Form?
Is there a limit to the number of Formulas that can be included on a Form? I have a form that has 13 formulas, and I have tried to add another one, but no matter what formula I put in there (I have even tried to copy other formulas already on the Form that are working) it keeps disappearing. I will put in the formula, and click "Done" and it will save and appear in the screen. But when I go to View to try to add it to the View, it has disappeared, and when I go back to the Form, it is no longer
How to add Data from a record in a form to HTML view
I want to add data of a record in my forum to a HTML view. I am using following scripts htmlpage HTML_Test1(Ref_No) displayname = "HTML Test" content <%{ rc = Shipment_Details [Ref_No == input.Ref_No]; }%> when I test this script in the preview it works fine. But when I access this view I don't get any result. Can anyone help me with adding data of a record in a forum to HTML view. Ashish
Newbie Question - Group Sort by related field
I would like to be able to group items in a view in an order that is not alphabetical. Is there any way to do this? I was looking at the map functionality. is this the correct method? Also, is there an app that uses map so that I can try to understand it better? Thanks in advance
Else statement is not working in HTML view
I cannot seem to get the else statement to work in this view. The if statement works fine, just not the else. Thanks for the help. htmlpage Approval_Form(pAccountKey, pOrderKey) displayname = "Approval Form" content <%{ account = Accounts [ID == (input.pAccountKey).toLong()]; order = Orders [ID == input.pOrderKey.toLong()]; services = Order_Service_Charges [Order_Key == order.ID]; billing = Billing_To [Order_Key == order.ID]; shipments = Shipments [Order_Key ==
Custom HTML Forms?
Hi there, I was wondering how would I be able to create custom HTML forms rather than use the form builder? I'm a web developer and find the form builder extremely limiting. I would like to do simple stuff like this: <div> <label>Firstname</label> <input id="firstName" type="text"> <label>Lastname</label> <input id="lastName" type="text"> </div> Is there a way I can do that? I find the default forms layout (table based) very limiting as it doesn't allow for better use screen space.
Changing Location Of Filters
Hi - Is there a way to move the location and layout of the search filters on a View? For example, can I have them appear on the left-hand navigation rather than at the top of the grid? Thanks for the help. JL Scott
how to check if it is a number in a field
Hi: What is the function that check if user input is a number, something like: If (isNumber(Input.NumberOfItems) == true) Thanks.
Adding a record count
Hello, How can I add a record count on this application (I've put it on our website)? Thank you, Lisa
Form Layout
I am new to Creator. I need to create a form that will be used for data input. I know I need to create a stateless form. What I am finding is I can create a form that list the fields I need in a linear fashion. Example: First Name Last Name Street1 Street2 City State Zip Company Job Title I would like my form to look more like First Name Last Name Street1 Street2 City State Zip Company Job Title How can I get my
Free-Flow Scripting is DOWN!!!! (in firefox)
this problem started in the last hour... it is a firefox problem
Database structure + dynamic fields
Sorry about the topic title, I wasn't sure how to call this. I've got Parts and Sequences. Right now these are two separate tables/forms. Each part has got a title and a number. So for example, I've got 7 "plumber" parts + 75 "deputy" parts. Each sequence has got a title. Relationship is PARTS n <----> n SEQUENCE I need to assign parts to sequences, that's easy as I can display checkboxes in the sequence form using a lookup field, BUT, I would need to be able to assign an amount (number) of each
Variable Declaration
Hello, I was able to get the show/hide fields to work with a check box. Now when trying to show/hide fields using a drop down box response, should I claim the variables at the beginning of the Form Definition? I know they are localized instances, but in declaring them onload, will I need to also declare them at the instance point? Or would it just be the reference in the on input if/else? Thank you.
Server speed..
Anyone else getting really slow ZC performance? Given popularity of ZC and it's Herculean feature set I'm gonna assume there's going to be slow times but this is pretty bad. It's not my internet connection. Any reports of things going on?
Issue with Importing Excel or CSV
Having an issue in Creator where I cannot import data from a file. I had played with this yesterday, and everything was working fine. Today I am continually getting "contact support" error messages. I have simplified my imports to literally one cell of data, I have exported from Creator and tried to reimport the same data format (ie, put in different information), but it continually errors. Any ideas? Thanks in advance! R~
Zoho forms - Changing Form action from Add to Edit at run time
Hi, I'm facing a problem. We have list of contacts can be add / editable. We also have a unique field Email. When some one enters the same email next time, Form should be going to editable mode. That means update mode. Any idea how to do it ?
Importing Data into Table View: Date Format dd-MMM-yyyy hh:mm:ss does not exist for date/time fields
I have a field (column) in the time and date format, e.g. 26-Oct-2010 11:30:00. If I export as .csv or .xls and re-import immediately without modifying the file I am unable to import the time because the option "Date format for the column(s)" doesn't list dd-MMM-yyyy hh:mm:ss, it only lists dd-MMM-yyyy. This fix needs to happen fast because I have a lot to import. thank you.
when do I need use: "input." and when I shouldn't
Hi: Can you let me know when I need use: "input." and when I shouldn't use that? For example: input.Today_Date = zoho.currentdate; //this is correct. (get today's date and show on the Today_Date Field) disable input.Today_Date; //this syntax is not correct. disable Today_Date; //this is correct. (set this field read only). Thanks
Blank field not shown up
I would ask if you can assist on how to show up records that have blank field if this field is set as criteria.
Zoho Creator help for a newbie: Form View
Hi all, I'm very new here. I'm attempting to build a database that has some simple category information (location, date, subject) by radio choice in addition to a large rich text block. I'd like to rich text block to be searchable by users. However, the only way I can seem to do this is to have the text appear as a column in the database view, which makes everything quite unusable because the entries are so enormous and the entire text is shown. Is there a way to gag or hide the big text column,
Visualize database structure (forms ans relationships)
Is there a way to visualize the database structure of an application? I would like to be able to show the forms, their fields and the relationships that exist between the fields.
Delete function no longer working and Java script error on page all of the sudden
I have a function in my commission tracker application that is a delete detail function. It worked for a few months and all of the sudden nothing happens when I push it. I am also noticing all of the sudden that I am getting a java error on page message at the bottom of my IE7 window. Any ideas? We use this app everyday so any help would be appreciated.
dropdown list items contain value and text?
Hi: As you know, dropdown list (for example in VB, MS Access, .Net, and other...) items can hold value and text, "value" usually is a number, and "text" is the text. Is the dropdown list in ZOHO Creator has similar feature? Thanks
Thanks ZC Dev team. Chaining is finally working great!
Thanks ZC dev team for returning this on your methods! Chaining is working great! I recommend everyone use chaining for more eloquent DS. t = store.get(key).toMap().get("timestamp")
Multiple user logins?
I'm new to this and am confused about setting up users. I have shared our app to two employees internally and one client externally. I had assumed that by adding their email to the users list, the email would be their user name. But no, they all must use the same user name and password to log in. If that's the case, how does Zoho even know they are separate users? If anyone on any computer can log in using the same user name and password, what's the need for sharing the application at all? What am
How can we create reports with Creator?
In creator I able to have view but I would like to create a nice costumized reports. Any suggestions?
Error
Hello, I've identified one posible bug. It happens whenI am inside a Html view with an Iframe inside,and this Iframe has another html view inside itself, that has one view with a custom function. When I execute this custom function it opens a #view in a pop up window. This pop up view has a custom function too that if I execute it, then it refresh itself but duplicating the pop up. I dont know if I explained myself Sergio Galiano
Automated Multi Select Choices
OK, I have an existing customer contacts database. I now want to log notes from visits to my customers. This will obviously require a new form, however I want to be able to select data the "customer name" field of my customer form in a drop down menu on the new notes form. Is this possible? Thanks
Quick tip on using JSON data resources & sharing records between apps.
Howdy, Just thought I would bring this to your attention. If you don't know this already when you make a getURL/postURL request to a JSON resource Zoho allows you to convert that JSON to XML using toXML(). BUT, did you know that you can convert it straight to a map var? This is especially useful when you just want to grab one single JSON record to populate an html page or form. Example : Let's say that you want to grab a SINGLE record out of a separate app in the same account. The traditional
How to display a warning of a possible duplicate entry?
Hi, Creator is looking very good as possible solution for us. I know how to prevent dups, but would like to ask about a different scenario, please. We are using a form to enter requests from individuals. We will only allow one request per individual, but there will be times when two different people might share the same last name. Is there a way to display a notification of a possible duplicate entry? That would allow the data entry person to check for previous requests. If none are found, we would
Creating A New Records Via Scripts
Hey Zoho People, Am trying to create a new record on a different table by picking entries from another table but its only creating one field,and I want it to create many entries on a given criteria,but its only picking the first record with that criteria....Please Help me on how I can populate the table with all the records fitting a certain criteria..Thank You.
How to send form by email based on a field value - please help
Hi I have a really simple form with about 10 fields. I would like to receive an email with data input in the form only when the form is updated and a certain field has been updated to "closed" instead of "open". I have looked in the help section on scripts but cant figure it out. Can you help? If yes, I will email you a direct link to the form plus the login and password for you so you can add the right script in my form. (I will change the password afterwards). I am sure it is a 1 minute job for
Record Collection Tips
If anyone ever sales they've never written bad code they are either lying or they are God himself. I starting using Zoho in Feb of 09 and like almost everyone that comes to Zoho Creator; I was looking for a way to make my business processes better. This led me to the wonderful world of Deluge Script! I would like to Deluge Script learning curve, well, less curvaceous for many of the new DS'ers out there. One aspect about Deluge Script that I immediately picked up on and enjoyed is how you do looping
Creator: The application copy did not copy the drop down choices
we made a copy of an application. The original app had some drop down boxes and people would select from a list of choices. our copy of the application has lost all of the drop down lists.....nothing appears in the drop down box. can you help?
download a file when you submit a form
I am trying to create a form which will help my customers to download a pdf file when they hit submit button. I validated the form using the get url and when tested the pdf file won't open. could anyone say how to correct this?? Thanks
Import Data Dropdown - if condition
Hi, I have a form&view (A) with several universities, professor name, subject and class. Then I have a second form (B) In whic I want autofill with this data. So I create a form with Dropdown that Import Data from the University field (A). When people choiche the university, I want that appear in another dropbox field that I create (in B) only the subjects of the university picked. People pick now the subject and then professor name, and class autofill. How I can create the script that allow to
Single Line Fields: finding a string in another (comma separted) string
I have a single line field that is hidden from public view. It contains a string which is a comma-separated list. I want to check if a given string from another field is in that string (the comma separated list) . How do I do this? test_data = Form[RecordID == input.RecordID]; //get the record to do this operation temp_string = testdata.String_Field; //gets the value of the string I am looking for temp_comma_list = testdata.Comma_Separated_String_Field; //gets the comma seperated list so suppoose:
Changing the language of notifications in a Form
I am creating a form that will be in spanish, the problem is that there are certain notifications zoho sends that do not appear modifiable. For example, under the verification code picture it reads in english "enter the characters you see in the above picture", how can I change that note? Another example, when they fail to fill out a required field there is a notification "Enter a value for <FIELD>"... can a change this notification? Another example: if the don't enter the verification code, they
Header Menu
Hi, I wonder if it's possible to hide the Header Menu in a view...not the zc_Header. I mean the Header with the name of the fields of the form. Its any zc_HdrMenu=false????? Sergio Galiano
Next Page