PROBLEM: No FINISH button when Importing a .xls file to create an application
Problem: After uploading and attempting to import a .xls file to Zoho Creator to create an application, the on-screen instructions say to click a "finish" button when the user is done making changes in preparation for field and data import & app creation, but there is no "Finish" button visible. I tried this same process in 3 different browsers (Safari, Firefox, and Google Chrome), and the results were always the same - no "finish" button. (See the attached screen shots and .xls file attachment.)
Help Needed: Making Password Recovery
I am making a password recovery app for a website that doesnt hae any sort of password recovery. I am having trouble with the Fecth Records part of the app. I have the add records thing down but i need help with the other. I have Allow Edit for support on it.
Newbie Question: How to make a form with dropdown fields behave according to user input
Hi there, I have been trying to create a custom form, kind of a diagnosis tool for a medical website, that will react according to what people input. I would like you to help me a little if possible with the basic/simplified template, and I should be able to work the rest by myself (hopefully!). I have tried to work it out by myself by looking at the help section, the support forums and by trying it but I just cant make it happen. The form should help user to find common outcomes and treatments
Multiple select and Counting them indvidually.
I am using multiple select check boxes and want counted individually, now it puts all option in string. How do I get out of this? I want each counted as an individual variable. Please check off all that apply I would like to have more data for funding reports I would like to know how long it takes for my staff to complete certain tasks I would like to better calculate our impact I would like to improve our communication and outreach
Mailing List App
I'm looking at options to improve the user experience for a mailing list (announce only) service. Right now, my organization is using Mailman. It seems to me that the Creator platform could provide a very nice mailing list service with features only available on high-end mail apps. For example: a newsletter could be personalized with "registered" user's names personalized "un-subscribe" links could be added to the bottom of each email (url encoding to stateless forms) user's could have a dashboard
Renamed application still appears with old name for shared users
I renamed an application that has shared users, but the old application name still appears in the list of shared applications that users see. When a user clicks on this, a message appears saying application does not exist. I had to remove the shared users from the new application name and reassign them again for the new application name to appear in a shared users list. The old application name however still appears. Is there any way of removing this old application name from the shared users list?
How can your get a link for an application that can be embeded in a website? Application was created by uploading an excell document.
How can your get a link for an application that can be embeded in a website? Application was created by uploading an excell document.
Show related views on one screen.
I have an application with several related forms. There is the client details form then a form for the details of each of the clients children, then a form for each of the clients automobiles, then a form for each of the clients pets. The forms have many to one relationship with the client. Is there a way to show all this information on one screen? What I envision is a list on top of the screen showing the clients. When a client name is highlighted the lists of children, automobiles and pets show
Auto assigning values to fields based on a pre-defined criteria
Hi Guys, I use Zoho Creator to run a runner ranking program. The idea is that runners submit their timings for a particular distance (they can choose from a total of 6 different distances). For a given distance, i need a 'rank' assigned to each runner. Right now, i do it manually i.e. export the data and sort the entries and then assign ranks (which will be displayed through a view). I know i can auto-assign serial numbers (by using counters), but can't seem to get a solution for assigning ranks
Undeterminated Error
Hello, I'm getting this error when i include a record to a form: Duplicate entry '' for key 2 there is no aparent reason for this. Here is the code of the form: form Funcionarios_Dependentes { displayname = "Funcionarios Dependentes" must have Funcionario ( type = picklist values = Funcionarios.Nome_Completo sortorder = ascending ) must have Dependente ( type = picklist values = {"Conjuge", "Filho/Filha", "Pai/Mãe", "Irmão/Irmã", "Outros"} ) must have Nome ( type = text ) Observacoes ( displayname
Error Code 2892
Yes, it seems Zoho Creator has a problem recognizing my application's name. This (API key and ticket crossed out for any security reasons): <form method="POST" action="http://creator.zoho.com/api/xml/read/apikey=[edited]&ticket=[edited]"> <input type="hidden" name="zc_ownername" value="hjdoyle"> <input type="hidden" name="XMLString" id="XMLString" value=QueryRequest> <input type="submit" value="Get List"> </form> ..always returns 2892 - "Specified application name
Criteria - Show only if date field is older than one month
How would I write the script for the criteria on a view that only shows records that have a Date field that is older than 1 month from the current date? In other words, I don't want a record to show up in a certain view unless the Date field on that record has an entry that is older than one month from the current day.
html views are rendered into blank PDFs
Hello Zoho Creator Team All my links to PDFs (created by Creator on the basis of html views) give me blank PDF Files. Example (adjusted slightly for confidentiality reasons): https://creator.zoho.com/username/MyApp/pdf/Print_Asset_English/&recID=373791000000813031&zc_FileName=Asset_XYZ&zc_PdfOrientation=portrait&zc_PdfSize=A4 Regards, Filip
Does insert command fail to execute if null values are encountered ?
Hi Team, I have a Parent From with foll fields Exec Name Designation Company Name (Drop down with list of existing companies from company master populated at runtime + "-Not in list- " Address City State Website When CompanyName = "-Not in list- "is selected, a text box is shown to the end user to enter the company name Other details are filled.. and form submit. On Form submit, I have Insert command for if(CompanyName =="-Not in list-") { [ insert into CompanyMaster Company Name = input.companynametextbox
Create 2 or more different forms to update same table?
Is it possible to create multiple forms with different field layouts but all saving the data to the same table. As far as I can tell each form is the table itself and only that form can update the table that stores the data. I know that many views can access the Forms data.... My input Form has "Set Email Notification" associated with it that is automatically sent when a record is added. However, my the database administrator needs to add records to the database/form and not have an automatic
Combining Data Between Apps
Greetings, So I have 2 separate apps that both share a similar need, creating educational classes. The equipment that is used in the classes is from the same location.Instead of opening up both apps separately, how can i create a shared view or report to monitor both apps at once? Can i use a stateless form to place data in two separate apps simultaneously? Any ideas would help, thanks.
How about a spot where we can view all the custom script we made in a Creator Database?
How about a spot where we can view all the custom script we made in a Creator Database? It took a while to understand deluge script, but I like it now. Would it be possible to create a spot in the program where we can view all the custom code in one location? I ended up writing so much code, that I had to start copying it to a text editor so I could visualize it all in one location. Just an idea. Thanks, r_gutowski
Form Email Notification Cap
There appears to be an issue when setting email notification for a form. It will not allow more than three email addresses to be included. The workaround I have found is that the limitation is only to each line item. So I can have three on the "To" line, three on the "CC" line, and three on the "BC" line. Is this limitation intentional?
Storing a radio button selection as a number for a quiz
I am creating a fitness survey. A portion of it is nutritional. I think this should be pretty easy, but I have several questions, all of which have the following answer choices: Never Rarely Sometimes Often AlwaysI want to be able to store the answers to each of the questions as a number. For example, Never would be a 0, Rarely a 1, and so on. I want it so that it will store just the number in a column so that I can add them up and give them a score later on using a formula. I can do the scoring
Manipulating data from user input to form
Hey Guys, I am collecting mobile numbers on a form which are inputed in the standard format. When the user hits submit I want to add a "44" to the beginning of the number and a "," followed by a space at the end. This would then be placed in the data column. I am not very good at writing these solutions and would be great if someone could help me out, step by step. Many Thanks Simon.
set up form and embed?
I have s simple form I want to put on my web site, let the reader fill in information and have it e mailed to me. How do I set up the form to have it e mailed to me? Then how would I get it into my website? Dwaine
Pick List Population
Hi, I've been having a problem and can't seem to find a way around this, hoping someone can help. I'm trying to populate a Radio Button picklist (Goal Title) with values from another form, that are based on a value within the current form (Employee ID): varManagerGoals = Goal_ID_to_Emp_ID_Mapping [EmployeeID == input.Reporting_to]; if (varManagerGoals.Goal_Title!= null) { input.Align_To = varManagerGoals.Goal_Title; } For some reason this code brings back EVERY value from within the data
Importing records
Please help. Really like Zoho, but can't seem to upload an .xls or .csv into my newly created database! When i click submit, it says loading and then just returns to the upload screen. It seems as if it might be complete, but when I try to look at my records, there are none.
Open Document in Creator View Online
I want to open online a file in a Creator View uploaded from a Creator form. I cannot do this with either Zoho's own "Zoho Companion" or through OpenIT online. I believe this is because of the way the URL is created through Creator. Does anyone have a workaround for this?
sending form to customer
Why can't our customer fill out our form? They get an 'access denied' error after 'logging in'. We don't want them to be able to change the form just to be able to answer the questions and submit.
Trouble appending data to text field
Cannot seem to get this to work. Fields: Services (multi select) Service_Date (date) Service_Date_List (text) When the user selects [Services] and a [Service_Date], the text "Service Service_Date" gets copied to [Service_Date_List] When the form is submitted, I want to append the info in [Service_Date_List] to the field [COMMENTS] as a log. The following does not work in (on Validate) or (on Success) if (input.Service_Date != null) { insert into Tracker [ COMMENTS = input.Service_Date_List
Formula for a column HELP!!
Im trying to make a column with the following variable (23 - x - y - z). 23 is a base, then I want to subtract the entered numeric values in cells x, y, z (where xyz have been defined by the field name) In the formula field I entered (23 - Sep_2009 - Oct_2009 - Nov_2009 - Dec_2009) But keep getting an error Error in statement at line number 0 The Left expression is of type STRING and the right expression is of type BIGINT and the operator - is not valid here Any ideas? Thanks!
How do I append data instead of replacing it?
I understand how to fetch and change records from a stateless form now, but how can you "append" to a text field from a stateless form? Right now this works to replace: -------------------------------------------------------------- if (input.Service_Date != null) { temp = Tracker [CLIENTID == input.CLIENTIDLOOKUP]; temp.Code_10_Record = input.Service_Date.toString(); } ----------------------------------------------------------------- but I want something like this, which will not work:
Using Zoho CRM Data to Populate Zoho Creator Look up Field
I'm building a simple Creator app to create invoices for our small business. All my customer and supplier details are stored in Zoho CRM. Rather than set up a form to duplicate all my supplier/customer records (which I need to produce the HTML View invoice), I would like to be able to access the Zoho CRM customer / supplier data directly in Creator - ideally by using a look up field to view all customers and suppliers names, and then using the selected customer/supplier name to pre-populate the address
Trying to delete selected records with OnClick in statless form.
Ok, here is my goal. I want to delete selected records with a stateless form. I'm using a checkbox to determine which ones are deleted in the main form. Name of the main form: claim Name of the checkbox: Extended Name of the stateless form: Clean_Up code for On Load of Clean_Up deleteList = claim [Extended == false]; that is a 'fetch records' function. I don't even know if that is the right way to start. code for On Click of Clean_Up cutOffTimeMicroSeconds = (zoho.currenttime.toLong() - 5 * 24 *
help Makin a password recovery
i have made a password recovery where i want to type in a computer number and it will give username and password for a site. and if you havent added your username and pass yet then you go to add_pass but thats where i have trouble. i need to add the input of user name and pass and comp pass to something so that at the 1st screen u can just enter your computer pass and it will pop a screen up saying your username and password.
Intruction on creatiing a html view
Hi! I am a new user of Zoho Creator and reading the instructions to create a html view in step two of the html view definition it says: "..specify the view name and the section under which the view will be displayed .." but I only have one textbox to input that information and I have no idea on the format used to enter the view name and the section. Can you please give me an example. Thanks in advance
Share specific parts of database ONLY - HELP!
Hi I have created a database, and will have 15-20 registered users, but I need each registered user to be able to view only their relevant portions of the database (i.e. John Smith..Project x, Hours worked) How do I do this? do I need to create a filtered view for each user? Please help! Thanks
LookUp Issue
I am trying to create a relationship between two forms. The first form is Donor Information with three fields (First_Name, Last_Name and Email_Address). The second form is Contribution Entry. I have placed three lookup fields in the second form and linked each to its respective field name from form #1 (donor information). Here is my issue. In the second form with the lookup fields, I type in the last name of a person all is fine. When I go to the next field which is the First name look up field
view criteria setting
Hello Support, Could you please check the criteria settings for the 'email view' of the LROC Membership Database (allowed access to support). I only want to see the data of the members who have NOT ticked the 'email opt-out' field. Somehow don't get it to work. Your help would be appreciated. Thanks. Cheers, Daniel
perma-form will not load
hi: I have a private application titled "control_paramount_realtors". in the form "feedback_survey" i have inserted OpenUrl command in the "on_add/on_success" section that is designed to take the user to the form "feedback_submitted". the URL is a form-perma snippet without login requirements, but the script only seems to run if the user is logged in. also the "send mail" command does not work unless the user is logged in.I have tried making the form public, nothing seems to work. i have even
Is my goal achievable
I will be embeding my form onto my web site. I would like to have my visitors that complete a form to have the ability to return to update on a monthly if not weekly basis. Can this person edit their own document, or do they have to become a user? Thanks in advance.
how can i create a header/detail form ?
how can i create a header/detail form , like I navigate to one customer at top, and all his payments would show in the detail section. _ I need to know if that is possible ??
Preventing changes to database by public
How to have public view but prevent adding/changing/editing records ( ie, make view read-only)
Questin about script
HI i am trying to have my application send an email when my formula equals a negativie number. Please help. Some thing like this. if FORMULA =< 0 SEND EMAIL
Next Page