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
Currency:
Can the result of a formula be in "currency" format? If so, how do we display this in a view? Thanks, Rich
Auto Delete Record based on Age
I have been working with the scripting feature and I'm trying to figure out how to create a way to delete records automatically based on the age of the record. Any help would be appreciated.
Deluge comments disappearing
It appears that comments I have in my code are being removed. At first I thought I was going crazy, but after typing my comments numerous times, I feel confident in saying that my comments are being removed. It's not all of the comments all of the time. There's no pattern.
Creator Expenses Report question
The sub-categories are not populating with the Category selection. Meaning once I click the category, the sub category has the full list to choose from which is very annoying instead of just the subcategories that are associated with the particular category I selected.
Locking down certain drop-down choices
I'm wondering if it's possible to restrict the ability to select particular items within a drop-down field. Specifically, I have a field that has a long list of months/years to select from. I need to keep those old 2008 and 2009 dates, but I'd like to make it so nobody can ever select a past month once that month has passed.
Next Page