Having trouble with Radio Button functions/expression
The 1st two choices of the Radio Button works correctly. But the 3rd Choice is not working. Once Choice Three is chosen it will not allow to be updated should the client decide to correct his choice. If you start with any of the 2 top choices one you can toggle between the two and you will successfully update. If you choose any of the formulas for the 3rd choice they will also update successfully. But if you choose any of the formulas from the 3rd Choice and then change your choice to any of the
Can forms do nested lookups?
Hi all, I'm new, my first post here. I'm trying to do nest lookups, meaning you have to select an option from drop down box #1, before you can select from the next drop down box #2, before box #3, etc. An example, you have to select a country, before you can select a state, before you can select a city, etc. As it stands now, my linking isn't right. If I ignore the first 2 drop down boxes, and click on #3 (city), it shows all cities on the planet. That isn't what I want. Do I have to learn some
Cant update form with getting following error [t_533547000000037895_PIDX] Exception occured while inserting rows
I keep getting this error when trying to update a form. Im using a drop down list. Ive read this issue occuring and made certian there were no fields that did not allow dups and no required fields in the form. [t_533547000000037895_PIDX] Exception occured while inserting rows Failed to update data.
More buttons for actions in the update/edit of a record
First, In a view I've got edit - view for a record. when I click on view, I'd like a print button. Second, when I click on edit I'd like more buttons than "update" and "cancel" we have some custom actions that we'd like to program, like changing a status, or updating a field. Example: Sometimes we just want to update a record or change some thing so update works fine. But sometimes I'd like to change something with a pre-set action, like when a customer picks up an order, we got to the record and
CREATOR - How to CLEAR stateless form data after Submitting??_________________
Please see script for stateless form below. I finally figured out how to update table with stateless form but am not programer and need help. How do I remove the data from the form once it has been submitted AND display a confirmation message like "Your Data Has Been Submitted".... See from at: http://azrealestate101.wiki.zoho.com/GUESTBOOK.html I am keeping it simple so I haven't learn how to do the data field validation. Where is there "beginners" documentation how to build more complex stateless
Search ONLY by Month
Hi everyone, In my zoho creator I hav a application which contains a form and a view with Birthday field. When trying to filter my search for people who born in July of anny year (for exemple), zoho can't match, because it is only searching people who born in July of this year (2010). How can I resolve this? Thanks
Future emailing functions for service of cars
Hi, I am making a preventive maintenance schedule for our motorpool. Is there a way that I can make zoho creator send me an email when my car is due for repairs. I would like to do this via inputting a future date (i.e. if today is jan 1, i will input June 1 as the next schedule for repairs), and then creator would have a function to send me a notification email on June 1. I have been trying to do this in forms (Action on update, action on new), but it seems the action is only on the forms and not
Importing Data
Hi can anyone help please Ok so here is the setup Lets say I have a form callen "customer" with fields called "name", "age" and "telephone number". Now, I want to create a second form where I insert a lookup field from "customer" using the field "name" Here is my problem, how can I make the second form automatically show the "age" based on the "customer" I choose? What I am trying to do is create a database where on the repair ticket, I only have to choose the customer name and other selected
How to make a report that shows a "y" value when an "x" value is input.
So basically i want to be able to have a list of "height" values that the application user can choose from (from a drop down menu or something similar) and a corresponding "flow" value that will result from each individual height value that is input into the application. Any help would be greatly appreciated!! Thanks!
Hide fields/views based on User Group?
Hi all, I have seen that it is possible to hide fields if a user isn't an adminuser. I am migrating from Dabble and need to set up a database for two groups of users -- editorial and production. In Dabble, I created a "Pages" view for the editorial users and made a few views possible through that. I want to hide the fields/views that editorial doesn't have to think about to make their job easier to do. The production team needs to see more fields, will need more views. From my initial understanding,
Edit a single field of a record
Hello!, I´m trying to create a form of 3 columns ("name", "age", "address") and 2 types of users. User 1: (full access) User 2: will be able to modify only the fields of the "address" column of the record only. No editing access to "name" and "age". How can I achieve this?. Regards,
Access to our pre-production server to test drive your critical applications
From now onwards, we will give access of our pre-production server to all our users. This will be useful for you to test drive your critical applications. Based on the set of fixes that has gone in an update, the duration of this test drive will differ. Note : If there are any critical fixes that need to be updated immediately, this process will be by-passed. A new update is now readily available @ http://precreator.zoho.com Change Log "Show All" introduced in the new menu in Edit Mode. It will display
Possible to view notes field and a form view?
Hello All, I am working on a form that has 5 different sections. These sections have titles for example Section 1, Section 2 etc. I used the "Add Notes" field in the form but since I am not adding data for this field it will not show in the forms view. Does anyone have a suggestion that will resolve this? Because of the number of questions answered in the form, I need to separate each section. Thanks for your help.
filtering records...................
for a multi-value field, say values 1 , 2, 3 as options.... how do I pick the records with either value 1 , or values 2 and 3 both selected? How to write this query? Thanks.
Reference Manual
Although the developer guide is o.k., I'd like a reference manual that I can download and print out with all the functions, scripts, examples and such so that I can read it. It is very difficult to find the function or call or object that I need for my programing. A list of what is possible would be super helpful. A PDF would be awesome.
my id been deactived!!!!!!!!!!!zoho team worker in please.......
today i try to login my id but it is in inactive status, may zoho team worker help me to fix this problem? if really cannot restored the id, can you copy the view of the forms i had created in that old id for me(in a new id). that's very important for me please...... my old id's email is ed.hodge1234@hotmail.com
Need help with action button
I can’t get a custom action button to work. I have two tables: Events (parent table) Fields: Event, Event_Date RSVP (child table): Fields: RSVP Date, Name, Email, EventID (lookup ) and its related fields – Event, Event_Date, ID I set up a relationship between the two tables with a lookup field in RSVP called EventID that relates to the Events’ ID field. I created the following function for the button in Events (to show on all records): void rsvp.makersvp (int ID)
Creating Additional Users
I need to set up "Additional users" in Creator. For each new user, they need to have a user name and password. Your help notes are not clear as to how this is to be accomplished. Can you send me instructions are refer me to a link or video? Thanks, Bartley Than
My Formula Field is producing errors & what is the best way to express...
When I use the formula field and input the following: (y_o_main_pts + y_o_comm_pts + y_o_demo_pts + y_o_sni_pts) it saves it this way: (y_o_main_pts + y_o_comm_pts + y_o_demo_pts) + y_o_sni_pts Also I would like to know how to write the foolwong expression: 125 - (y_o_main_pts + y_o_comm_pts + y_o_demo_pts + y_o_sni_pts) = whatever the sum totals
The template variable y_o_snip_pts is of type STRING. But you are trying to update it with an expression of type BIGINT
Why am I getting the error below, when I try to save the formula (noted below in red) in free flow scripts. The type of field is a Radio Button with Two Choices (Yes & No) (I allowed for edit access to support and share to support. The form I am having trouble with is "Mission Score Card" url mislimdb Error in statement at line number 3 The template variable y_o_snip_pts is of type STRING. But you are trying to update it with an expression of type BIGINT Here is the script I am trying to save in
Embedding a form question
I would like to embed a form on our website, but require a login to access the form (it is for our internal usage, not our customers). Is there a simple way to do this? - Thanks, Brian http://www.redpelicanmusic.com
Difficulty with free version. Especially with reports.
I have just started trying the free version and find it not very friendly. Not very transparent. How to make reports out of single records for example is not obvious. This is a basic need in all databases. I know that you are trying to sell the more advanced version but how do I know if this is a common problem with all of your soft ware. Thanks.
Make my app public
It seems the "click here to request for public access" link is permanently not working (Error on page) How can I do to make my app public then? Cheers
How do I change my form to public view?
Adding users and getting them logged in????????
I have added users and made them active. My question is how do they log into our account? Is there something else that I need to do? I can not find a place where I assign passwords. Please fill me in. I am very new to ZOHO.
Application not duplicating
I tried the solutions proposed to another with a similar posting in this forum, but none work. The last option was to export the script and import it. After exporting my application script, then trying to import it again, the process halts with numerous problems. I edited the application as best I could, but it still complained about one function missing, even though I'd cut out the form that asks for it. That particular function working fine in the original application. Help! I'll open the application
How to use a "lookup" to populate a field thats in the same record (Using a lookup to add more that one field to a record)
I am new to Zoho, however I have used another system similar to "Creator" this Caspio. I must say I love your system, very well designed and thought out. Bravo!! I have one last issue I need to solve before my web application is finished. Here is my problem: I have a form that uses a lookup to find another database table and use it for a drop down. What I want to do I pull two more values into this so that both are displayed when I submit. I am creating another form database so that I can find a
Changing column names
I've changed 3 of my data column names in order to "blind" the data. When I look at my Results Page, the column names haven't changed. How do I fix that?
Replace commas as separation for multiple entry fields
Multiple entries in a checkbox field are always separated by a comma in the list views. Is there a way to make it so the separator is not a comma, but something else (a semicolon, for example)?
Functionality based URL's - print - in Functions
Having now spent a few hours on this challenge I ask for some advice. I have succesfully created a function as below that allows me to view more information from a specific record. this idea was taken from a sample and modified for our needs. void print.MoreInfo(int LoadNumber) { openUrl("#View:InboundLoadSummary?LoadNumber=" + input.LoadNumber + "&hideprint=true", "same window"); } The concatenation works fine and I noted from the sample that the ZOHO domain, username and appname were
New url pattern for permalinks?
ZC Team, I saw that a new url pattern for permalinks can be used (and I suppose that it was made in order to fit better with Custom Domain, an important feature that will be available in the future). So, instead of http://creator.zoho.com/<zoho user name>/<application name>/form-perma/<form link name>/<private code> you can use https://creator.zoho.com/showPermaFormHeader.do?sharedBy=<zoho user name>&appLinkName=<application name>&formLinkName=<form link name>&privatelink=<private code> The same
Pivot Chart
Create Pivot Chart With Zoho Creator I have trouble creating a "Pivot Chart". To create a Pivot Chart "select report type as" Pivot Chart "the result is a" Pivot Table "Why is this problem. Thanks www.lentedingrandimento.it il giornale appalti pubblici
A bug in Creator's Reports
Hi, In Creator's build-in Reports (pivot table), when a filter uses a string field value with accented letters (ex: "Réalisé"), which are common in French, saving and using the report fails. This is strange since the very same report created in Zoho Reports (not Creator) has no problem handling accented letters. Thanks
When I set Criteria for a View, the View doesn't apply it
When I edit certain views to filter out criteria, the views don't adjust themselves when I go back and view the application. For example, I have a Criteria set to not display records with the Status Type: "Ongoing," because I only want to see projects, not ongoing duties. It still shows all the records. On the other hand, I have a second Criteria for the SAME view that says not to show "Complete" projects, and that one works perfectly. Am I only allowed one criteria setting per View?
Auto increment in 2 lines of self supporting code.
As long as you have 1 record with a number field that has a number in it, then these 2 lines of code will work: LastRecord = Magnet_Board_Form [ID != 0] sort by OrderID desc range from 1 to 1; input.OrderID = (LastRecord.OrderID + 1); So how does it work? The first line is a "fetch" it sorts all records in form "Magnet_Board_Form" by the field "OrderID" in descending order, then grabs just the top record and calls it "LastRecord" The second line then increments the "OrderID" field of the "LastRecord"
Count function to identify duplicates
I've been using the count function to identify duplicate records from several fields in a form. I've used && between count formulae to indicate each field value must be identical to those of an existing record for a duplicate to be identified. However this seems to have the behaviour of identifying any record that has a field value identical to the one specified in the new record. How would I adapt this to ensure all field values in the new record are identical to one and only one previous record?
How do I use the fetch records variable in zoho creator?
Hi im working on the app zoho application builder and am wondering how to fetch records in a html view in which all zoho users can see. Is there a way to find the amount of employees then make it so when I fetch a record it will show how much employees and volunteers I have in the view. E Industries Inc. www.eifis.webs.com
Attached file Problem
Attached files don't seem to work. They appear to upload, but when you go into the form they are just listed as names not as links to the files.
Invalid Entry -> java.lang.IllegalArgumentException
I created a form which asks for a variety of text, numbers, and picklists, and upon hitting submit I get "Invalid entries found. Please correct and submit again." and at the bottom it displays "java.lang.IllegalArgumentException". However, the record is still added to the database with all of the information.... Any thoughts on what is causing this or how to fix it? I have other forms in the same application that ask for similar information, yet they work perfectly. Thanks in advance Richard
Filter Date Fields by Nil values
I have a form with a date field called "confirmed". I would like to set up a view where results are filtered by an empty or nil value for the date field. I have tried to set custom == "" which failed silently and nil apparently is not a primative construct in the deluge scripting syntax. Is there any efficient way to filter form objects with a nil date field?
Next Page