User Input wiht NULL
Hello, i have this script on Validate: if ((input.Office_ID).length() != 9) { alert ("Office ID Amadeus must be a length of 9!"); cancel submit;} how can i change the script, when the user dosen't input any value? this field has don't be a required field. thanks Carsten
Mission Critical - need to send a digital product on payment of invoice.
Hi Team My company sends out building inspection reports to clients. These reports are only released on payment of the invoice. Often the report is uploaded to the system before the invoice has been paid. In this case we desperately need to have an action triggered when payment is made in zoho invoice, so that our creator app knows to release the report. Ideally this should be instantaneous. At this stage the only way I can think of is to have a scheduled event within creator check the payment status
Send email from different user (not adminuserid or loginuserid)
Hi Team I have a scenario where I need emails to go out from a specific users email address on submission of a form that has been embedded on a website (to an email address entered on the form). This user is not an administrator, nor does the published form require anyone to be logged in. If I try to specify an email address in the "from" field it tells me that the "to" field can only be set to an adminuserid. Is there any way to have emails originating from regular users on submission of a form
History for an form?
Hello Guys, i'm very new to Zoho Creator it's an very useful Database Software. How can i add an History to my forms? that i can see which data has change? would it be possible to see all changes in an grid view? Thanks Carsten
Creating multiple almost identical records in a form quickly.
Hi, First of all thanks for creating this user friendly and easy to database management tool. I am a pretty inexperienced user when it comes to databases, but the needs we have for our office is not that advanced. The problem i am currently facing is to reduce the time it takes to create some records. Our company are giving out small boxes to measure the radon levels in residential houses. Each box has an unique ID that needs to be searchable and indexable. The form is going to look something
[App_Table_Configuration] Duplicate Entry "xxxx" is not allowed as duplicate . . .
I went to switch a "Single Line" Text entry field to "Import Data" and configured all of the parameters including '"Show Link" and "Enable bidirectional relationship" and so forth. But now I'm totally hung up with an error being generated that says: [App_Table_Configuration] Duplicate entry '1262029000000082829' is not allowed as duplicate entries already exist. I cannot find any duplicate entries in any of my forms or in the Imported Data. Thanks to this interruption, I've lost my place in my scripting
Colorise Calendar view
Hi. Is it possible to colorise the items in a calendar view by certain parameter? Like conditional formatting in excel? I found an old post about this, but this was 4 years ago. mayyyybe there has been some change in 4 years regarding this topic? If not possible to colorise, can I somehow "export" the view in google calendar? I have a lot of information to visualise in a calendar but certainly the application looks odd when trying to show too much records:
Custom HTML form view url parameter passing
I have a Form with View "Tests". It contains a "Project" lookup field. The "Project" lookup field is set for dropdown as import from ID (I want to use ID's for unique values). The display type is set as the Project name in "advanced display". Now, when I want to display form view like this: <div elName='zc-component' viewLinkName='Tests' params='zc_Header=false&zc_Summary=false&zc_EditRec=false&zc_SecHeader=false&zc_RecSelect=false&zc_Footer=false&zc_ColMenu=false&Project=<%=Project_ID%>'>
Search for a customer in ZInvoice via API
Hi All, @moderators, If possible, please allow this to be posted across multiple forums - Zoho API - Zoho Invoice - Zoho Creator ( on using ZC-ZInv Integration) Recently, I have been working on the ZC ZInv integration for a client The idea was to generate an invoice (from ZInv ) and send it to the customer via ZC- Form submit. I understand that the pre-requesite for generating an Invoice via ZC (or any other app) is to have the customer info already present in the ZInv settings. So, it is only
Cannot save script
There seem to be some issues as I have searched throughout the forum for this topic, but I am still not sure what to do. I am trying to enter some very simple script for the 'on update' event of a form field. When I hit the 'save script' button at the right lower corner, I get a message in green that says 'script generated'. However, when I leave that page and come back to it immediately, I find that the script has not been changed. I have, at times, been able to save changes, but cannot figure
view custom action act on all currently selected view items via the checkbox
hi, i want to work on all the records that have been selected in a view using a custom action. how do i get to the selected items in my custom action function? thanks
relating a form to many forms
I'm working on a farming application. Lets say I want to store transaction details of an "Inventory" that might be a child of a multiple types of "Planting", or of "Receivings", and become the parent of more "Plantings", "Packaging Runs", or "Wastes", for example. Inventories must also be able to parent other inventories so that lots can be split and combined. But I don't know in advance if my Inventory is going to becomes seed, or be sold, so I can't have a different Inventory forms for each type,
New User - Database Novice
Hello, I'm new to Zoho and very, very limited Database experince. I want to create a Simple(?) database to manage Staff & Equipment, Possibly later a Help form based on the Staff & Equipment. I have a good idea on where to start.... But before I even start I'm confused? I have created an Account for me, I assume I'm the "Full Admin"?, But can I also Develop? I have read some posts about problems about people creating in the Personal Workspace vs Shared I think? How do I avoid this, I want
Execute deluge upon login?
Does anyone know if it's possible to execute one or more deluge scripts upon startup of login of an application? For example, some of us maintain a users table in which app users can update some basic profile information or application parameters. If their record is not yet in the table (i.e. Added_User==zoho.loginuser), I would like to insert a new row transparently upon login. Thanks, Jeff
Populate yes/no response from link in email?
I have a table that contains event staffing information. I would like an email to go out to the volunteer when I assign them to the event. In this email I would like to have a message followed by a simple: Can you confirm your attendance? Yes or No When the "Yes" is clicked, I need to have the "Confirmed" check box on the record selected and automatically saved in the table. I don't care if the form displays or not (preferably not). Is this possible? Has anyone done anything remotely similar to this?
How to reference old status of dropdown field?
How to reference old status of dropdown field (that was just before user input)?
AND / OR Operator - Please help
Below is a my ON VALIDATE script for a form that I cannot seem to get working. if (input.production) { } else if (((input.section = "Processing Specifications") && (input.caliper.toString() = "")) || (input.pulp.toString() = "")) { alert "Please complete the rest of the form fields"; cancel submit; } else if ((((((input.section = "16 oz Random Sliced Sample") && (input.extraneous = null)) || (input.foreign = null)) || (input.discoloration = null)) || (input.spots
New User - Making Progress - Need Help = Unique ID and Relationship
Hello, New User - A Real DB Novice. I have created 2 tables 1 = "People" 1 = "Assets", the forms appear to work fine, 90% complete. I have 2 questions? 1. I need to create a unique UID 4 digit, sequential number starting at 1000 on my People Form. So when I add my first record in Form Unique = 1000, next 1001, next 1002 so on..... I have searched and seen some example creating new form with 1 field and some script on success?? Is there no easier way?... I'm very new to this
Upgrade / update path
Hi, Any suggestions or tips regarding how to manage two applications / versions: 1. "development" and 2. "production" scenario. I know Zoho Creator has no such facilities but even a valid manual process will be grateful. Eventually the "production" application should have all its files in their original place too. Many thanks for sharing your thoughts with me, Regards,
I'm looking to add a function to calculate/update customer balances in view. Can anyone provide sample code?
Hey everyone, My application tracks customer balances against payments that come in via both cash/check and Creator's PayPal API in this view: It updates automatically from "submit/success" actions in the payment forms, but occasionally payments are misapplied, thus requiring edits that do not automatically tally (along with other small miscellaneous issues) This issue is currently is solved by simply clicking "edit" on each record, because the following "on edit - on load" script executes each
One to One relationship between two forms via lookup field - Strategy for no duplicates
Sorry, newbie question. I have two forms containing fields that relate to single jobs. My forms are divided by company segments (Engineering & Production). I can link the forms via a lookup field (job number) but I am having trouble because I cannot seem to figure out how to exclude duplicate entries in my second form. My Engineering form has the Job Number field set to no duplicates. My lookup field resides in Production form and is a required entry. Problem I have is you cannot tell if there is
executeXPath treatment of null value issue
Hi guys, I am developing an application which I am attempting to integrate / sync with Saasu using the getUrl action, however I am having trouble transforming the data into zoho where null values are present. I am new to Zoho and xml and have managed to get single GET and POST requests working, but I am having trouble with GET list requests. I have been searching the help info and forums hoping to find a discussion that solves my problem but have not come across anything that discusses this problem
HELP: ZOHO CRM with Creator - Linking DATA
Hi. I have been searching everywhere to find a solution to this problem however cannot find anything. When you have a look up, lets say in the "Lead Table" looking up a contact. The selected contact is associated to the Lead. And, more importantly with regards to my questions, the Lead is associated to the contact. So when the contact is selected, if you view details of the contact, you can see in the more details section, information about the lead. What I need to do is have that same relationship
Hyperlinks - browser compatibility
I have a dashboard with hyperlinks. The hyperlinks work as expected in the Google Chrome Version 25.0.1364.99. However, The links do not work in Internet Explorer 9.0/12 or Safari Version 6.0.2. I am using the code below <%Urlstart = ((("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/";%> <a href=<%=Urlstart%>#View:SITES_View target="_top">ALL SITES</a> Why do the links work in Chrome but not IE or Safari? How can I fix the links? Some users only use IE so I need it to work
Display a form from another form?
Greetings, I'm looking for a way to have a button, link or checkbox on my contact form that says "Log Notes". When I click that, I would like a new form to pop up prompting me for the notes. Can this be done? Thanks, Jeff
Zoho Creator Integration with Sql Server Application
Hello, We have an application that consolidates a lot of different pieces of data into a large report, but the data comes from many different sources. Zoho Creator is the perfect tool to collect the data from hundreds of different users, but we still need our appliation to "display" all of that data. My question: Is it possible to use Zoho Creator as the front end and have the data either persisted into a SQL server upon add or exported to SQL upon command or at some regular interval? Our application
Import XLS form load - incorrect tab
I have found a bug with Zoho Creator When I go to "New Form" and Select Form Type "Import XLS" I then select a Tab from the Place this Form under dropdown I then paste in my data and click Done The form and data gets created fine but the Form and View get created under a New Tab. It's not a major problem but the new form and view should exist under the tab I select. It is a hassle moving the form and view and deleting the link. Can you please fix this issue?
A form to add products with multiple variations - and manage the sales & inventory
Hi, I am trying to create a form that will allow me add products that has multiple colors for each of them. Example: Product with code number '405' has 10 colors. Color number 1,2,3,4,5,6,7,8,9 and 10. And I have around 100 products, each one has 10-20 colors. When I sell these products I usually sell a couple of them with multiple colors for each. The color listings for each product are not always the same (not always no.1-20, but usually it is) I want to be able to select a product number in the
custom HTML Views
Hi, I've asked this question, but seems I can simplify more to get an answer (that I really need here). When I create a Form for "Tests" with a lookup field: Label Name: Project Import Date from: Project -> ID Display type: Dropdown Advanced Display: displayed as "Name" property for example. Then I want to process a custom HTML view for "Tests". with params: params='zc_Header=false&zc_Summary=false&zc_EditRec=false&zc_SecHeader=false&zc_RecSelect=false&zc_Footer=false&zc_ColMenu=false&Project=<%=Project_ID%>'
pagination in custom HTML view
Hi, Is it possible to add pagination into custom views? Thanks for any response
Prevent form from displaying?
Does anyone know if it's possible to prevent a form from displaying based on a condition like whether or not the user is the administrator? For example, I have this deluge script working (somewhat): on Edit > on Load: user = Users [User_ID == zoho.loginuserid]; if (user.Role != "Administrator") { alert("Sorry, you don't have permissions to use this feature."); }It displays the alert box as expected. What I need is a way to just show the alert box, then when user clicks OK, the form would
Reset forms & passing parameters
Background: I have an order form that capture ORDER_ID, ORDER_TYPE, PARENT_ORDER_ID and other details. The ORDER_TYPE can be of type child or parent. When a user submits a parent order, they child form is loaded afterwards. It will pre-populate the form to be of type child and save the previous form order id as the child's parent id. This part works fine. Implementation: I have added deluge script via the On Add Submit so that the parameters are passed via the URL next_url = "https://creator.zoho.com/<<application
Zoho Invoice CreateInvoice Function from Creator
Hi Guys I am unable to set PayPal, Standard up as an Online Payment Option using the CreateInvoice Function from within Creator. The help file says that "PayPal" is a Key Name that I should be able to select and set in the mapping variables, and if I assign it a value of 1 it should set the online payment option to PayPal, Standard. However, PayPal is not listed in the available Mapping Variables Key dropdown list. Simply typing it in does not appear to work - here is my script. respVar = zoho.invoice.createinvoice({
Is Zoho Creator the best option for my project?
I don't know if I am doing this right but I have been studying zoho for more than 2 days, I don't need a form in my project. Is this project possible by using only Zoho Creator? My project flow is: 1. Upload CSV file containing the data > Time Of Call, Project, Disposition, Call Duration, Zip Code, State 2. Generate a report that will find the Best Time to Call (means that I have to find the data where call disposition = successful call) and the Best Day to call Example: ViewCalls Time Project Disposition
How i can to put a link html <a>?
Hi, My name is Juan Manuel and i'm new un Zoho creator. I need a link with tags html, i want pass over by link and show new options or topics or show a new form. i know to made with css or javascript in normal code but i test javascript in zoho and dont work, how can i make this with zoho? Thanks for your prompt response. Juan Manuel
Can Zoho run reports like this?
I'm curious if Zoho could do the following things. 1. If we had data set up in Zoho docs, could a custom function pull that data out of a certain set of cells and populate an invoicing app? This would help keep from re-entering $$ amounts each month when we do invoicing. 2. Could a custom function pull data out of a certain set of cells and show up on a graph/bar graph over a range in time? 3. We have contracts that we keep track of and it's important to know the expiration dates. Could a custom
Location of custom filter as a view header drop down?
My custom filter is appearing outside of the normal filter drop down. Instead, it is turning my view header into a drop down and displaying it there. Is this correct? If so, is there any way to move it to the filters drop down? Thanks!
Not Able To Remove Added Filters In The View
Hi, I have a zoho creator view with some filters added for various fields. All the filters are working fine with respect to functionality and also filters can be removed. But the adding and removing of filters is not correctly working for lookup field values. For suppose i have added a filter for a lookup field value.When i click on the remove symbol(Click to remove this filter) i.e., close or cancel (X) in the applied filter of the view as shown in below screen print, a new field for the filter
Button style for SUBMIT ?
hi just made stateless form for my app and turn it on site how can i make submit buttom in red color? in "customize" i didn't find any tunings for it
Get rows from uploaded excel/csv files upon "Submit"
Hi it's my first day of trying Zohocreator and I have created a simple form with a File Upload field and the usual Submit button. How do I fetch the data (rows & columns) from the excel file? or given that it's a CSV File (Comma Separated Values). Thanks, CJ
Next Page