one sigle record
Hi, Please, How can I get just one record for may website? Exaple: I have a table with a cell with produc name: "Suarez" and I want in the next cell the value of "Suarez: that is in the db. Thanks in advance, Ricardo
How do I make that a Form A press on the screen data from another form in various fields?
Hi How do I make that a Form A press on the screen data from another form in variousfields? For example: The Form I-Product I want it in another form I select from a combobox the product name and thenautomatically loads itself into other fields all information of the product for which Iselected the name. Thanks
Add a checkbox on a view filled
Hi I need the following features: My example: I have the Form Products I need to create a View that has all the products registered in a productive and has anoption for eg a checkbox that I can mark it as a product with low. How would I do that? Thanks
How do I fetch data from a field in FormA to FormB with the criteria in both Forms?
-- I have Form A (names and other info of SHOWS) -- I have Form B (names and other info of PROJECTS) -- In Form B I have a field "name of show" -- I want to have in Form A a list of all the projects that match the "name of show" Can someone help? Thanks, Illetsac
Creating an alert when a duplicate is detected
I have a field called input.Client_PO i would like to create an alert when the user inputs a location that's already in the DB. so fas i have Client_PO -> On user input If (input.Client_PO == ***duplocate formula****); ( show alert_label; } of course the part i need help with is the formula for finding duplicates, once that happens the alert label will be unhidden. thank you.
Remove records to another database
I have a database, that inadvertently ended up with nearly 2,000 records that do not belong there. Although they are not for this database, I think they might be valuable to someone else. I can only see how to totally delete them, and at that, no more than 200 at a time (200 in the view). Is there a way to MOVE the particular records, found in a search, to another location, preferably on my hard drive ?
Getting an Error that I cant Figure out!!! HELP
I have a set of Stateless forms that feed into a master form, to produce a single view of all the data collected from the various stateless forms. I have 100+ fields in the master form, but when i try and add additional fields it gives me the below error... please help Ive put way to much time into this for it not to work. Error modifying the page Syntax error or access violation, message from server: "Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
Automatic Time Refresh upon new entry
One of the applications we are using with Zoho is a Call Log. The date and time of the call are logged in. Is there a way to set the form so it automatically updates or refreshes the screen with the correct time when a new call entry is made? Right now, the person has to manually refresh the screen every time a call comes in, sometimes they forget to do that and then it throws our records off because our work is time sensitive. Thanks.
Trying to make cell color RED if AGE is = or < 18 using a function
I'm trying to create a function where if the age of the user is less than or equal to 18 ( legally a minor ) the cell back ground color would turn RED. I've been trying to work this out but I'm not sure how to approach. With this current function setup I am getting the following error, and I havn't even got to the changing the cellcolor portion yet :( The Left expression is of type TIMESTAMP and the right expression is of type BIGINT And the operator - is not valid here bool isMinor(int Student_DOB)
2007 somebody ask this question : no solution in 201 ???
have embedded my survey form into the family website to gather information about family members. So far I am very pleased with every aspect of your application and its ease of use. The one thing that is happening that is a bit frustrating is: those filling in the form are hitting the enter key to attempt to go to the next field. When they do this the data is submitted and the form settings open up the home page. They then hit the back button to get the survey back and it creates another record with
Maximum code in a form?
Hi, I was wondering what is the recommended amount of code to place in one form. If you don't have an exact limit, how many lines of code would you recommend out of experience? I've been getting some strange errors and want to make sure I haven't overloaded the form. Thanks!
Getting records after a specific date.
By now, I know how to set a criterion for a view to restrict by relative date, such as "within the last year" or "before today". What I need is to know how to restrict a view to only show records after a specific date. Background: I have an invoicing application, and for this one view, I only care about seeing unpaid invoices (Date_Paid is null) that were sent in or after 2010. So I'm trying for something like Date_Sent > "2009-12-31" (which is the date format that my application uses), but I can't
Need user to fetch data to update form using iframes??
Hello, I have 2 stateless forms, each called to an iframe in an HTML view. On the bottom iframe is a duplicate of my main form (which is public) used for updating records. The top iframe has two single line text fields, Group ID and Listing ID. I want to use these fields to look up a record and populate the bottom stateless form so users can update that record. Our organization has 1000+ groups whose officers change all the time, so Zoho user accounts are not going to work here. I want whoever
== operator not valid for boolean variables?
I have the following line in a script: frn = Furnishing_Options [Furnished_Value == Furnished]; Guess what? It throws an error: Error in statement at line number 1 The Left expression is of type BOOLEAN and the right expression is of type BOOLEAN And the operator == is not valid here So I can't compare 2 boolean variables? This seems to me a serious limitation. Regards, George
Update a random record?
I'm playing around with some game mechanics in one of my creations, and would like to be able to update a random record. Any suggestions? Thank you so much.
How do I get an ID field to register with an auto fill of one on one?
Hi How do I get an ID field to register with an auto fill of one on one? For example: First Registration Field ID and auto-filled with a According Register Field ID and auto-filled with 2 And so on ... Thanks
I need to make the comparison of Ticket_ID be purchased with a value in another form
Hi I have a problem I have a scrip to this passage For Each rec in FEEDBACK_FORM [Ticket_ID == 115] I need to make the comparison of Ticket_ID be purchased with a value in another form Phaco with that?
How to Monetize a Database?
I am interested in creating a database app to sell. How can I sell a Creator app by user? For instance, each user is $25 per month. Each database would have a $50 set up fee. Also, if these are individual instances of the database, how are revisions sent out to all the installs if the master is modified? Does it make sense to sell individual apps like this or have one master app and sell access to it?
2 forms 1 sub form
I would like to know if 2 forms can share a sub form, and if possible how one would implement this. ex: sub form would look like: ----------------------- Student name: Housing Name: Move-in date: Move-out date: ----------------------- both the Housing form and Student form would connect to this sub form
Two lookup fields from same form - BUG
In my "Admin System" application, I have three forms: Tasks, Task_System, Task_Core_System "Task_Core_System" is a stateless form which is used to populate the "Tasks" form/table. "Task_System" is a form/table that holds all of the system names that I want to assign tasks to. "Tasks" form has a lookup field called "System" which references the "System" field in "Task_System" "Task_Core_System" has an on-submit action script that populates "Tasks", including the "System" field. This all works fine!!
Sendmail script with pictures
Does anyone know if there is a way to embed a picture on the automated email that applications send? i tried inserting in an <img> html tag but it only showed in the email as text.
Bulk Edit and Allow add new entries
On Bulk edit if a lookup field is selected that allows users to add new entries the option does show but nothing happens when the user clicks on it.
LDAP and Zoho Creator
Is there a way to draw information from an LDAP/ Microsoft directory system into a table in Zoho Creator?
Function that returns a boolean, boolean variables
Hi, I'm trying to figure out what is wrong with my function... I'm having trouble using boolean variables. I find this function works fine (returns a constant): bool PlayerGameAlreadyExists(string PlayerName, date GameStart) { Exists = true; return true; // this line works fine, returning a constant // return Exists; // this line doesn't work, attempting to return a variable } but if I try to return a boolean variable instead (see the commented out line above), I get an error
Vana Workforce Launches Time and Attendance Solution Developed on Zoho Creator
http://www.vanaworkforce.com Vana Workforce, a cloud provider of HR software and services to small and medium enterprises today announced the availability of Vana Time & Attendance, a comprehensive and integrated suite of time clock, workforce scheduling, and absence management solutions specifically tailored to the needs of small and medium size companies. Vana Time and Attendance helps companies manage visibility, reduce risk, and increase workforce productivity with one integrated and affordable
My hyperlinks are suddenly not working!
Hi I have a HTML page that works as a main page for my views and form. I have icon that has links to other forms and views, but they suddenly do not work. Think it happend wednesday! What can be wrong! Dennis
How do I create a view that receives data from two forms?
Hello How do I create a view that receives data from two forms? Example: Products have the form This form is to view Products It includes A few more information on this view, Now I want to create another form to add other information in this same view. Thanks
Formula Help: Count items checked
I'd like to create a formula that counts the number of items checked in a check box field. The number of entries checked would then give a rating based on the number. Is this possible to do with a formula field or does something more complicated need to be done? Thanks
Error while sharing public
Error while sharing public Whenever I put a form or application with a shared public displays the following error message: Error occured please contact application owner What's going on? How do I fix this? Thanks
Email - dynamically changing "to:" field
I have a database (form and view) for human resources that has contact names, phone, and email. I also have a form that keeps track of the stats of certain projects. I want to be able to send out an email notification to the project lead if the status gets changed to "problem" for example. What I cant figure out is how to dynamically change the "to:" field. Its almost like I need to do a lookup. So it needs to look in the status form for the field of "owner" and then correspond that owner in the
Create a Purchase Order DB
I want to create a Purchase Order database whereby I can create a unique Purchase Order number and add a quantity of product lines to the order and have it total at the bottom. Is this possible in Creator? Thanks, Martyn
Cannot export file- Creator
I can't export my file from creator. I click on export, the export window pops up, I click on download to spreadsheet (or anything else), the download window comes up then an error message comes up and says "Internet explorer cannot download "filename" from creatorexport.com. Internet explorer was not able to open this site. The requested site is either unavailable or cannot be found. Please try again later." I am using Windows Vista OS. I read that there may be a problem with Vista. Is there
Data base maximum records
Hi, I created a data base in Zoho and imported all my contacts which is an Excel file of 6,00MB. I saw that maximum is 5MB but, however, i have 17850 records in my PC and, in Zoho, I only have 4355 records. Is this possible?? What can I do to have all my records in Zoho? Thank you very much.
Open URLs in Iframe Question
I currently embed my form into an iframe on my website using a widget in IWeb. It works surprisingly well and is very simple. When the form is submitted, a new web page (thanking the client for filling out the form) is opened in the Iframe. I use the embed editor on the form application to create the html code to embed in the iframe. The one problem I have is that the 'thank you' web page is significantly smaller (shorter) than the iframe, and most of it is out of view unless you scroll back up
No Value on field (Null) not displayed in Filter Criteria
Hi, I have the following criteria on a view: ((((Status == "Available" && Retail >= 1) && Image_1.contains("http://www.")) && Quantity >= 0) && Ship_Weight_LBS >= 1) edit and I wanted to add "shipping_price" has some value in the field how could I express this in the above criteria. I don't want to use the word null but in the above criteria if there is no value in "shipping_price" I do not want that record displayed. Any help would be appreciated and how does the ((('s work? Is each (
How to fill a picklist with multiple fields from another form (and save just ID as picklist value)
Hi, I have two forms: "Parents" with fields like first name, last name, gender etc. "Children" with fields like first name, last name etc. as well as two lookup fields (picklist type) named Father and Mother, that are linked to the "Parents" form. Is there a way how to have the full name of the parent (at least first name and last name, possibly more data) displayed in the corresponding picklist, while saving just ID as the picklist value in the database? Currently, the user only sees the ID (values
Please Help - Weight Database
Could someone please help me figure out how to create a database for users to submit their dogs growth over time. Info listed would be dogs name, owners name, weight , and age. Where owners could look at a graph or chart of some sort showing all weights at certain ages to compare with others. This would be for just one certain breed. Any suggestions or help on this would be great. Thanks for your time!
Send email from a related data field
I have a view that displays a lookup field and the view is configured to display related fields to the lookup value, one of those lookup values is an email address. i would like to use the email address from that field to send an automated email. however because the field is a lookup field related to another form i can't reference the field when setting up the script for the automated email. anyone have any ideas on what i can do here?
OnSuccess - Multiple If Statements - OpenURL
I have created a questionnaire that asks a series of questions. Upon submission, I want a specific URL (there are only 2 possible URL's) to open depending on the answers to the specific questions. For each question the user can only select "Yes" or "No" as each input field is a radio. Once one answer satisfies the condition to open URL2 and the user submits the form, I want URL2 to open. If no answer satisfies the condition to open URL2, then URL1 will open. Right now, it appears the code below
How do I email only data fields that have been populated?
I have a rather long form and want to only see those fields that are relevant.
Next Page