Calculation based on total numbers of a particular field
I would like to create a field for Total Weight in my View. This would calculate all the Weights chosen over a period of time from the Weight Dropdown by user in my form Example: User: Chris Weight: 3 Weight : 5 And then calculate the total in a Total Field in my view Total Weight:8 Does anyone know how to do this? Thanks!!
Custom themes not working.
When I create a custom theme, it doesn't display. I tried both with http and https. The "Please wait..." box spins for a while, then when it disappears, nothing is selected. This is when I create a new theme that is based on Gradient, and I have changed no other values.
"On User Input" Quit working
My form http://creator.zoho.com/dgosho/form/9/edit/ User started complaining this week about how checking "Continue to Part 2" quit working. What it is scripted to do is - On User Input (checking the box), it calculates data and shows the user information and asks more questions. I have made no changes to the form. I looked at the script and it looks like it is right. Will you help me out with this? Here is the script that runs On User Input for checking "Continue to Part 2" input.Percent_Funded
Embedded & Linked Forms
Hello all, I have hit a wall with respect to developing my forms using Creator. My goals are: Complete: 4 individual forms (as opposed to one huge long form) Incomplete: These 4 forms need to be linked (so that I can look up submitted data in one view or report) I have the script for stepping through the 4 forms in sequence. I'm passing a Project ID from one form to another with the openurl command. Do not have the ability for the form's data to be linked for one view (unable to create the linked
Moving a view to a different category
When a view is created for the first time, there is a dropdown to select where the view will be displayed, i.e. under home or reports. However, I cannot see a place to change that setting once it has been selected initially. Does this mean I have to delete the view and set it up again from the beginning if I want it to be listed under a different category?
Add Record in Safari from Grid
I have a problem in Safari only. My form has fields arranged in 2 columns. If I use Add Record from the grid view, it pops up new window. but this window is very wide and I have to scroll it to see fields in the right column As I said it works just fine in IE and Mozilla.
change notification email on form
I want to send my forms notification to a different email but whenever I edit the form and change the email, an error message show up saying. " Error Occured. We are sorry for the inconvenience. Please try after some time or refresh the page and try again." Of course I have tried with different browsers and machine and still get the same error.
Autocomplete - order of displayed options is different to order of given options
I'm using Jorn Zaefferer's Autocomplete plugin on a couple of different pages. In both instances, the order of displayed strings is a little bit messed up. Example 1: array of strings: basically they are in alphabetical order except for General Knowledge which has been pushed to the top: General Knowledge,Art and Design,Business Studies,Citizenship,Design and Technology,English,Geography,History,ICT,Mathematics,MFL French,MFL German,MFL Spanish,Music,Physical Education,PSHE,Religious Education,Science,Something
grid view not sorting correctly
go to here http://creator.zoho.com/clubmad/2010-turnover/#View:Input_Form_View filter by "104", show 200, then sort by move out date asc. scroll to bottom of grid and you'll see move out dates that should be at the top. each of these that aren't sorting have been edited since initial import of data. I've exported to excel, and excel sorts it fine.
Dark Black Background when Editing a Form Field's Properties ...
@ZOHO Creator Team: Just noticed this morning that when editing a Form Field ... the dialog boxes that pop up to allow entry of properties of the selected Form Field (or Stateless Form Buttons) ... have a dark black background. If I recall correctly, you used to be able to see the rest of the Form and Widgets in the background ... is this a deliberate change from before ... or just another unintended result of the recent release of changes to the platform ? f.y.i. I am using Firefox 3.5.7 under Windows
Cancreator save and finish later
I am building a big form and I think clients will have to save it and finish later is that possible and how?
Cycle 4 - Community Driven Features - New Plan
Cycle 3 of the CDF only had 7 final entries and 60 votes. Not much, considering the huge user community that is apparent from the forums. Also, some of these votes came from the same IP address. To be true to the intent of this project, Cycle 4 will have a few differences The idea phase will remain open until 5 days after 14 suggestions are collected. Thus, the minimum time for the idea phase will be 6 days. There is no maximum time. One vote per IP address. It's not really fair to have a bunch of
Access Migration Tool not reading database properly
For some reason, when I try to open my access database in the migration tool, all I get is one table. I know there are plenty more in there. Does anyone know why the tool would not handle the database properly? Anyone have a similar issue?
How do I remove the error for RHS Constant?
I keep getting this error message when I save the script: Error in statement at line number 1 RHS can't be a constant I assume it has something to do with overloading the operator, but I can't figure out how to get around it. Below is part of the code causing the error. if (input.funded == "Adams, John") { Friday_Lodging.deselectall(); Friday_Lodging.select("Yes"); Saturday_Lodging.deselectall(); Saturday_Lodging.select("Yes"); } else if ((input.funded == "Smith, Gary" || "Ring,
Relational DB with Creator
Can we use a relational DB with or build a relational DB with Creator. If yes, how do you assign the relationship? Thank you - Frank
Truncate Date-Time
Is there a way to get rid of the seconds in a view? Or even in the calendar Date-Time Object? My view shows this: Apr 02,2010 23:01:38 I would like to get rid of the 38 seconds, and just show Apr 02,2010 23:01
Problem creating a graph out of a check box list
I have a form that asks for the name, age of a person (text and numeric fields respectively). It also ask to select dates from a check box list (4 options created). The idea is to organize football matches and teams on that dates based on the amount of people inscribed. I tried to create a graph report that shows in X axis the dates and in the y axis the number of people inscribed for this date. The graph does not read or recognize all dates available in the database, only few of them, so the graph
How to declare variable on User Input
Does anyone know how to declare variable on User Input? Can I have an example if I wanted to declare a field name of "My Variable" Thanks!
Can not delete fields in Database
When I try to delete a single line or multiline text box I am promted with an error message. "Delete Operation Failed - Please try after some time or refresh page" I have tried using different computers and different web browsers. Any ideas?
Integrating Zoho Planner, Zoho Notebook & Zoho Creator for customer maintenance
I'm new to using the Zoho Creator application which I love so far. I'd like to be able to use the Zoho Notebook and tag notes to people that I have stored in my database in Zoho Creator. Eg. If I am taking a call from a customer in my database, I'd like to be able to use Zoho Notebook and then link it back to that persons file in the Zoho Creator database for information consolidation. I'd also like to be able to create events in the Zoho Planner and tag them to individual entries in the same
Can a Script be run for all records "on add / on load"?
Will this script run "on add / on load" and send an email to all the records in my application that meet the criteria? Or, will it only apply to the current record? if (((zoho.currentdate > input.Added_Time.addDay(10)) && (input.Contacted == "null")) && (input.Hired == "New")) { sendmail ( To : input.Notification_Email From : zoho.adminuserid Subject : "Follow Up Required: Recruiting Leads" Message : "Dear" + input.Assign_To + ",<br
Unexpected results in "on edit->on load" event
Can you tell me why the input.Treatment_Diagnosis_1 never gets set in the "on edit->on load" event of the following code? I know this exact code works when used in the "on user input" event of input.HCPCS_Code1. Thanks in advance! ~SirGregory on edit { on load { if ((input.Treatment_Diagnosis_1 == null) && (input.HCPCS_Code1 != null)) { if ((count(Patient_Condition[(Patient == input.Patient && Inactive == false)]) > 0) && (count(HCPCS_ICD9[(HCPCS_Code == input.HCPCS_Code1 && HCPCS_Code.Inactive ==
I want to pull a list of spefic values depeding on an item selected in a drop down menu. Does anyone know how to do this? I really need help! Thank you
I want to pull a list of spefic values depeding on an item selected in a drop down menu. Does anyone know how to do this? I really need help! Thank you Example: Choose "A" from a drop down list Then a list of values "1,2,3,4,5" will appear in drop down or any type of field below If you choose "B" from a drop down list Then a list of values "6,7,8,9,10" will appear in drop down or any type of field below
Abuse report?
It's somewhat funny that in the footer of the application I develop for a client, there is the following link: Report Abuse So, if I meet something abusive in the application I develop, I have a shortcut for abuse report? Or simply it's a shortcut to report any abuse I'll meet regarding any ZC application? I don't dare to click the link to see what happens, I'm afraid that my application will be blacklisted. So, ZC support, can you explain why that link is on the pages of the applications I develop
How do I change zoho creator account name
How do I change the zoho creator account name? I want to change the account name to one that fits my business name. How do I do this and retain all of my applications, settings, users, etc.?
Form edits changing
Hi Have just started with Zoho - looks like a great product - but have just spent a long time entering a form. Every time I reopen it the postcodes (In Australia 4 digits) have 1. the mandatory field off and 2. the maximum digits off. I keep changing them but they keep going back. ? Any ideas? Cheers Bellinda
HELP - Form will not allow me to Add or Delete or Rename fields - ???
I have a large app that I've been creating. I made good progress until now when I've encountered several serious bugs. I really need your help. I've got tons of hours invested and I can't go further. 1 - One of my forms will not allow me to add any more fields, and it wont' let me delete certain fields either. Each time I try to do a delete, it complains. If I try to rename, and/or hide the field, it says ok, but those changes do not stick. Help!
Can I use Zoho Creator to create an online form or script to signup for all the zoho apps at once plus Webriq.net?
I am a reseller of Zoho here in NY. I am selling Zoho as a light ERP SMB suite. Everytime, I add a new customer, I have to manually add everyapplication to their suite and double check single sign on with ZCRM. My goal is to have a sign on process like www.eazybusiness.com. You simply sign up on one form and it runs a script to subscribe to VTIGER CRM, ZIMBRA, ORANGE HRM, and Joomla. Very simplle and powerful for the end user to get started. My goal is to do this with Zoho and Webriq.net (
how to create a fast data-entry form?
Any ideas? Zoho Sheet is too slow for this. Think MS-Access' sheet view. Is it possible with Zoho Creator? Any example apps?
Imges not displaying
I've created a form to upload images and then display them in a formula field as described here however the images aren't displaying; all I see is a blank image place holder - see below: Any ideas?
pricing for API usage.
Creator pricing seems to be ased on per user basis. If I'm using API to interact with my Creator application, how will the pricing affect? My applicaiton will obvioulsy be used by many users but their interaction with Creator application is None. E.g. Facebook application that uses Creator application as the backend.
Using count function
I've created the following script which works well - however, I want to pass the count value to a variable -- I can't see any help on this with the count function: if (count(Workflow_Tasks[Job == input.Temp_Jobs_List]) == 0) { alert("There are no active Tasks for this Job"); } Thanks, Martyn
Proper() string function
I would really like to see the "Proper()" function implemented in Deluge Scripting. This function would force the first letter of a proper name to be uppercase and the rest lowercase. Also, this type of formatting could be implemented at the field level; perhaps with a generic input mask string.
Poor performance of Creator
It seems that there are again performance problems with Creator, at least for me... it takes a lot of time to save an html view, to view it (30 seconds for a view which usually is loaded in 3 seconds)... and I tried to see the new applications from the Marketplace and it was a real pain because the loading times are too big. Does any ZC user have the same problem today? Regards, George
Fetch Record for IF statement
I am trying to figure out how to Fetch specific fields from another form, to implement IF statements in the first form. For example: Two forms: STAFF and RECORDS In Staff form is: NAME, Position type, and several Decision boxes -- Do you want to receive email if EVENT A, EVENT B, EVENT C In the RECORDS form: There are many fields, one is STATUS. So, if STATUS changes from NONE to EVENT A or EVENT B, or EVENT C, I want the database to go through each Position_Type, and depending on the NAME
Question - Group By and Sum within a View
Hello - Let's say that I have three records in a form with two fields (Product, Order QTY): Product A, 12 Product A, 37 Product A, 19 In a View, what I want to do is produce an output that looks like this: Product A, 68 I don't want it to look like this: Product A, 12 Product A, 37 Product A, 19 Product A, 68 Instead, I just want it to look like this: Product A, 68 Just one row and ORDER QTY summed together, grouped by Product. Is there a way to do this in a view? I've struggled with this... I can't
Can I fill Checkboxes from spreadsheet data?
I'm looking for the option to have a user pick an option from a pick list, and then have the script check boxes in a list from the data associated with that option. For instance if I picked Tennis from the list, the script would check 'racquets' in the equipment check list 'courts' from the location check list and 'college' from the level list. Any suggestions?
again VERY slow
since yesterday, saving Creator script is again extremely slow ! why is this happening so often ?
Another Lookup field criteria question
Need some help here. I have 2 forms called Action and Request. The Action form has 2 fields Tool_num and Category. The Tool_num is also common to the Request form. I want to add a lookup field to the Request form that will return all of the Category data that also matches the same number entered into the Tool_num field. The user can then picks the appropiate one from the list. I tried to enter the criteria Category == Input.Tool.num . I have now read through a few forum pages and realise that it
Server is temporaly unable
Hello, We have this message : The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Next Page