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.
Creator as a Production/Live System
I was wondering if anyone is using Creator as Production System that requires substantial uptime. I have been reviewing the Creator and have determined it will likely meet my clients requirements, however I want to get some feedback on what sort of uptime we can expect. How stable the Creator is, and whether it can be used as a live syste, that is used throughout the business day. Is the Creator ready for daily and frequent use, or should I be looking else where? Glenn.
Can we make two databases "talk" to each other
Hi We have different branches in cities. We want user to add certain data in different columns. Next I want to be able to do mathematical calculations on those fields. Based on the result of the above calculation using ( > or < or = ) if then else I want it to another database and add 1 or subract 1 from another database and also trigger and email and SMS alert. Essentially what we are doing is we have broken a persons salary into daily w tasks with different weightage. Based on this we have
Question Regarding If Statements - OpenURL - OnSuccess
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 to fetch a record and create HTML like a compare site?
Hi, I do real estate listing business. How do I fetch a record from Zoho Creator and create HTML showing top-down information like comparison site below? David
Is it possible to count the elements in a picklist?
Hi, I'm trying to do count(input.Picklist_field) but zoho is rejecting it. Isn't it possible to do this?
Justify data in a record (Right/Center/Left)
I'm trying to center justify data in a record. Some records/cells default to left and others to the right. I can't seem to find where I can change this in Creator. I searched the forums and couldnt find much of anything related to creator. Thank you in advance.
Linking forms
Is there any way to link the information in two forms without using look-up fields?
Look-up fields - not in drop-down form?
Hi, When linking two forms with look-up fields, is there a way for the user to enter an answer in the look-up field in Form 2, rather than selecting from a drop-down which was populated from answers from Form 1? After a while the drop-down list gets very long and messy looking. Thanks, Elizabeth
Obtain data from drop box using lookup field.
Hi, I'm just having a bit of a issue trying to get data from a drop box in one form and recreate it in another form using a lookup field dropbox. Pretty much I have a add staff form which takes the first letters of the staffs first names to create a initial code in dropbox "Initials" which I then want to be shown on my add bookings form so it can be shown which staff member made (and stuffed up haha!) the bookings. If I try make a lookup field in add bookings it will not show me the Initials field.
Purchase Order Database
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
to move app to another user; to change app as shared app
I have two questions: - is it possible to move an application to another user: I made an app, I share the app, the user I shared with keeps the app and I delete it ?!? - if a app is shared as developer, is it possible to make changes? (show as grid, change something and save it)
help
ive put my profile in twice how do i delete one of them???
Schedule sometimes says "An internal exception occured ", but why ?
Hi forum readers, I have written an interface using CRM API that's retrieving specific records from a view, then sync a creator table. As far as I know, here is no problem as I know of with the script, and all the records are currently retrieved, and creator tables updated. Every night, a custom schedule runs and calls this script. However, when I looked at account usage log for this schedule, I realized I sometimes get "An internal exception occured" message (see capture “Schedule Log.PNG”) After
Is it possible to have a pop up or other action when a person chooses a particular option in a drop down?
Just wondering if this is possible. I have a question on a form with 4 possible choices in drop down format. However if the person chooses option D I would like a message to appear in some format, either pop up? or some obvious way they can see it ! many thanks
Next Page