Display image on Browse
Hello, Is it possible to display image after browsing? In the sample below: 1. select browse to get the file to upload 2. the image would show in the 'showimage' area before hitting submit thanks david
Problem update field in on update
Hi Harshavardhan , Hi, i have a form without store data. I insert password and populate other two record (Cognome e Nome) with data in table Piloti. With this script inserted in On click event button: if (count(Piloti[PASSWORD == input.Password]) == 0) { alert("Pilot not found"); } else { rec = Piloti [PASSWORD == input.Password]; rec.status = "Confirmed"; } Have a problem similar to quoted one, but i intended do made my script in on User Input Field. So: 1- Have a form named Reservas
Trouble with large amounts
I have several currency fields (CAN) defined as 20 max with 2 decimals. When I enter 1000000.01 it saves fine. When I add one more digit 100000000.01 I get a message in the lower left corner of my form that says View error details. Clicking on this message does nothing. I am using Firefox. This is a stateless form used to enter some data in a master form. If I enter 1000000000.00 in the master form and then view it in the stateless form it displays as 1.0E+9. Both forms have the field defined as
IT Asset Manager
I am looking for a way to add locations - I don't see a way to do this..
Formula Labels
Is it true that formula fields cannot have a space? I'd like my formula field to dispaly as "Full Name", but I can only get it to display as "Full_Name". The underscore character looks out of place since the fields right under the "Full Name" field is the "First Name" and "Last Name" fields (no underscores). Thanks for any insight. Jeff
Receiving the following message when trying to access a shared application
The message I am receiving is this - "You are not authorized to access this application."
Advanced scripting - help available?
I have seen some sample scripts in "Tips and Tricks" area of Creator Help Center, and become very interested. For example, the "subform" workarounds, which use advanced scripting to define functions. One function is this: ((( "<a href= '#' onclick=window.open('/showForm.do?zc-appname=meeting-tracker&zc-formname=Add_Meeting_Attendance &link=true&sharedBy=" + zoho.adminuser) + "&meetingid=") + ID) + "&nexturl=javascript:window.close();','_blank',' width=650,height=420')>Add Attendance When I want to
Email Notification Body
Hey all, I'm new to Zoho Creator and think it's really amazing. I have one question though. I've created a form and would like the form's contents to be sent in the body of the email notification. Does anyone know how to do this? Any help is GREATLY appreciated! -JoMo
settings for time
What determines if time is added to the date? We have some data where it seems to be missing.. Can I change the time to 12 hr clock instead
Can get simple filter criteria to work on view
Hi, Sorry its probably me being really stupid but for some reason I cannot get a view to show records only for the signed in user. I have a 'Personel' form with employee details and obviously I just want most users to see their details. Here is the script for the view: summary Personel_View { displayname = "Personel View" show all rows from Personel [Employee_Email == "zoho.loginuserid"] ( First_Name as "First Name" Last_Name as "Last Name" Employee_Email
Deluge Script - Share
I'm having difficulty using the share function. I'm using it in the On Add - On Success area: sendmail
[
from:zoho.adminuserid
to:zoho.adminuserid,"yourname@domain.com"
subject:"Subject of the email"
message:"Your message"
]
share form("Create_Clan", input.register_email); How do you use this correctly? Can the zoho variable zoho.loginuserid be used or do you have to use an input field that contains an email?
Hide field on Form... shared user cannont edit in View
I've created an RSVP form for a class reunion website. Two fields (payment, $ amount) are selected as hidden. This works perfect... the field do not appear on the embedded website form. I created a View for the person who is collecting the registration fees. The view displays the "Full Name, Payment, and $ Amount." When sharing the view, I selected "Edit Records and Bulk Edit." When the shared user accesses the View, he is able to "bulk edit" the "hidden fields." When he clicks the "Edit" link for
Errors
Building the form is a little laggy, in addition when I use "Add Notes" tool in more than one place it screws up frequently. Switching between forms view and script view the Choices I populated in the Dropdown box are not remembered or saved properly.
creator
Hello, I have embedded a form from creator into a website. However, the form hangs up (only reads, "Please wait") on the following browsers using a pc: safari and chrome. Seems to be working fine on firefox and IE. Can anyone help?
Dropdown show multiple fields
Hi in my form several fields will be hidden. I want a dropdown field with 1-7 in the list. I would like it to show the hidden fields on selection. Lets say we select 5, I want it to show all fields from 1-5.
Set Criteria Question
Is it possible to check multiple forms for data in a single import picklist? If so, how?
Application timeout
In IE7, application keeps saying Data Added Successfully but times out > logs me out. I must log in again to add another item each time. Oddly, there are random instances where I can continuously add three or four listing without a problem before it occurs again. Anyone know why this might be?
Unsightly underscores in formula labels
It appears that when you create a formula field, the field name cannot contain spaces. Hence, "Full Name" turns into "Full_Name". This looks bad especially when a regular field name is displayed without underscores (e.g. "First Name"). I can understand if there is a requirement that the database field name cannot have spaces but then there should be a display name that can have spaces. It would be great is this could be changed. Thanks, Jeff
integration with ZohoCRM
Is there a way to build an app integrated with ZohoCRM (not CRM application)? I am talking about the ability to get the verification, lists and dropdowns from ZohoCRM tables and the ability to post data into it... thx, David
Permalink not working in IE
Permalink without login for html view is not working in ie Requires authorization.
Lock column TITLES in List view
Excel allows you to lock the column titles in their spreadsheets so that when you scrol down you keep the titles columns frozen or in place on top. This would be a great feature. George
Header & footer for printed documents
Hi everybody, I have set up a nice invoice template with a HTML view permalink. I used table HTML tags to build my layout. My problem is that I want images (.jpg) as header and footer of printed document. Right now, my header is ok on the first page only and my footer is only on the last page and is not exactly on the footer position (can be on the middle of the page). Example of my code : <div align="center"> <table width="800" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr>
Parameter data types in html view
Hello, I'm working on an app that allows a business to keep track of customer information (form = Customer_Info, each with a unique Customer_Number field) and their related orders (form = Order_Form, each with a unique Order_Number field). I'm doing just fine passing these parameters back and forth between various forms to access my data wherever I need it (using fetches), but I am striking out when it comes to using them in Views. I have had success filtering views using my unique identifiers by
Filter picklist based on picklist
Hi, I am not sure if this particular question has been asked before: I have designed a database using (modified) normalization. Two of the forms: frmAgency and frmAgencyVenue, are listed below with the relevant fields. frmAgency AgencyID (Number field) AgencyName (Single Line field) frmAgencyVenue AgencyVenueID (Number field) cboAgencyID (Lookup field)** AgencyID (Number field) VenueName (Single Line field) ** the cboAgencyID looks up the AgencyName from the frmAgency form. I then use the
Performance today is miserable. Cannot use Creator response time is not acceptable.
Is it just my application or is everyone else having abysmal performance. Minutes to return simple views. If your reading this and your app is slow then chime in. Tony.
Have a form in a form
Hi I think I have read something about this previously in the forum. Is it possible to have a link to a form in another form in my existing form? BR Skouboe
In view mode: color formatting for each row, depending on the data it contains
Hi all, I am a totally newbie on ZohoCreator. I want to know if it is possible to colour a complete row, depending on the data it contains. For instance: If there is no data on a field, color the entire row in green. If there is data on this field, color the entire row in red. If a field contains "Review", color the entire row in yellow. ... Could this be possible? Thank you in advance.
Problem in form design! Help me!
In my application i have two tables: 1) table 'Contacts' with fields FirstName, LastName 2) table'Tickets' with fields Contact, Date, TypeOfTicket Problem: in the table Tickets the field Contact takes data from the table Contacts but i can only see only one field in the combobox...it would be nice to see for example.... LastName & " " FirstName, not only LastName
How to add More years under Year Dropdown list
Hi, I love using zoho creator. I have been using Expense Tracker, I customized it to suit my requirements. Under Vies and reports for Viewing Expense Pie Chart, We have only year 2008 available under the year dropdown list. Please let me know how to add more years under the drop down list. Cheers!!! B.Chandar
Make duplicate of appl. incl. data
Hi I have duplicated my application. I know that my data is not duplicated as well. But.... ... I only need to make some few tests and it seems to be quite extensive to create the test data manually. Is it possible to duplicate the application and the data somehow? Via the backup? BR Dennis
Calendar type view - change First Day of week
Cannot find how to change First Day of week to Monday in Calendar type of view. Can anyone suggest?
sendmail help
I am trying to create a function that will email out overdue notices to employees who have overdue items checked out. I want it to email out one email to each employee with a list of what they have that is overdue. Currently, it sends out one email to the first person with an overdue item with everyone's overdue items in that one email. My current code is below. void itat.sendEmailOverdue() { x = Checkout_Items [(Issued == "True" && Due_Date < zoho.currentdate)]; overdues = ""; for each x in Checkout_Items
Import Excel XLS Portuguese Characters bug
Dear ZOHO Creator Admin, I'm trying to create a new application by importing a simple Excel xls (table with 7 fields and 400 records) in ZOHO Creator. The fields headers and data type are properly identified but the import process does not recognize the Portuguese characters (ex.: "ç" and "á" --> "�"). I'm using: Excel 2003 (english version) Firefox 3.0.5 (english version). Is there a solution for this problem? Best regards, Luís Miguel Silva
Need HELP ASAP
I'm having all kinds of trouble importing data from an Excel file! We are about to puchase this app but it does us no good if we can't import old data to get us started
Bug with different browsers
Hi, I would first like to say that I am loving Zoho business! I am very impressed with all of Zoho's offerings, and I think that Creator is one of THE best application in the Web 2.0 world. Like some others users, I await the support of subforms, and would also like to see an advanced query builder as well. But on to the reason I am posting. I have found that Zoho Business (the desktop in particular) reacts differently with different browsers. I like using Chrome for browsing due to the speed of
Any Photo rating / voting scripts ?
Hi there, I am currently using Creator as a database for images, and was wondering if there would be any form of photo rating scripts for my visitors to vote that I can incorporate into the website? Many thanks Steve
Help in importing data - Need help ASAP
I can import from form view but the records don't show in list view- I really need to be able to import old data. We buy a license as soon as we know this works!
Error with form
For some reason when I try to add data using my database's form, I get this error message: "No such file store. kenderbard" Is there some way to solve this?
Data import date field
I have one csv to import with date fields but when I run the Import in zoho It doesn't work. For example to import de field "date" 14/08/2008????? It doen't work with 14/08/2008 or 14-08-2008 or 14/08/08 What's the format I have to use in my csv??? Thanks a lot. Sergio
Cannot log in with my account
Hi I have a system that I share with some of my users. I have created the different users which until now are approx. 15 users. Unfortunately my users can change the password as they like. This is maybe what have happend to me. I cannot log in with my account. Please help me on this bug urgently! Br Skouboe
Next Page