Bug in Safari browser: "Add Note" widget does not insert into form properly
If using Safari version 3.2.3 (5525.28.3) with Zoho Creator, and you try to put an "Add Note" widget into a form, it doesn't work. You don't get the Add Note editor to appear at first, then after a few tries you can get an oversized Add Note editor to appear, way too big for the window and with not editing tools appearing. A definite bug. I checked Firefox 3.0.10 and the Add Notes still works fine. Thanks for investigating. Greg
Upload file - Client Side API
Hi all, I'm trying to add a Upload field in a html page using the Client Side API, but it doesn't show up. All other fields from the same form are no probleem. Maybe I am forgetting some special settings, like with a picture field ? code: <td><script type="text/javascript">Zoho.writeLabel("ImageUpload");</script></td> <td><script type="text/javascript">Zoho.writeInput("ImageUpload");</script></td> The label shows, but the input field not. I also couldn't find that
Unable to share or publish my application
I have an application with the name of "Accounts", that works well. But whenever i try to copy it over to my friends' app, it pops lot of errors that doesn't seem to be meaningful. All the errors seem like would work. It gives error on code like: "thisapp". I have opened the app for support. It will be great if somebody from your side can look into it. I want to publish this app. Thanks.
Fetch and display multiple records from stringlist on user input
Hi, I'm a newbie developer. I'm trying to figure out how to write a script, but my brain is hurting. In a form called Add_to_Assignments I have a lookup field called COMPETENCY_A_A that's displayed as multi-select checkboxes. The data is from a form called Add_to_Competencies that has two fields: COMPETENCY and AREA_OF_KNOWLEDGE_C. In the Add_to_Competencies form, the AREA_OF_KNOWLEDGE_C field is a single-select dropdown lookup from a form called Add_to_Areas_of_Knowledge. What I'd like to do is
can's use == operator on checkbox results
I have a registration form where i am trying to have people select lunch for Monday Wednesday Thursday Friday Saturday Sunday I made this a checkbox field so they could select which days they want lunch. Lunch is $10/day I am trying to add up the number of days they selected and I can't do it. If I say input.lunch_days == "Wednesday" I get the error Error in statement at line number 1 The Left expression is of type STRINGLIST and the right expression is of type STRING and the operator == is not
Allow developer to turn *off* starter-scripts in ZC, and remember scripting tool mode
Anyone that scripts more than one or two forms no longer needs the "helper script" stuff, i.e.: //You can drag and drop tasks from the immediate left pane
//Below is the SAMPLE script for dynamic, condition based field manipulation
if()
{
show field1;
enable field1;
} I, like may, wind up developing lots of forms and scripts, and find this "helper script" stuff pretty annoying and something that always needs deleting. Please enable the user to turn *off* this automatic helper script and
Creator Maintenance
Dear Users, Creator will be unavailable for a short period of time. Kindly bear with us. We will intimate you once it is up. Thanks for your understanding. Thanks, Hariharan
Maintenance is in progress...
Hi, Did I miss something? I didn't see any announcement for this Maintenance. How do I know when maintenance is scheduled? Best regards, Ivan Netherlands (it is mid-day here...)
openurl in parent window issue
I'm using the following command on a successful form submission: openUrl("http://myurl.com/payment.html?paymentAmount=" + input.registrationCost, "parent window"); I have the form embedded in my website on some page. In IE, this works as expected. However, in Firefox, nothing happens. It just spins with a message of "Please Wait...". I can see that the form data is successfully submitted, but the browser never redirects to the payment.html page. Any thoughts? To see this issue in action, go
How do I count the size of a collection? It's harder than it looks...
I'm trying to write a function to return the number of records in my table Contacts that are active members (defined by a formula member_is_active). I would think I could do something as simple as this: int members.getActiveMemberCount() { c = Contact [member_is_active]; return c.size(); } However this returns the error "the variable c is not defined" on the line with the return statement. I think this must be a bad error message and what's going on is there aren't any built-in functions
Deluge: can a field reference itself (instead of specifically referencing itself by name)?
Is Deluge capable of allowing fields to reference themselves, instead of specifically referencing itself by specific name? I.e. User checks a decision box called "iwantblue". The following script would run "On Update": if (input.someotherfield == "Blue") { alert ("You have already chosen blue; choose another color."); self = false; } meaning the box would become unchecked after an alert box, instead of: if (input.someotherfield == "Blue") { alert ("You have already chosen blue; choose
Missing Columns
I have been using the same Creator App for over 6 months. For some reason this morning .. one of my Grid views has no data columns showing at all. It use to have 20 data columns in view. I have not made any modifications in weeks. When I go into "Edit Application" everything still is the same where all of the Column properties have the "Show" column clicked. I have tried making some small modifications saving/viewing .. but still the data columns are missing. Any hints? -bob
Newbie question: if statement in a Formula field?
Hi everyone, I'm new to Zoho and am building my first app. I'm pretty excited by what I've seen so far and look forward to learning more. I've got what is probably a simple question. I would like to generate a Formula field called Name Line that displays either the individual's name or the business name depending on the value of the field contact_type. I tried the following but got an error saying it didn't expect an "if": if (contact_type == 'Individual') { name } else if (contact_type == 'Business')
Modification date
Hi, I'm a newbie to Zoho and had a question about something I do routinely with my records, namely adding a modification date. The idea is for it to get automatically updated whenever somebody edits the record. What is the best way to do this in Zoho? Thanks, Kevin
Suggestions about Layouts with large number of items ...
@ZOHO Creator Support Team: Some of my clients prefer the Tabbed Pane Left style of layout ... however, when the left panel contains a large number of section links ... and the user scrolls down and clicks on one of the links at the bottom of the list ... the resulting (right panel) Form/View is rendered without reseting the scrollbar ... so if the Form/View is not so large (tall), it is confusing to the user as he/she sees a blank right panel. Suggestion: After rendering the content in the Right
sorting view
I would like to be able to sort a view based on a field that is not visible in the view. For example, I have a date field that I want the list in order by date, but I don't want the end user to be able to see the date. Can this be done? Rob
java.lang.Long error details
Hi, I create an application in creator (username:ventaspeb, app: control de ventas peb), but when i'm in cotizaciones view i get this "java.lang.Long" error, could you help me please?
Deluge Dilemma - Australia
Zoho Creator Team or patient Zoho creator programmers. My name is Mark. I decided to try and build an online BOOKING program myself for my small rental business because I had been let down by so many programmers in the past. I handed over $ 7,500.00 to a company in Brisbane Australia who took my money and produced virtually nothing and six months over due, before I had to cancel them and try and find someone else. I never got my money back. And I have had silly quotes since then, for something
Cannot create Chat View
Hi. I am trying to create a chart view but I am prevented from doing it as the listbox where I must choose the base form is empty. I have a form created. The form is displayed in all other view creation wizard listboxes except in he chart one. Is it a bug or am I misusing it? Thanks
Need help please for campaign database...
I have a few questions and i'm a total noob at zoho, but this looks like what I need. First off how do I, Change the form background colors to transparent or another color instead of white to match my website? How do I get rid of the Zoho Creator symbol on my forms? Can this be done if I upgraded? Forms, I'm trying to create several forms for my website's WW2 campaign. I created/need the following forms, 1. New Unit Sign-Up - This form displays the Unit's name, leaders name, website info,
Issue Manager
Hey great application. I'm looking it over for our project. We are not building software but our project is to transistion a very large effort to a new vendor. My issue types are different. How would I alter the dropdown issue types to match my projects need? Thank you.
Field updating
Hello guys! I'm working on a application that has a form for Material request. This one will record the form ID, the form status (OPEN or CLOSED) and the total amount for the request. The form is named MATERIAL REQUEST and its fields are: DATE, PROJECT CODE, LOT, REQUEST ID, TOTAL COST (this data will be calculated from the information of another form) and STATUS. The status field may be OPEN or CLOSED. The idea is that when a request is closed, no more materials can be added to it, but this will
Reference Formula Assistance
I need some newbie help on a formula in Zoho Creator I have 2 fields I need to do the formula on Field 1: Todays_Inventory Field 2: Todays_Shipment I need to do the following formula (Todays_Inventory - Todays_Shipment) - [The entry for Todays_Inventory in the previous record] How can this be written to look into the last record entry and pull the data number for the Todays_Inventory field? Thanks in advance.
Problems viewing X-Axis Labels in a Chart View
I am having a small difficulty with a Chart View of a Line Chart in my Zoho Creator application. If you reference the attached sample image, you will see that on the X-Axis, you can not see the axis labels. The X-Axis is set to match the "Date" field, however, You can not see the dates on the image. One 1 chart, I the labels were drawn at a 45 degree angle automatically, but I can not seem to find how to do tell this chart to do it. Also, how can I set the chart to in chronological order to where
Generate records
Hello, Can anyone assist with the following, I want to generate records based on input field value on Input Form Eg input field = 8 Therefore Generate 8 records I can insert 1 record ok but need to perform routine below (8 times in this instance) insert into Input_Results [ Added_User = zoho.loginuser Competition_Event = input.Competition_Event Event_Year = input.Event_Year Month = input.Month Result = "Pending" Start_Date = input.Start_Date
problem with created form
Hi! I am using the webtool enabled by zoho.creator for academic research purpose, and it worked very well until now... Three days ago, I copied a pre-existing form, and worked to create a new form with some differences. But it does not work! I don't know what it is happening... the permalink is: http://creator.zoho.com/hamagust/parq_base_tec/form-perma/Parq_Base_Tec_Form/ Help me, please! this link is already available for respondants... best regards, Tomoe Gusberti
Adding data via email....
The graphic on the product overview page says you can do it... but I'll be darned if I can find it. I have a few dozen sites that collect data and email it. I'd like to pipe that into my zoho db but I can't figure out how. After 30 minutes I give up and ask for a link or other instructions. thanks
Dynamic Field Names (referencing fields on the fly)
I have the following code fire OnUpdate for my input.banana Decision Box field on my order form: if (input.banana) { input.total = (input.total + input.banana_cost); } if (!input.banana) { input.total = (input.total - input.banana_cost); } When a user checks the Banana decision box, the Total field gets updated with the amount in the hidden field banana_cost. Now, I have to perform this same function (hint hint) for 3 more fruits: apples, apricots, and grapes. I've attempted to
How to get the correct record ID from a selection in a picklist where there are multiple records with the same criteria?
This is a tricky one that doesn't seem to be addressed directly in the Deluge documentation, unless I've missed it. A lookup-picklist displays a list of names to choose from. In that list there happens to be more than one listing with the same value, e.g. "John Doe" and "John Doe". When a user selects one of the "John Doe"s, I want to know the record ID# of the selected "John Doe". But... if I use the method seen below, how do I know that the ID grabbed is to the *correct* John Doe that was
Add record from flash application
Does anyone know if I can add data directly from a Flash-style web-app. I simply want to post the score and name from an on-line quiz. The main issue is that I don't want the user to be able to edit the score before sending. Taa
Free account users, can't get the second free user
Hello: I have a free account that can include two users, but when I try to share an application, with myself as the only user, Zoho tells me that I have to upgrade to the paid version. Thanks Alberto
hello, i have a question.
may i know how can i embed my free zoho creator form? please. i want to embed this on my website.
"Date-Time" field data being cleared on Edit if field type was originally a "Date" field but changed to "Date-Time"
If you put a "Date" field in your form, and then reclassify it as a Date-Time field, and then use it in a live form, whenever you go to edit a record in that form the Date-Time field will be cleared, causing loss of data if you re-submit the form. This does not happen if you start the field as a Date-Time field (i.e. not as a converted Date field). Bug.
help with embedding views
I have a view that when I copy/paste the html, the end user sees the "edit" option like an admin does. I thought it was because I was still logged in to zoho so I logged out and then it asked me for a password even though the "embed in your website" setup box says "through this code snippet, you can access the view without login" Please assist. Also, when I use the "get javascript snippet" it works fine. Thanks Rob
Upload contact info from zoho contacts or reports to CRM
Using the Zoho CRM,how do you upload or copy over all your contacts from zoho contacts or from zoho reports. Cannot tell I have to physically enter in every single one,must be a way
Send email on date
I have a view that contains dates and email addresses where multiple emails addresses are related to a given date. I can, of course, login to Creator, select a date, and have that action send an email to all the corresponding email addresses. My question is can I have the system itself do that automatically? What I'd like is for the system to once a day, see if the current date matches an entry in my view and if so, send an template email to all the matching email addresses.
Trouble sharing forms and views
I cannot figure out how to alter the list of shared forms and views that is shown in the Share Tab of my application. The email address of each user I'm sharing with is shown, with a link to the right that says (for example) "9 Forms and 11 Views". Clicking the link, it shows me a wonderful list of all the forms and views in my application, the shared ones are green-- the unshared ones are red. But I cannot find a way to turn the sharing on or off. Some of the red ones need to be green, and vice-versa.
Feature request: Ability to search through all scripts in an application for word/phrase
I find myself wishing to find a certain code snippet buried in one of my many scripts in many forms, and searching for it manually is time-consuming and something done better by software. Could you consider adding a "Search All Scripts for: <word/phrase> " functionality to ZC? Would obviously be Freeflow oriented. Greg datazen1@gmail.com Santa Fe, New Mexico US
Deluge Dilemma - Mark Australia
Deluge Dilemma Zoho Creator Team or patient Zoho creator programmers. My name is Mark. I decided to try and build an online BOOKING program myself for my small rental business because I had been let down by so many programmers in the past. I handed over $ 7,500.00 to a company in Brisbane Australia who took my money and produced virtually nothing and six months over due. I had to cancel them and try and find someone else. I never got my money back. And I have had silly quotes since then, for
Logo
Some time ago, I asked about the possibility of having a designated logo for an app, instead of a universal logo for my account. I have got no response. Is it at all possible? Thanks.
Next Page