Form Validation Mirroring
I often have to copy and paste validation code for a form's "on add" to the "on edit" section. Maybe place a checkbox in the "on add" validation section to mirror code to the "on edit" validation page. Cheers, John Whitney
Filtering picklist with another list
Hi, I want to filter a lookup list in this way: 1) I have three forms, Categories, Subcategories and Products 2) Everyone of these forms have a multiple look up field to the other two forms 3) When entering a new product, the user selects as many categories as he/she wants, no problem here, no filtering, all Categories show up 4) When selecting Subcategories, I want this list to be filtered in a way that only those Subcategories belonging to the Categories already selected by the user show up.
I would like to report on emails sent from a schedule
I would like to report on emails sent from a schedule How is it done? DC
How to create a unique revision to a record by linking it back to a record within the same form....
Lets say I am cooking and I have 10 recipes. So, I create a form with each recipe as a record and I give that recipe record a name. ie. Carrot Cake. Now I want to experiment with the ingredients in that recipe, so each new experiment would be a revision of that original Carrot Cake recipe. So I create a field Revision. Can I create a lookup field that would show what revisions had been previously created for the Carrot Cake recipe? So that duplicates are not created? Or can a formula of some kind
why login&pass for "Through this code snippet, you can access the form without login" ?
hi i just made snippet on my paid account and put it on site snippet code "<iframe height='341px' width='100%' name='zoho-form' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/vsavonkin/rabotanaem/form-embed/form/tC2rp1HCeEn1tTUDxew9P2sd3EVDahaqmOSEq1H3CgzHbJ6Ea3QfqDaCw1M1vmF4fqqARm8DmgsVYSxeyBa3CaT27bEMWJ9Nqh6t/zc_BtnFontSize=18&zc_BtnBgClr=red&zc_BtnClr=white&zc_BgClr=lime&zc_SuccMsg=Мы получили вашу заявку и уже ее обрабатываем!'></iframe>" why in browser
Deleting multiply subforms
Hi, I have a form that has say two subforms in it [form1 and form2]. When deleting a record of type form I should manually delete the relevant records typed form1 and form2. I have bidirectional links of course. The on delete script allows only one delete statement. What can be done? [my form actually has 4 subform ...] Many thanks for your assistance, Regards,
Register Without Email
Here's a new one! A client of mine has a few patrons that apparently do not have or want to share an email address. Can you believe it? Yet, they have online access, presumably at a library or work computer. The client wants the patrons to manage their contact data online. I'm at a loss how to create an app that requires sign-in but does not use email (zoho accounts)... I know it's not allowed to create a custom authentication system so what's the workaround here?
How can I change the display type of a look up field from multiple select list to checkboxes when this option is grayed out?
Hi, How can I change the display type of a look up field from multiple select list to checkboxes when this option is grayed out? i.e. when the field had already been created as multiple checklist? Rgds Luis
Form on site & auto-filling Creator's app
Hi on my site right now i use jotform's form in which users fill name address phone attach files how can i make the next: form on my site that 1) will accept uploading files AND 2) automatically fill new entry in my creator's app with attaching uploaded file as i read before - stateless forms do not accept uploading files
Parent, Child and Grand-Child Relationship
Hi All, I have a scenario like Parent Form - Business_Date (This form had "Customer" as subform) (Bi-directional Field - Bdate) Child Form - Customer (This form had "Business_Points" as subform) (Bi-directional Field - Cname) Grand-Child Form - Business_Points So, coming to the issue i'm facing is that, when i simply update the Business_Date form, all the existing
Complex Form - Need Assistance
Hi I need to create a form based on the below requirement, any assistance is greatly appreciated As you can see from the below image i have all the customers stored using Customer Form, i need to create a new form where i pickup the customer from the customer table and have the action fields with radio buttons or checkboxs. i can create a lookup field and individual action fields and the user can select individual customer and select the action fields, but its too cumbersome to do it for tens of
toTime() seems to be broken
Hi, I'm trying to allow users to enter time in 24hr format into a text box. I get errors as shown in the attached screenshot when I use the following code: alert("test start time: " + row.Start_Time + "..." + start_time.toTime("K:mm")); Note I am using an acceptable format for 24 hour time as per this page.
Can the SendMail from a form only send data from the decision checkboxes selected by the user?
I have the email set up, so that it sends a copy of the data to the form user once they have completed it. However, as I am using a lot of decision checkboxes, with only a few actually being ticked by the user, I want to know if there is any way of limiting the data that is sent on the form to those decision checkboxes that have been checked by the user? Does anyone know how to do this please?
XML RPC - Add Records using VB.Net
I am struggling trying to use the above. Have you got any code snippets or documentation that may help with this. Thank You.
Enabling Rich Text Editor for your applications
Hi all, You can now use 'Rich Text Editor' field in your applications. This feature is not yet open to all. If you would like to avail access to the feature, click on the following link and submit the form to request for enabling the feature for your account. http://creator.zoho.com/zoho1/creator-feature-enable-request-form/form-perma/Rich_Text_Editor_Enable_Request_Form/ Regards, Mukesh
Line spacing in views
I have a simple view with 2 columns of single line fields. The vertical spacing between the lines of text in the view is larger than the actual text. Is there a way to change the spacing?
Form Layout
Hi - do I have to have 1 field per line, or can I have several fields on one line so that my form can be wider and not so long? This would make it easier to fill in data quicker. lenfante ------------------------------------------------------ This is posted using zohocreator feedback form
Number of fields in table
Our table includes "too many text fields". Your support documents state: "Form can have maximum of 80 text fields with max length of 255(SingleLine and Email). This can be increased by reducing the max length value." We reduced 50 fields from 255 characters to 3 characters. We are still UNABLE to add a single new field to the table. What's going on????
Checkbox Variables???
I am trying to do a script based on action on a checkbox. I want to expose more fields to enter if a person checks a check box. When I am doing the script, what is the name of the variable for "checked" ie. if (input.HRA == ???) What goes in the bold ??? to tell it checked? Thanks Q
Formula field issues + Drop down list question.
Hello, I am developing an app to find the average score among 4 scores the user inputs in a form. However, the field does not appear on the form (even when I check the box), AND it doesn't show up in the view. Here is the function I am using: (Work_Quality_Score + Work_Habits_Score + Job_Knowledge_Score + Behavior_Score)/4 Also, I have a lookup field to select the employee being evaluated. Is there a way to have it look up First name and Last name? These are two separate fields in another form.
Infinite parent child relationships
If I have "Comment" and want to have sub-Comments for each "Comment", whats the approach in Zoho Creator in order to do this? Is it possible to do something like under any particular comment entry have "add comment"? I'm okay with any programming required here, I've gone through alot of the documentation but can't find anything related to this.
Gird View Permission?
Hello, how can get this Code: if(!(input.IATA_No.toString().matches("^\d{8}$"))) { alert "The IATA Number should be 8 digits long!"; // replace 3 and 5 with min and max digits.. cancel submit; } into the views? Thanks Carsten
Stock Inventory Integration with Paypal Online Sales
I am a very new user of Zoho. I searched the forums / market Place and did not find reference to my needs. We will be selling fishing lures on line of varying size / color / uses. We'd like to somehow integrate a stock inventory management app with paypal to reflect how many items have been sold, and how many remain in stock of each variety. We'd also like to reflect "Out of Stock" on individual lures in the customer view when there are no more of a selected item in stock. Perhaps I missed the
Can Zoho Creator work with Apps in Marketplace
Is it possible to linking Zoho Creator App with a existing App in Marketplace? Such as "Zoho Projects"? Say I want to have extended functionality that "Zoho Projects" doesn't. Also, is "Zoho Projects" created with "Zoho Creator"? Thanks again for the response.
Matching payments to orders: can someone point me in the right direction?
Hi, I work as a manufacturer's rep in the theatrical lighting industry. I've successfully set up a Zoho database to handle the "front end" of my business, i.e. the constant stream of purchase orders in my territory (all identified by a unique order #). Once a month, I get an Excel file of commission payments for that month (which also references the order #) I'd like to be able to import the monthly report and have it automatically reconcile payments with orders, but I'm really lost as to the first
Relationships (via lookup) in Zoho Creator
Hi, I have a question regarding Zoho Creator lookup. I'm wondering how relationships (lookups) are defined "internally" on Zoho Creator. It seems that lookup fields accept any arbitrary data type and not keys/ID's of the referenced items. If a field I specify as the lookup is "Name", and I point to that field in lookup, "Name" must be unique? How does this compare to standard databases which usually use a unique ID/key to creation relationships? Is this more comparable to say Access database? I'm
Query User's Group
If a user signs-in, then there should be a way to query the user's group affiliation. We can query a user's email, sign-in name, and even IP address, but not group. This would be a nice way to display messages on html pages for certain groups in the share module, or display view data based on groups. if (zohologinusergroup == "Building_23") { // display a message } Cheers, John Whitney
How do you sync info from a form into sub forms in individual records?
I have created a form where I can keep track of individual client records, their contact information, etc. I have also created a separate form where I can input client hours and services each time they visit the office. I would like to add this second form into each clients personal record form. I added it as a subform however this doesn't' sync the information added to this new form. Each time an existing client comes into the office I want to be able to add their name, the date, and the services
Auto Population of values in Plain Text Field
We are familiar with doing auto generation in drop down fields in Zoho Creator using Deluge Scripting We need to auto populate the values in "Plain Text" field type instead of a Drop Down. Look up is being applicable only for "Drop Down" type. How can this be done?
How do I make the Sub Form look like the rest of the form?
Hi, I'm working on my first application and I've included a sub form in my main form. The sub form appears to in a table view and scrolls off the screen to the right. This make for a very bad UI. How do i change the the sub form so that it appears as the rest of the main form does? I've read through the manual/quick start guide and the searched the knowledge base and cannot find the answer. Any help is appreciated. thank you, Larry
URL parameters for Calendar view?
Hi, I'd like to display a calendar view in week mode showing a specific date range. Is there a way to do this? As an example, I'd like to be able to show only the week 6/1/2013 - 12/1/2013. It would be good if I could do something like: https://creator.zoho.com/ahatton/kidsoccer/#View:Coach_Availability_Slot_View?mode=week&start_date=6/1/2013&end_date=12/1/2013
ZOHO Creator
How does zoho creator work? what if I want to make a computer application or a phone app?
Action on Add Row for a sub form
Hi, When adding a row to a sub form, how can I asign a value to one of its fields using information in the curent form? There is an option to do actions "on Add Row" but the problem I have is that it only changes the first row rather than the row being added. Below is the code I am using, which results in updating allways the first record of the subform.. input.SKU_Ultimo = (input.SKU_Ultimo + 1); SKU.SKU = input.Numero + "." + input.SKU_Ultimo; thanks for your support...
Houston!! I have a problem
Hi guys. I'm new with Zoho and i've made some HUGH errors. I have 2 forms. Form 1 - Portfolio Brand: Dropdown menu Model: Text Field (no duplicated values accepted) Form 2 - Sales Date: Date value field Brand: lookup value from FORM1 Model: lookup value from FORM1 (with a criteria that dependingo on the Brand you will see Model) Now, the problem. I've beenn updating form 1 - Portfolio, and as it was easier, i've deleted all the values and recreated them. The problem is that now, all the registries
HELP!!!!
HI, i want to know if it is there any way to selecta dropdown menu depending on the user that is creating the record. What I want is to add a field where i can see the Complete Name of the user that saved that record. This is because USER names are really strange, so i want to create something like: If username == "jd2012" then Owner = "John Doe" So, i can create a list of the users witrh the correct name, but i want to know if this is possible! thanks in advance Pablo
is it possible to create a dynamic "price engine" in Zoho Creatotr?
Hello all, I would like to know if it is possible to create a dynamic "price engine" in Zoho. I have a list of prices that we use in our company and I would like my users to be able to find the most suitable price based on 4 criterias, namely: Location, Type of Product, Age and Product Extras. I have all these information stored in a view and would like to have a search form that lists the products based on their prices. Is this possible in Zoho creator? and if so would some one kindly let me know
Reference data from forms in other applications
I know you can reference other applications for lookups as well as calling user defined functions. Can you reference other form data in deluge scripting? eg for each test_record in application1.Form1 { //Do stuff in application 2 } Will this be added in the future?
Newby question :)
First of all, hello to everyone and thank you for reading my post. Here is my problem: I own a martial arts school and I am trying to create a database in which i ll be able to keep track of my enrolled students and their monthly payment status. Up to this point I ve created 3 forms, a registration form, a payment type form (different types of payment, monthly tuition fee, private class, school accessories etc) and a final invoice form which takes the name of the student from a dropdown lookup function
Using Scheduler & forms to move data
I wish to move data in a form from a tab in a view called 'A' to a tab called 'B' can anyone given me a heads up on possible script to do this thanks
I want to disable the add / delete items in a subform. How I could do it?
I am charging the information into an specific sub-form in advance, since the date is already uploaded I want to disable or hide the posibility of add items or delete items into the subform. How could I do it?
Next Page