Online Survey Thank you email
Hi Zoho developers and community! Is there a way that I can send a "thank you" email automatically to those who have filled out my surveys in zoho creator? granting that the one who took the survey filled out the email address line? Thank you!
Search entire application
Hi All, I have the need to search and replace in my entire application. I know this has been asked for before in this forum but I cannot find the answer. I apologize for the resubmit... Even if there is not an inherent way to do this in the IDE is there a way to export the entire code base to a text file to do a search? Or some other work around? tt
Wildcard search
Ok guys, I am sure Zoho must have a wildcard search but I'm not sure what it is. Lets say I want to search for 'Kevin' in my name field and have it find: 'Kevin Smith' 'Kevin Jones' What is the correct syntax in my Fetch command? Thanks! Kevin
Using Look-Up Field To Display Price
How do I set it up so that the corresponding price shows up in another field based on the item chosen in a look-up field or possibly two look-up fields? Simple example: Item Color (look-up field #1) + Item Size (look-up field #2) = Corresponding price from the same record.
Can I set a status message?
Hi gang, I'm writing a view that does some processing of records then calls openUrl to go back to the main list view. I would love to set a status message that tells the user "operation complete." Is there some way I can do this, like adding a parameter to the url in my openUrl call? Thanks, Kevin
Either SORT RANGE is broken or I am an idiot
This issue has been fixed!.... Dated 6-18-09 Ok, 99.9% of the time any problems a user is having can be explained by user error or incorrect scripting However, recently all of my app users have been complaining that the HTML page pagination in the app I built for them is completely wrong. The pagination simply does a for each collection with a sort range of 0 to 35 then 35 to 70 I tested this hundreds of times before adding to the marketplace. And the weirdest thing is that Harsha helped me build
Calendar
Hi, I'd like to change the look on the calendar that pops up with the Calendar field. Looks too much like windows 95. I'd like a more modern look. Any suggestion?
(Not ZC specific): programming code for total based on price/quantity
I have a non-ZC related, general programming question I thought I would post here: A = the price of purchaser's 1st apple B = the price of any 2 or more apples, different than A C = the price of purchaser's 1st banana D = the price of any 2 or more bananas, different than C X = total number of apples, can vary, can equal zero Y = total number of bananas, can vary, can equal zero total = ??? I'm having an algebra meltdown and can't wrap my head around this seemingly simple equation...
What is this??
Error details: Error occured while executing on click script. unknown Task : Task personality is 287 Unique constraint Failed for the table t_306497000001242896 The error row values are:t_306497000001242896_PK = 306497000001282211RECORD_TYPE = 2LunaSKU_306497000001242900 = 9999988RECORD_LINK_ID = 306497000001282213ADDED_USER = mbrunner72ADDED_TIME = 2009-06-16 09:05:38.171MODIFIED_USER = mbrunner72MODIFIED_TIME = 2009-06-16 09:05:38.171ADDED_USER_IP_ADDRESS = 24.14.165.82MODIFIED_USER_IP_ADDRESS
date-time default entry
How do I entery a date without a time? Right now if defaults to today's date and current time (to the minute!!). I only need to enter the time on a select few records. How can I make the time default to all zeros?
can't find code to embed in website
Hi I have created a form and clicked on access this application. When I go to the more actions I can only see copy application save as script share this application customise Theme/Layout Where do I find the code to embed the form in my website? Thanks Lisa
Zoho apps
To all Zoho staff...keep up the great work!! I love your apps...
Zoho gives an error inside conditional
I'm trying to count the number of instances of a particular variable, then if the count is above 0, add that variable name to a field. Here is the code: for each account in Accounts
{
account_name = account.Client_Name;
account_count = count(Projects[Project_Status == "Open" && Project_Type == "Chargeable" && "Account" == account_name]);
if (account_count != 0)
{
Account:ui.add(account.Client_Name);
}
delete user
I am trying to delete a user (storysnoopsjn) from my account settings. I have already closed the account but it is still taking up one of my user slots. I can't delete the user or deactivate the user without getting an error code. Please help!
How do I update data by merging
Hello to all- We are an organization that tracks our members purchases from many different vendors. These vendors send us excel spreadsheets that have our member name listed and then what their purchases for the month are. Currently, we look at the excel spreadsheet, pull up the member's record in ZOHO and then update the field that holds the purchase amount for each vendor. Is there a way to merge the spreadsheet so that automatically populates the member's record without having to manually each
forward-back, next-previous in forms
I am trialling the free edition of Zoho Creator and I've noticed the lack of navigation controls in Forms, i.e 1st-last, next-previous. How do I get these onto the forms? Are they only available in the paid editions? Thanks...
Changing field names doesn't update throughout.
I changed a field name on the form but the corresponding field names in the "Field Actions" area refuses to update accordingly. Please advise. Thanks, Nathan.
Chart Lengend not showing properly
I have a line chart that is working okay, and it shows the legend, but the legend only shows a red square and a blue diamond, it doesn't label what these items are supposed to be (see attachment.) Can someone assist in this bug? Here is the chart script: chart SQUD4242N2_Usage
{
displayname = "42x42 2-Way Usage"
type = XYLINE
show all rows from Main
(
x-axis
(
title = "Date"
field = Date_field
)
y-axis
(
Publishing on Marketplace without install option
Hi, I am currently developing an application that I want to sell on the Marketplace. I want this application not to be installed by the users but just want to share it with them when the subscribe to it (very SaaS!). By doing this I will be able to give better support on the application because if there is a problem it will be solved for all users! However, the marketplace does not support this kind of selling. I think it would increase the possibilities for more complex applications! Is this option
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
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.
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
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
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
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
Next Page