Sorting values in a lookup field
I've created a job db which uses job numbers. I have a number of forms that link to the job using the job number. I have set the look-up to sort, but in some forms it's not sorting as would expect - see example below: Job Numbers: J016 J007 J026 J019 J030 J998 J999 J040 and so on... Some forms do sort the job numbers correctly - any ideas? Martyn
error while duplicating application or importing application from a script
Hi, I was trying to make a copy of my application. It says "duplicating...please wait" and then nothing happens. So I tried to export the application as a script and then importing it again via create a new application. Initially it gave me the following errors: 1. If I had anything in quotes in the Notes field of the forms. Eg. Please type your name in "CAPS" It gave me an error on the quotes -- " So I removed the quotes from the Notes field 2. In one of the views I have added a sendmail function
If statement
I need to write the following: If(25 =>24,25-24) I will be creating many if statements and want to use the "easiest" script. Suggestions?
Increase the number of records
Number of records for free user should be increased to 1500 or 2000.
Edit Multiple Records
Well the support team at ZOHO answered my last question quickly, and in a way I could understand so here is a thank you before we get started. I have an application named PRT Collar Tracking, in this application I have a single form also named PRT Collar Tracking. In the form I have several fields for user input. The fields I am concerned with are Collar_Serial_Number, Trip_Hours, Circulating_off_Bottom_Hours, Sliding_Hours, Rotating_Hours, and Total_Hours. I need to be able to edit all of the [Trip_Hours,
Views not working properly in iPad
I am using mobile.zoho.com to access my app, and it works for the most part, except the Views are always showing as Summary no matter how they are configured. I need to view as a List or Grid so that I can use the search functionality to search for records. If you select More Actions > View As > List or Grid, the app just does nothing and remains in summary view. I tested in iPhone and it works as it should. I can see List or Grid. only the iPad does not work. I also tested using Opera mini and
Duplicate entry
I'm a newbie of zoho. I don't know how to delete duplicate in my entry in my look up field. Here is the sample: wood wood apple apple apple My look up field is connected to the my table "Products Sold". What I want is to delete the duplicate in my look up field. Another is in the view of my multi-select look up field. In the table connected to multi-select look-up field here is the sample: Nelson --- barangay A barangay B barangay C The above sample is correct
Add Record via REST API
I'm trying to add a new record to a form via the REST API. I am posting this: <input type="text" name="Title" value="test"> <input type="text" name="Aspect_Ratio" value="99"> to: http://creator.zoho.com/api/xml/copy-of-encode-details/Encode_2_Form/add/apikey=*****&ticket=**** I *'ed out the apikey and the ticket for obvious reasons. The only thing I ever get back is: An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused.
get current url as an initial value?
Hi! I have used countless hour on one simple problem: Is it possible to get the current url as an initial value in a field of the form? I was hoping to have a costumized link on several pages with this format "example.com/zoho-form.html?page=last-page.html" to the form-page, and then have the form automatically detect from which page the request came from. My hope is that if you click on the link from "article-1.html", you'd get this in one of the fields in the form: "example.com/zoho-form.html?page=article-1.html"
Data relation of Lookup field broken
I have a Lookup field ('Import Data') called 'Player_Entity' (on form A), for which I limit the choices available in the 'On Load' event with the following code: //Limiting Entity field choices to player tempValue = input.Player_Entity; clear Player_Entity; Player_Entity:ui.add("Himself"); for each recPE in frmPlayer_Entity [Player_Name == input.Player] { Player_Entity:ui.add(recPE.Name); } Player_Entity.select(tempValue);As you can see in the code, there is a field called 'Player_Name' on the
Access for new update
The next update, which is scheduled for tomorrow, is available in http://precreator.zoho.com . You can test drive your applications and in case of any issues, please feel free to post them here. Change Log : 1. Look and Feel changes in Script tab 2. Edit mode menu items increased to 20 per column and 4 columns will be shown at a time. Regards, Charles
Zoho Creator Pricing - Adding Records
Is it possible to add records to a plan? Each plan has limited record limits. I wanted to know if it is possible to increase records without necessarily upgrading plans? Thank-you.
The code looks correct...
Can anyone tell me why this code isn't working as expected? //1. User Clicks Log Button. //2. Does ID Exist in Log? if (count(tblEventLog[intEventID == input.intEventID]) > 0) { /*2 - Yes 3. Open Log View.*/ openUrl("#View:vwEventLog?intEventID =" + input.intEventID + "", "popup window", "height=100,width=100"); } else { /*2 - No 4. Add Initial Record.*/ insert into tblEventLog [ Added_User = zoho.loginuser intEventID = input.intEventID strEventStatus
Can't find "On Success" FORM ACTIONS help________________________
I created a stateless form and want to "SendEmail" on success but I am not able to include "On Success" action on the right side of the Script Builder screen. I only see "On Load" "Add_this" and "On Click". How are "Form Actions" like On Success added so that I can then "SendEmail" "On Success"? Also, the form that created the table has at the bottom "on Add" and "on Edit". My stateless form doesn't have that. George www.yourbizzwizz.com
simple dialogs to an alert? like [OK] [Cancel] to continue with the script or abort it.
What about adding simple dialogs to an alert? like [OK] [Cancel] to continue with the script or abort it.
forms - if selected, show these and make required
hi, does anyone know if it is possible to create the following functionality in creator forms? - if this value is selected, show these hidden fields and make them required, otherwise hide these fields and make them NOT required - if this is selected, make the next 6 fields NOT required, otherwise, make the next 6 fields required i am considering purchasing if this type of validation is possible. thanks!
edit issue with users
I have added multiple users on my data base. My problem is that the way I set it up requires that my users are allowed to go back into each record and record information. This is considered editing in this app and only I am allowed to do this. How can I allow them to "edit" records? This is for a probation company and we see clients every month. We need to document each and every time that we speak to our clients. I do not want to be the only one that can do the data entry. The only solution that
Close an embedded form.
I am embedding a form in my website. When an employee is done enter data into the form, I need them to close it. Do you have a script for closing the dialogue window? Would I use a button to close the form?
String Function
Can I split a string using , seperator. For eg: str={133,233, 333} Can I spilit it like 133 233 333 as Split() function in PHP
User accounts require registration with zoho??? Why???
When I try to send an invite for a user to access my application it seems to require them to create a zoho account. If so why? I dont want them to have anything to do with zoho. They are my users and I dont want them to have to register with zoho. How can I get around this? this is a deal killer for me if I cant get this to work. I would gladly upgrade my account IF I can get features like this allowed.
change column format view in View mode
How I can change column format view in View mode? For example, I have column (formula calculating) in view mode and it looks like 100324.1234124 and other fields like currency looks like 12000,00 I wondering why there different separator? comma and dot? And how I can change calculating field view format like 100324.1234124 => 100 324,12
unable to see scripts
i cannot see my scripts this is what it shows [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
Update record from Checkbox
I have written some script that dynamically populates a checkbox with records from another form (this works OK). The user then selects the checkbox options of their choice and the following "on user update" script updates the corresponding records back in the other form. This code also works OK but only if the user only selects 1 checkbox option. If 2 or more options are selected then I get the error message "Unable to update data on the form variable". I should add that the checkbox is dynamically
How to format a view or report on a per question basis
Right now the person I am working with wants to see this: Question 1: Campus 1: Answer Campus 2: Answer Campus 3: Answer Question 2: Campus 1: Answer Campus 2: Answer Campus 3: Answer Is there any simple way to do this? Thank you!
DabbleDB closing
Yesterday, the companies involved announced that Twitter has acquired DabbleDB. Customers will get 60 days notice if Twitter decides to shut DabbleDB down, but the early indications are that Twitter doesn't want to be in the database business. They bought the company to get its brainpower, not its technology. I LOVE DabbleDB. My company originally tested it versus Zoho Creator, and picked DabbleDB because it had all the functionality we needed, with better pricing, and an easier user interface. This
Lookup Field and Set Criteria optioin
Hello, I have just started using Zoho creator and it looks like a great tool. Unfortunately, due to mu inexperience with such tools I am already having a problem as follows... I have created 2 forms (Classes and NewCharacter). On the NewCharacter form there are several fields, one of which is Constitution. On the Classes form there are several fields, one of which ConMinReq. I am trying to add a lookup field (called Class) to my NewCharacter form. When I add the field I want to use the 'Set Criteria'
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.
Next Page