if input doesnt exist - I get an error
I get an error: Error occured while executing the script. Unable to evaluate if/while Condition If the input is left blank. I want the user to input at least three characters I'm using this: <%if ((input.searchStr).length() > 3) {%> We have three <%} How do I change the if statement to see if input.searchStr exists at all? Thanks, Dan
Form not loading
One of my forms won't load! It just sits saying "Loading Dancers..." (Dancers is the name of the form). All of the other forms will load just fine. This is a new problem, and I've made some changes to the form, but nothing that major. What do I do? The form will not load. I've tried restarting my browser, but that's not doing it. I've also tried refreshing the page. Any ideas?
How to Create a Summary Page based on the data entered Without Replicating each name and getting the Sum of each person
Greetings. I am in the process of finalizing a vacation / sick leave tracker and just need one more thing. How can i list all of the names of the people who submitted a leave request and get the total # of days (a field in the form) without replicating each instance of the names of the people who applied for a leave. Here's the formula i tried: <%{ for each x in Create_Leave_Request {%> <tr> <td> <%=x.Name1%> <td> <td> <%=x.of_days_applied%> </td> <tr> However, what it does is it list
How to Create A Summary Page
Greetings. I am in the process of finalizing a vacation / sick leave tracker and just need one more thing. How can i list all of the names of the people who submitted a leave request and get the total # of days (a field in the form) without replicating each instance of the names of the people who applied for a leave. Here's the formula i tried: <%{ for each x in Create_Leave_Request {%> <tr> <td> <%=x.Name1%> <td> <td> <%=x.of_days_applied%> </td> <tr> However, what it does is it list
Date calculation from week, month and year
Hi.. I need some help to calculate the date for perticular sunday with scenerio below. i am inputing year, month and week of the month so how do i calculate the date for that sunday with week/month/year inputed above and store in one filed for further use in program. thanks for the help regards
Multiple Form
Hi.. We have one project with description below. Form-1 : filed-1 -- this is decider field to choose the next forms If field-1 value = 1 then select Form -2 if field-2 value = 2 then select form -3 Form-2: bunch of the fields value will be entered here Form-3: bunch of the fields value will be entered here Now can we combine view of Form-1,Form-2 and Form-3 ? OR do we have to have three separate views. Can you please help be appreciated. Thanks,
Showing not all but a certain number of records
Hello, I would like to know if I can limit the records to display in a View? I want have a "recently added" view to show 5 recently added records. Pls suggest. Thanks, Rajiv
How Do I Link to Form-B for the Same Record I Have Just Created in Form-A?
Hi All, I am a newbie with what is probably a very newbie-like question. Please help. Suppose I have an app that lets a user invite fellow students to comment on courses that they all take. What I want is for user-A to be able to create a course record using form-A and when done to receive an email with a link to form-B for the same course record. The idea is that user-A will forward the email to fellow students and that they may all use Form-B to rate/comment on the course. My question is, how
Using same variables across 2 diff field's User Input
Hi, I am trying to generate Unique ID based on the values in 2 fields. EG:- in the order the same order in form Field.LName -- Substring --> L_val ="abc" Field.Phone -- Substring ---> p_val="123" The substring and other activities happen at USer input , and the value is correctly generated ( so far so good) I want to have: Field.ID = L_Val + P_val ( as the last line of code at Field.Phone --> User Input) But, it so appears that variables declared and used at Field.LName-->User Input does not show
ZOHO Creator usage in other ZOHO applications
Hi, Is it possible to add a custom ZOHO application to a section in the ZOHO CRM? portals2go
Creator Extremely Slow today!!! anyone else facing this?
Hi Wizohoes, The Zoho apps are running extremely slow and even stopping in the middle of scripts today.. Please look into it. It is crippling any data entry as the scripts to show the fields are not able to run. Thanks
printing of help pages
Love Creator which I am about to launch to my clients I need to print off the help pages for scripts but i can only get the first page to print. Can you help please. Do you have the help files in any other format Nigel Higinbotham
Double Quote character into string var
How do I put the double quote character itself (") into a string variable? Vern
Bulk edit and formulas
I tried a couple of things but apparently calculated fields are not recalculated on bulk edit. Is this true, or is there a work-a-round?
Labels not wrapping in Firefox
I have a form with some long field labels. In IE 7 it wraps the field labels so the form fits in the screen. However in Firefox 3 it does not wrap the labels and the form extends off the right side of the screen. Are there any work arounds such as putting a special character in the label where I want it to break. Herb Wexler www.preventingmediocrity.com
Stripping out spaces
Is there any way to strip spaces out from data entered into a single line field? I need to pull that data out, take out the spaces, and then put it into another field.
Calendar View
Is there a way to colorize event titles in the calendar view for Z-Creator? I'd have a form to submit events with a category (i.e. home, school, work). Deluge script would then colorize the event title on the calendar view based on the event's category.
Bold some calendar items
In a calendar view I have some items that are approved and others that are not approved. Is there a way to bold the approved items? This still conveys the information without taking one of the precious 10 characters that are displayed on the calendar. If this is not possible can I put an * in front of the information showing for the nonapproved items? I have tried a calculated field on the form. But I don't think complex expressions are allowed. I need something like this If approved showdata
Backup failed - error : DataAccessException
Hi, I try several times and I cant' succed to backup my data (It's my first attempt to do this, after I suscribe to Business Pack) I get this error message : com.adventnet.persistence.DataAccessException Any idea of what's happenning ? A few days ago, I had a problem on a form in my apps, and now I can't either edit or delete it. Is there any relation ... ? Philippe
'Business Free Edition'
Has Zoho modified or discontinued the 'Business Free Edition' My understanding was it was not longer being offer, however existing uses use it as originally packaged. Specifically, I can now only share with one other user and the when I use SSL it does not format properly. Please advise.
Calendar from a formula
Hello, I want to create a view (an agenda) as a calendar based on dates calculated from a formula (date1 + 52W:0D:0H:0M:0S'), e.g. last year's + one year in order to get an easy agenda for events happening every year ALMOST at the same date. But it seems that only "pure" dates can be handled as "agenda", not the dates "calculated" from a formula. Is there any trick to get a calendar view from a formula or could it be planned as a new tools for ZOHO? I will recheck ZOHO's information but I fear that
Imagen in forms
Hi, I have a form (tipo_panel) with product, cost and product imagen url. The images are on another web (www.something.com/imagen/producto1.gif) I have another form (reserva) with a dropdown to select the product. When you select the product, I want to show the apropiated image but i can't. I have a field to show the textual image url, and it works perfectly. I have create a formula field with this formula: "<img src='" + input.Imagen1 + "' width='64' height='75'/>" but i doesn`t work ¿How can i
dynamic drop-down list
Hi.. Your help is appreciated. I want to display only choices in drop-down filed depend on the previous filed entered. example: region: west, east, south, north Now when user selects as below: 1. west ---- then only Los Angeles, San Jose appear in Center drop down field. 1. East ---- then only New Jersy, New York appear in Center drop down field. 1. South ---- then only Atlanta, Georgia appear in Center drop down field. 1. North ---- then only Canada, Seatile appear in Center drop down field.
Register/Login for app
I've been reading the help files and I can't figure out if this is possible. I want users to be able to add themselves to a table (by registering) and when they come back, they can login and see specific information regarding them from other tables. The thing is, I was thinking of having two forms - one for registering and one for logging in, with an opening dummy form saying "Do you want to login or register?" and then redirecting them to the appropriate place. I saw that it was possible to place
CustomFunction not apprearing in the User defined fuction - tab
Hi ZC team, I have 2 functions within my application Func 1 : -- This calculates no. of days left until due date Func 2 :--- Uses the result of Func1 as parameter & gives custom alert messages eg :- 0-5 days , RED alert -- 5-10 days , 10 - 15 etc Both functions work great & they are intended to be used like this No_of_days_due = thisapp.datecomputations.Duedate_daysleft(Due date); AlertMsg = thisapp.customalert.AlertMessage_duedate(No_of_days_due) However, when i try to "set variable"
I still need urgent help for "auto fill text" !!
my first question (I have about 1'500 line in a form for selecting - what I want do do is, when the user start to write that the possible row show's up in the line like in many other application. is that possible ??) your answer (Are you referring to a Dropdown field which has around 1500 options? If yes, where is the User going to type/write? Are you looking at something like Auto fill? Like if you type 'A' then all the values that start with letter 'A' to be shown automatically. Please let us know.)
Backup restore failed
Similar to some folk in other posts, I have tried to restore a previous backup. The result was an almost perfectly good copy of the forms & views but with no data. This is useless as a backup if the data is nor restored with the script as you have suggested is should be in previous forum entries. This is in addition to my previous post about being able to export attached files - but it makes the situation far worse if you can't export attached files and you can't restore a backup Cheers Roy Watt
Can Calendar display dates from multiple fields?
Sorry if this has an obvious answer, but I want a calendar that displays dates from more than one field within a form. If there is a field called DateA and one called DateB, I want to see both dates on the calendar. How can I do that? Thanks, Debra
Able to change just application?
Is there any way to just re-brand an application and not the entire account? Thanks Josh
Dynamic view for student data
Hi , I want to create a view dynamically , a student will login and select his name , password , id and want to see his details of grades he has scored in his tests, How can this be done in zoho , i know its very easy but i cant seem to get it
XML list
From some of the examples I can see that there is an XML list type that can be created by toXmlLis() function. I haven't been able to find any documentation on how to declare this type of list. in a new list declaration I can see it referenced by using an invalid type, for example List:x() Encountered "x (" at line 1, column 6. Was expecting one of: "bool" ... ... "float" ... "xml" ... "string" ... "date" ... "(" ... If I try to use List:xml() I get the following: Error at line:1 Function :List:xml
Enquiry
Hi, I have say 10 items listed in a drop down list called ITEM, Say Item-1 to Item-10. I want to display number of items in a drop down list, in this case 10. How do i achieve this. Thanks B Chandar
Invalid Entries Found Error
Hello, I keep getting an "Invalid entries found. Please correct and submit again." error, but the entries a from a pull-down. I gt a "[t_282736000000014019_PIDX] Exception occured while inserting rows Failed to update data." error. Can you help please? Thanks! Jun
Checkboxes field to Radiobutton
Hi, I've a problem with a field in a form. This field was a radiobutton field, One day I edited it (to make a proof) and I change it to a Checkboxes field. The ploblem became when I tried to edit it another time to change it back to radiobutton type. I don't know whay but i Can't change it back to radiobutton type. It's important to me to change it to radiobutton because there's a lot of scripting behind that need it. Anyone can save my life??? Thanks a lot.
Reload / Refresh form -- using script
Hi, i am trying to create an application where data is accepted only if certain conditions are met ---- so far so good,.. no prob here I will be embedding this form at my site. however, if the condition is not fulfilled i want only the form to reload (ie clear all entries and make it ready for a new entry) How do i go about this? Thanks for your time and patience Regards
"Full Text search" - how can I do this ??
hi I have about 1'500 line in a form for selecting - what I want do do is, when the user start to write that the possible row show's up in the line like in many other application. is that possible ?? regards john
Application copy
Hi.. How do i copy shared application from one account to another account for which the application is shared to it ? account-1 apps-1 apps-1 is shared account-2. After loged in to account-2 i saw the apps-1 but how do i make that apps own by account-2 and make it to private to account-2. Thanks,
remove shared user
Hi.. I shared apps to user-1 and i tried to remove by clicking on "x" it says deleted but upon refresh it came back again and application is still shared that user-1. any idea ? Thanks,
How to show only the latest record of a group of records
I am experimenting with an app to track equipment. One of the tables has essentially two lookup fields. One is a piece of equipment from an equipment table, and one is a location from a location table. A given piece of equipment might be moved to a lot of locations over a period of time. I want to keep this information in the table, but I want the ability to only display the latest record in the table since that is where the equipment is now. I would like to have an option to show all of the records
*** View, Edit shows popup edit box, but too long ***
In one of my List Views, I need to show about 30 fields. When the Edit button is clicked, the Edit popup appears, however with 30 fields, most of them disappear off the bottom of my screen, and the popup edit box has no scroll bars. Is there any way to change the View, Edit popup box to make it multi-column or have scroll bars? The only alternative I have found is to make the List View into a Grid View, but it looks terribly ugly and scrolls really far to the right.
Next Page