Running multiple "IF" statements in Free Flow
I have a form that will require me to run multiple "If" statements. 1. When I run a "single" If statement, everything works fine. 2. As soon as I add a "second, third, fourth etc." If statement, I get no output. a. Note, I will not be using functions since no two If statements will be the same. 3. Any ideas on what I should do to run multiple if statements in one form? Should I be putting something between the statements so that each one runs automatically? I have copied and
System Error thrown when Radio Button values are duplicating
In Zoho Creator form when I use radio button but ran into a state of having the same values for the radio buttons instead of showing a friendly message I get a system error message as in the attachment. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Insert Domain to Requester
Hi; We have 4,000 requester and i like to insert Domain in the requester information.
Resizing Controls
How can I resize a control?. I have tried changing the definition script and resizing it manually without succes.
Field Height and Width Control Issue?
I am attempting to gain some sort of control over the display width of specific form fields and have attempted to find an answer in using the knowledge base and help of areas of Zoho, but have grown a frustrated in the many of the answers not properly being documented and/or not properly updated for the existing Zoho framework. I thought I could gain some control by changing 'Form Definition Script' for height and width of fields of my form, however, it appears to have NO effect. Please advice if
Restrict IMPORT / DROP DOWN list by other FORM data
I am trying to restrict a drop down list by a valaue in another field on the FORM data entry page. General info: FORM NAME CATEGORY FIELDS - TYPE CATEGORY - FREE TEXT FORM NAME DEVALCODES FIELDS - TYPE DEVALCODE - FREE TEXT CATEGORY - DROPDOWN IMPORT FROM CATEGORY FORM FORM NAME ASSETS FIELDS - TYPE CATEGORY - DROPDOWN IMPORT from CATEGORIES form DEVALCODE - DROPDOWN IMPORT from DEVALCODES form Goal Restrict DEVALCODE dropdown list by CATEGORY as selected in ASSETS form. However, I cannot
How does one stop processing of a second click?
I face this issue both in a regular form and a stateless form. The processing of actions for both necessarily take time on the server side, and "Loading" alert pops up sometimes, but frequently it doesn't. The user is therefore tempted to push Submit again, which leads to a duplication of data creation. I found the "cancel submit" option for forms, based on the data having already been created; however, a user pushing the button a second time quickly will beat this creation process and a second
Update image field with different image
How can I update an image field through a script once the image has already been set? Example: (This is in the On Edit On Success script. When a radio button is selected I want it to trigger the image change. "Urgent" is the radio button name, "PriorityImg" is the image field name.) //Update Urgent image per selection if (input.urgent == "Yes") { input.PriorityImg = "http://mywebsite.com/images/zoho/hi_pri.png"; } if (input.urgent == "No") { input.PriorityImg = "http://mywebsite.com/images/zoho/no_pri.png";
when I check my forms online, why does it show login info, and not the form?
Question is pretty self explanitory. When I go to my partner links page, the page shows a login form (i.e., user id, password), and not my form for businesses to fill out. It only turns into a form when I'm logged in to zoho. How can I change this so it shows the form all the time?
Could someone clarify the limits of the Zoho Creator Free edition?
I'm trying to move a nonprofit membership list from an excel spreadsheet to a database. I'm intrigued that I might be able to do much more with it (like having members join from our website and input their own data into the database) but I'm looking for clarification on the limits to Zoho Creator Free version before I spend 100 hours putting data into it. It's fine if only me and one other person has the ability to change the form of the database, but I'd like a few other people (not the general
Html view : I don't access to my variables created in my form.
I try to create an html view and I don't access to my variables created in my form (I access only zoho variables). Is it normal? I don't really understand the purpose of a html view. My wish is to create a report. My data are only textual, url, email. I don't have to carry out some calculation for my data. I want to a report with some boxes where the data can be shown. I tried to do a report with zoho creator and It is not very beautiful (grey, not easy reading). And I don't find how to make it nicer.
Lookup with multiple field information
First off, Thank you so much for a great application and all your outstanding support. I love it! I have a membership database with three forms: a member form where personal information is stored, a club form with information on sports clubs, and a participation form which tracks a members participation in a club. I would like to do a member lookup from the participation form, but I will need the lookup to show multiple information to avoid selecting people with the same name (ie Surname + First
How to luanch a form from a comined view??
I am using Creator to handle a property bidding/auction project. I've created 3 forms... 1. People, 2. Addresses, and 3. Bids. For the BIDS form, I created relationships with PEOPLE and ADDRESSES to access pick lists on the BIDS form and that works great. I then created a list using the BIDS form, and used the combined view feature to add other fields to the list from the PEOPLE and ADDRESSES form. This all works great. But when I click "EDIT' in the BIDS View List, I can only edit the BID form.
Permission is denied for Scheduling
Hi Team I have an Standard Plan Account in Zoho .I created a Scheduler.but Can't enable it.It shows an alert message like Permission is denied.Whats the problem?......
Scripting documentation hard to find
Scripting is needed once one moves past the basics, but documentation is not comprehensive that I can locate. One needs a list of all the functions available with the exact vocabulary and structure specified, but I can't find it. The few examples listed are good, but more are needed. A related issue is that the ToC for the scripting help menu doesn't cover all available help pages for scripting documentation, apparently. I discover, at least, many more than I can descend to hierarchically through
Form using Sendmail unable to send mail messages
I've developed a an application, https://creator.zoho.com/sancher/shift-allowance-tracker/. It is to help in tracking shift allowances in my project. Shift allowances are entered thru the month. At the beginning of a month, a mail is sent to various team members who have shift entries in the past month. This mail contains the shift entries pertaining to the team member along with the team members ID. A module, "Generate request to confirm shift details", has been developed for the above requirement.
Forms and number of users
Hi, im trying to create a form that will be used to assessed the technical support of one area to the organization to other internal areas. In order to do this, which kind of licence do i need? every person completing a form is considered a different user? Thanks, Juan
Posting JSON to HTML view and converting to Map.
This is in response to the following post. Got an error trying to post there so I started a new thread. http://help.zoho.com/portal/en/community/topic/500-internal-server-error-24-6-2010 Akash, I'm a little confused by your guidance here. I don't think that hesadanza it's trying to do a JSON "RPC'ish" post with a json body as ONE KEY. When submitting an html form via ajax doing this.... params : { name1 : value1, name2: value2, name3 : value3, } //jquery ajax post $.post(url,params,function(data){
Date Functions
I maintain a membership list for a club of sorts and need to keep track of when members fees are due. Is there a way to have their listing show up in a separate list after their payment date is over 365 days old? This refers to my MN application under my list of applications. Thanks for your help.
Query only rows where column matches X criteria?
I know this has to be simple. I could write this query in my sleep in SQL, but I'm short on time and trying to figure this out in Deluge. Basically I'm trying create a report that will only list the values that I specify in my script. For example... say I have column called ComputerName that lists out roughly 400 computers. I want to pull a specified list of computers. In SQL I would write it like this... select * from database where ComputerName in ('computer1','computer2','computer3',)
When I share my view with oher users, I just want that each user can ONLY edit their own records that they have captured by the form before.
When I share my view with other users, I just want that each user can ONLY edit their own records that they have captured by the form before. When I set the permission, it allows me to give the permission to every user with who I share the view. So they can edit any records that they want....and I don't want lol! I want that when a user captures his information by the form, he can only edit his own records! How can I proceed? Thank you
Fields required. I want to give two solutions to the user for giving a required information
I want to give two types of solution to user for submitting a required information. Like he can upload a file or write an URL where we can find the information. At least one of both information has to be filled in to allow information submitting. Example (pseudo code) : if URL_field/=null or upload_field/=null then submit=active.... I don't know how to program it...Someone can help me please??? Maybe I don't have to program it... Thank you!
creator reports
unable to open the report editor on clicking create new report....
How can I display an image in my form (not in the view)
I have left zoho one year ago with this problem and it is still here. Any solution? For example, i want to show a diferent image for each of the option in a drop list; when someone change the select product from the list, i want to show the picture of the product.
OpenURL query
I want to be able to display transactions between two dates using the following script, but doesn't work: openUrl("#View:Expenses_View?Date_field=" + input.Start_Date;input.End_Date, "new window"); Any ideas? Martyn
Email Address instead of verification code
Hi, I have an application in which one can enter his contact details. I would like to have him/her re-enter their email address instead of the verification code. Any chance I can do this? Thanks!
IMPORT DATA FAIL
Hi, I have given support access to the database. Here are more details with the issues. Importing DID WORK Denominations (simple two column, no linked or multi-select data) Suburbs (simple three column, no linked but one multi select data) Importing NOT working The forms; Churches AND Schools will not let me import I went through first and removed ALL "no duplicates allowed" options - did not fix I removed all field options for 'required field' - did not fix In the Schools Form: I removed the two
Hide some tab from User
Hi Team I have a question . For example My application is used by User and the administrator.I want to set some permission that the admin can see only some form/View.But the user can't access that view. ie I have three tab Dashbord,AddTable,ViewTable Can I hide View table tab from user but it will show while the admin is used. Is this possible? Thanks
TXT FILE
Hello, I am developing an application that must generate a txt file and the user must download. How can generate a txt in zoho creator and user can download it? Thanks
populate one form with information from another form
Hi, can soneone describe in simple terms how to populate one form with information from another form Thanks Nigel
toXML parse not working.. TRUST ME.
Hi, I use your getURL, postURL,toXML, and xpath functions extensively. Good stuff. However, I ran into an odd problem that I was able to debug. This problem throws erros both DS and in xpath builder app. In DS the my xml variable cannot be updated In xpath builder I get the following error Error :: Invalid XML/JSON format javax.xml.xpath.XPathExpressionException Anyways, it turns out that the problem occurs when an xml element looks like this <element attribute="" attribute="" > instead
Funny look to disabled fields
With Firefox 3.5.10 I get this look to the disabled fields: Not very attractive. Not true in IE8. Thanks, Bruce
Unable to delete application from homepage
This is the error i received, Error Occured. We are sorry for the inconvenience. Please try after some time or refresh the page and try again. I tried deleting all forms and views inside but still didn't work. This really is a serious bug. I wish to delete the following applications, 1. inventoryt 2.copy of exam registration 3.copy of exam registration. Thanks
Upload Issue
I just uploaded my database and 250 of 4000+ entries came back as invalid type all in the same column. Reviewed, all in order and do not understand why this happened. Please advise how I can get this information into the database.
DECIMAL TO BIGINT
It's possible to transform a decimal variable into a big int variable into a script??? Thank you Sergio Galiano
If field disabled, remove from Views
Hello, If there is a field on the form that is currently disabled (through a decision box for example), can it be automatically removed from the View? thanks,
Can application use Facebook login instead of Zoho Login for user?
Requirement #1: I would like to create a membership application where user can login create account using their facebook ID and password. Requirement #2: I would like to create a membership application that has User create their own login data User fill out and modify basic info using their own created credential Simple search result by company, industry, age without need to log-in (not using Zoho account) Detail search result with need to log-in Hope that someone can help on this one! Thank you
Two script left (If field_1 is greater than field_2) field_3 = a numeric data
Here is the concept and below is my script. If the sum of total points for Blue Team is greater than the sum of the total points Yellow Team then the Yellow team gets 0 points and the Winner is Blue and receives 1 point If the sum of total points for Blue Team is less than the sum of the total points Yellow Team then the Blue Team gets 0 pts and the Winner is Yellow and receives 1 point here is the expression I wrote Mission_Score_Card > b_g1_wins > On User input if (input.b_g1_pts < input.y_g1_pts)
Problem
I just want all forms & Forms views in my left top pane. How can i see this ?
Where is the Save Setting being Stored?
I applied the steps described at https://help.zoho.com/portal/en/community/topic/how-do-you-to-sort-on-a-hidden-column-in-a-view#2266000001132452 that tell how to sort on a hidden field. After several attempts, it finally worked. But when I examined the .ds file I was unable to see where the change was made. The script of the view looked the same before and after I did the save. Can anyone tell me where this setting is being saved? Is this setting only good for the user who is saving the setting
Next Page