Limit results depending on user
I am writing a database for a buying group. The database will contain all invoices paid through the buying group by some 25 members. I want to allow the members to sign in and access the database, but I only want them to be able to access THEIR information. Does ZOHO have this functionality?
Form with limited participants
Hello, I'm a newbie to zoho. I would like to make a form where people can subscribe for a couple activities. But there can only be 20 participants for each activity. So after the 20nd registration, this choice must be closed... It also needs to show how many empty places there still are for each activty. Can someone help me out how to make this kind of form with Zoho? Thanks!!! Comte
Chart display and properties do not keep their settings
I have a view in edit mode, and have the display type default to chart. if i try to update its properties, sorting, or change title and size in the display type, each counteracts each other and defaults the chart to original settings. The only configuration I am allowed to do at the same time is sorting and properties. I can not configure display type Title, Width, and Height and keep the settings. Is there something I can do, maybe in deluge?
Question about formula editor
Hi just started to check out Zoho, and maybe I am missing something but how can I create a 'percent growth' formula that does else but calculate the percentage change when comparing a specific FIELD VARIABLE X with the value of X in the previous record (after records have been sorted accordingly via grouping them on Date)? I.e. let's say if we have the following 2 records 1 Value1 2 Value2 etc I do now want to add a new variable GROWTH as (Value2/Value1)-1 Obviously it will lead to a missing value
Embed in website not an option under views. Please advise!
Embed in website not an option under views. Please advise!
The record ID as a view criteria returns the error "We are unable to fetch this data, sorry!"
I send the ID of a record to an html view (recID). In this html view I have an embedded list view (div embedding) that uses the passed parameter as a criteria (...=false&zc_RecSelect=true&ID=input.recID). This embedded list view returns the error message: We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com If I use other fields of this form as criteria it works (but I need to use the ID). The list view displays a total of 27 columns,
Creator data sent to invoice and sent to client?
So before i jump into this too far, let me confirm that this will work. 1. A zoho users fills out a creator form. 2. User clicks submit, i can use creatinvoice() task to automatically create an invoice using data from the creator form. What fields can i import into zoho invoice? More importantly, can i make custom fields in zoho invoice that i can send date to from creator? 3. Zoho invoice, automatically sends an email to client who has been invoiced with attached invoice one
Center column data in view?
Is there any way to center the data in each column of a view? It's hard to read when some of it is left-justified, and some of it is right-justified. Thanks.
Display a Zoho frame in a site with IE
Hi, I have a form that don't run when displayed with Internet Explorer. IE return that: Line - Char 67682 Error: 'undifined' is null or not an object Code: 0 Url: http://www.creator.zoho...... At this page... http://www.brasilemilano.it/br/consulares/fala-conosco.asp. Thanks Mic
Modify a dropbox to inline
Hi, How do I change a dropbox in inline field without modify alls scripts? It's possible? Thanks Mic
Email Creator Report
How do I schedule a report to automatically email?
Not receiving success email
Not receiving success email. I've noted in the last week that msg posted during lunch hour EST are taking a long time to come thru. Today, I've posted 6 records between 12h18 and 13h22 that have not come thru yet(13h37). But the one posted at 13h27 just came in find. My observation so far of this situation is that for about an hour somewhere between 12h30 and 13h30 EST success email takes a long time to come thru and in one instance I'm not sure it came at all. Alain Montreal,Canada
Form disappeared yet again!!
library materials form is down again ... whenever I make an edit to a field. this time, I changed currency for price field to USD (which is what it should be instead of indian currency) Please can u re-activate it. Also, can i make edits WITHOUT this happening? Leslie
Is there a way to sort a view on a field that is not displayed?
I added a numeric field to a file in order to explicitly control the sort order in a view. I don't want the user to see that field, but if I remove it from the view, it is not available to sort on. Is there a work around for this?
Trouble importing spreadsheet
I'm trying to add a new form to an existing app using the import XLS button. I copy the information from the spreadsheet and paste it in the box (17 columns by 33 rows). When I click Done I get a Please Wait and the lower portion of the screen goes blank but no form is created. I tried this on two different computers. Both are using Firefox 3.5. Herb Wexler www.preventingmediocrity.com
Column widths
I have a view with only a couple of columns, so want the widths to be small. I have tried setting the column widths as low as 1 pixel, but the widths remain wide. I must have a misconception about the Column Width setting.
registration form
hello...good morning(follow by malaysian time :],hehe ) anyway ive a small problem here.. yesterday im doing a simple registration form but when i put on my blog... the program asked for user name and password(public view)... and i already set that registration form as public(from setting)... but the msg displayed "Your request for Public Access is pending" n i not yet receive any comfimation thru my email. i just need to know, is that the right way for what im doing? becoz ive no idea bout this...
problem importing access dbs
got error on import : lexical error :line 1 - Column 21, <eo>atter;8guot;l"pquot
Auto populate text box
I would like to know whether its possible to autopopulate text box when a value is selected from combo box. For example if i select a particular subject the classrrom and the instructor for it must be automatically filled in tthe text box.
Where can i take a zoho/deluge scripting course in Northern California?
I am interested in a 1 or 2 day intensive course.
Public Forms
I have embedded my form into a website for public access to gather data. However, when I log out of zoho.com the form disappears and a log-in window takes its place. How do I set my form to public so that it stays public all the time and is not linked to my zoho login status? I set this up for a friend under my personal email and would like to do the same for work under a second account I created for gathering conference registration data but if the form can't remain public it is useless for web
Error when attempting to import data into my application
I have tried everything I can think of, and I keep getting the attached error when attempting to import data into my application. Help!
Display a programatically-created record
I have a function that adds a record to a form. I would like to also show the new record (in edit mode) once it is created, how do I do it?
problem importing access database
I got an error message when attempting to import an access database into zoho creator. lexical error-line 1-column 21- <eo>atter;8..... thanks.
Schedules quota are too few
Despite an enterprise edition, the schedules are limited to 30 per months (quota). Our organization requires more schedules on certain months of the year. Could you please update the number of schedules available or explain us how to be able to use more schedules per months? Note: if this correspond to an non-free update, please contact us prior to any change and let we decide first if it's worth before confirming the change. If this can be updated for free, please do it so. Thank you in advance
Script to import latest rss-entry based on user input
Hi Zoho-Team, really love this application, it's totally helpful! But I have difficulties to write own scripts. I just wanted to write a script, that imports the latest rss-entry based on a user input of the rss-adress. I attached two pictures: One picture of the form, one picture of the script. The script is of course totally wrong, but I don't know how to resolve it. Could you please have a look on it and give me a hint? Thank you! Seba
Links only to Home Page when logged in
Hi, My application sends an email when a record is added or changed. Part of the email is a link to the view: msgLink = "<a href=\"https://creator.zoho.com/peaslee/hyde-park-data-center/view-login/Parking_Citations_View\"><small>Link to View</small></a>";If I am not logged in to Creator, it works as expected; but when I am logged in (as Administrator), I am sent to the Home Page. Bruce "Speedy G" Peaslee The World's Fastest Programmer
Read-only columns in grid view
Hi, first of all congrats for the great service. One question: is it possible to have an hybrid between list and grid in views? I'd like to have some columns editable and others read only.
Creating a basic pairing matrix
The idea seems fine but I am having problems getting what I expect. Can I chat with someone about how to set up a pairing matrix? Okay, here is what I need. I need a simple database that has the capacity to allow a person to identify themselves (by email and general location ... say city and country of the world) and then they can list the cheeses they like and the honeys that they believe pair well with them. Because each cheese has certain characteristics we want to capture (hard, soft, for
Cryptic error message
I created a function that creates a new record, which I call from a view. But when I try to execute it I get this cryptic error message: Error details: Error occured while executing the script. Error occured. This gives me no hint as to what the error can be. Any ideas?
Parameters for HTML Views
I'd like to propose the ability to also add integer parameters to an html view. In attempting to pass ID number, I'm forced to convert it to a string, pass that string via url to the view, and then convert the string back into a number. I see no technical issues passing numbers via url strings, do you? Seems like a real runaround. When adding parameters, one expects some options to specif what variable type it is. John M. Whitney
Encode Buttons on HTML View
What I'm trying to do is add some buttons to and HTML view that when clicked refresh the view to display new data. The application has a number of events with dates. By clicking one of two buttons, events for today or the next two weeks are displayed. John M. Whitney
Error message.
I get an error message saying there are invalid entries when I try to fill this out. I also get a subscript saying the application has been disabled. I haven't disabled this app.
Can users of the free edition have a public application?
Hi, I just signed up today up for Zoho and am currently on the enterprise trial run. I have only one application, which is a registration form for a website I own. I want to make it a pubic application so that people who register to be volunteers via this form can sign up without having to create a zoho account. I only want to be able to access their responses to the registration form. Can I do this with the free version? That's the only thing I need: a public registration form where I can access
Suggest-as-you-type drop down for lookups to forms with many records
Let's say I have two forms. One is Clients, and has 8000 records. The other one is Orders, and one of its columns, named "client", is a lookup to the Clients form. There are two related problems: - When I edit an Order, the 8000 Client records are downloaded to populate the drop down list for the client field. That makes the loading of the form rather slow. - Because the drop down list contains all the 8000 clients, it is a bit difficult for the user to select the right client. Would it be possible
Delete a Creator View
How do I delete a view in Creator?
Right justification of a link
Is there a way to right justify the link name in its column in a view? Larry
Can one sort views by URL link name?
It appears to sort URL fields by URL rather than link name. Can one sort by link name? That seems more sensible than URL.
Comparing current date/time to current date doesn't work
Here's the code: bool test.datetest() { start_date = zoho.currentdate; end_date = zoho.currentdate; current_date_time = zoho.currenttime; test = false; if (current_date_time >= start_date && current_date_time <= end_date) { test = true; } return test; }I thought this should return true since the current_date_time has a date that is equal to the start_date and end_date, but instead it returns false. Why doesn't this return true? If I change the end_date to be one
Cannot create new forms
tried to import .xls data from both my Mac and PC - pages won't load!! It says javascript void whenever I scroll over the 'submit' button. Page will not reload, so I go back to the setup page and retry. Sometimes I get to the column match page, but won't complete the upload after. Pls help
Next Page