Time Field rather than Date&Time
Hi I would like a time field that people can enter times into my form but I would like the field to be formatted like '18:00' forcing the use of a ':' Is this possible? If so, how do I do it? Cheers
Bug: scroll arrow has disappeared in Free-Flow Field Actions box in one Form
While working on the script for one of my forms, the scroll arrow in the Field Actions box in the Free Flow editor has ceased to appear, though it does appear alright in other forms. I've restarted browsers (tried 3 different browsers, too) -- all the same result -- no scroll arrow anymore in this particular form. See screen grab here: The form is named "Contacts". I've shared with Support. Please advise asap. Thanks. Datazen1 datazen1@gmail.com Santa Fe, New Mexico US
Invalid Entry when insering records with dropdown
We are having trouble editing existing records in our database. We have a number of fields where you select from a drop down list. When one or more of these fields is updated (Issue Status, Subolder 2e), the system throws an error. We have been trying to troubleshoot, but to no avail. Please help ASAP as we are in the midst of production
How do I recieve requests via e-mail?
How do I receive requests via e-mail
Shared Apps list
I've been working with Zoho creator for over three years. In that time several people have shared their apps with me. They all show in the Shared Apps section of my account. Some of them I no longer need to access.Even applications that no longer exist or have been unshared still show on my list. Is there a way to remove/hide them from the list? Herb Wexler www.PreventingMediocrity.com
Import data via email and transform
Hi, I use a web based system in order to order products from my wholesalers and then send an email to the location receiving the stock letting them know what I have ordered. The information on the lines that are ordered is in the format of a table. An example is shown below: Product Pack Price Quantity Total OOS Widgets (Some Details) More details 28 £14.81 10 £148.10 After I send an email to the location, they have to enter the goods received into our stock control system. The stock
PDF blank - site not too fast
Hi, in our application consulado-geral-do-brasil we experienced delay in contact the server and the application that allow to print PDF don't run more. Every day we use this application without problem, but yesterday start print blank pdf pages. Today still doing it. Thanks Mic
Dropdown Listbox Size is too narrow
I am having trouble witih some listboxes that are too narrow and not allowing me to see the label in full. How can the size be changed to allow each entry to be seen? Thanks
Problem with updating listbox
I'm getting this error all of the sudden with one of my listboxes. Please see below and advise: Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDR; Tablet PC 2.0) Timestamp: Thu, 9 Sep 2010 21:30:37 UTC Message: Syntax error Line: 1 Char: 1 Code: 0 URI: http://creator.zoho.com/ogreports/ogreports/ Message: Could not complete the operation due to error 80020101.
Zoho Creator Calendar - Can an entry span several days?
Hi I want to use Zoho Creator Calendar to represent activities that will take place over several days - How can I do that? Thanks. EK
show records in view with data after current date
Hi, I am trying to create a view where criteria are set to only show records that have a date after the current date. I tried as in the attached screenshot. But that doesn't work. If I click done the row is actually not saved. I hope this is possible? Rob
Zohosheet API problem
I'm trying to create dynamic charts as described in "Creating charts using Zoho Sheet API" but the returned chart doesn't show any data. (See attached) The command used was http://sheet.zoho.com/zohochart.do?&charttype=LINE&chartdata=1,2,3,4,5,6,7,8,9 and should retrun a line chart with a diagonal line but no line is present. Am i doing something wrong in the code?
Please explain why saving ZC scripts take so long
No doubt every Zoho Creator developer has wondered why it takes so long for a seemingly small script to be saved/updated from the editor view. So, it's obvious that the script gets uploaded, it's syntax is checked, and the script is compiled, or whatever processing happens on the server side to make it ready to use. Since saving script updates is something a developer does countless times a day, this slow-down in the workflow is more than just a little troubling. If you would, Zoho Creator support,
New update of PreCreator
We have updated http://precreator.zoho.com with a new feature that allows users to add new entries for lookup form. Consider 2 forms as below. 1. Author - Author Name - Bio 2. Book - Book Name - Author (Lookup of Author Name from Author form) You can now let users add entries for Author from Book form. As seen above, there are 2 options - Link text for adding new value - Text to be displayed along with a + symbol. If left empty, only + symbol will be shown. - Link text Alignment
PDF broken again
PDF broken again
How to search for a field with anything in it?
How do you select (in a view) a field that has something, anything in it, but not nothing? e.g. I have a field for email addresses (this is a bad example because I could search for the "@") How would I select all the fields WITH email addresses filled in?
set email notification
Hi I'm using the free version. I want to set email notification when someone submits a request. When I try to edit the form to do that it says I don't have permissions to edit the script.
Sound in Creator??
Is there anyway to play a sound (.wav) file in Creator?
how do i take the ending value for a field and make it the beginning value of a different field?
Yes, i want the ending volume of the previous record to be the beginning volume of the next record. i have also provided edit access. in our winery every action starts with a beginning volume (bvolume) and ends with an ending volume (evolume). by way of example: Chardonnay beginning volume = 1000 gallons chardonnay filtered Chardonnay ending volume = 980 gallons The next time i open this field, i would like the beginning volume to show the ending volume (980 gallons) from the last action. Can anyone
Zoho Creator and mySQL
Hi, I am developing a bid tool for our freelancing website (developed in Joomla). I am wishing to integrate the application in the website and make use of the mySQL database in which the freelance project postings are stored. Is it possible for me to access the information from the mySQL database, if so, how? I hope someone will be able to help me with this. Regards, Rey
Zoho DB - Is it available?
Hi I heard of ZOHO DB product which is supposed to be more advanced that ZOHO Creator. Is this product available? How can I take a look at it? Thanks. EK
How to order the data in a table according to dates?
Hi, I have made an events form and a view of this form. When the user enter data with the begin and finish dates, I want the for to be ordered according to begin date putting the nearest event to the top followed by the coming dates. However when the current date is later than the finish date, I want it to be automatically removed. For example today is 08.09.2010 and there is an event beginning on 08.09.2010 and finishing on 10.09.2010. I want it to be at the top due to its begin date. On 11.09.2010
create search/browse form
I want to create search/browse form in my website so that web user can get data from google/zoho or similar spreadsheet as per options he has choosen from given options. (e.g if he chooses sex:female, education: graduate; then get name, link of all person from that spreadsheet). I have tried a lot but cannot able to find simple steps. Please enlighten me & give me simple steps (i am not technical geek) !!!
Quickest way to modify a form
please view my form here: FORM As you will see it is used as an application for prospective employees. There are hidden fields that assign the corresponding manager to the applicant based on the location the choose to apply for. The trouble I am having is that our company is adding and removing locations frequently. What I do now is edit the form by adding or deleting the location, then I go in to the script and add/delete/edit as needed. if (input.Location == "Auburn, AL") { input.Assign_To
1 @dres, different accounts possible?
Dear sir, madam, My colleque made an acount for tasks we share and it works great. I wanted to make an extra acount tot share with another colleque voor other tasks. I used my work @dress, but its not possible to have more acounts with 1 @dress? greetings, Emma I
Zoho Creator - Editing problem
Having problems updating records. When I go to edit a record the bar just sits there for ages and nothing happens I think it could be siomething to dio with Antivrus (Norton 360) or java update. Can anyone help. Thanks Peter
HTML not supprted in the scheduled emails?
I tried both in my account in one of my clients' account, but I've got the same results. I made a custom schedule - an email with attached xls reports. The problem is that the email is sent as plain text, and the html tags appear in plain text (<strong> , <br> and so on), even if content type is html . Is this a known problem in Scheduler? Regards, George
Zoho Calendar and ICAL feed
I have a ZOHO app with the following items. Single Line Called TITLE, a multiLine called DETAILS, a Drop Down called ALLDAY and 2 date-times called STARTS and ENDS. I want to change it over to an ical and import it into ZOHO calendar. For some reason when I go to my calendar and click subscribe to and enter a url UNDEFINED pops up in the corner and nothing loads. Any ideas why this would happen. Here is the link I am using https://creatorexport.zoho.com/tulsadirect/mycal/ical/CALDATA_View/5nvZsm4GVqKJw2uBSvxArBvnCdya4XTJKEMQbUrv70g5HeP9M67QYCW2Wf6a2zTFwmvVF09ZBrDeMGUM6BXAO3VFBUQw7bG6dE9x/DTSTART=STARTS&DTEND=ENDS&SUMMARY=TITLE&DESCRIPTION=DETAILS&ZC_FULL_DAY_EVENT_VAR=ALLDAY
Please clarify issues re: PRECREATOR server
I'm wanting to check out the PRECREATOR dev server, but have a quick question or two before doing so. 1. At this link (https://accounts.zoho.com/ui/unauth/authorize.jsp) there is a disclaimer that on the surface seems concerning, see the red arrow below.... Question: What should I understand about this statement? Is PRECREATOR not under the responsibility of Zoho? Why is Zoho distancing itself from PRECREATOR in this statement? Does Zoho truly have *no affiliation* with PRECREATOR??? How
How to publish data entered after approval by the administrator?
Hi, When a user of mine fill a form and submits it, I want it to come to me for approval first. When I approve it, it shall automatically enter to the database. How shall ı do it? Thanks a lot, Vera
How to add data after the activation link is clicked in the confirmation link?
Hi, When a user of mine fill a form and submits it, I want a confirmation mail to go the mentioned email address in the form and I wan the data to be accepted to the database only when the user clicks the activation link in the confirmetion link. How shall I program it? Thanks, Vera
How to navigate the user to a specific url according according to the options chosen in a multi-select field?
Hi, I have a form which will be two pages. When the first page is filled, I want the submit button to save the datas and navigate the user to an url (the second page of the form) according to an option he has checked in a multi select field in the first page? Is this possible? Thanks, Vera
Cannot delete record
I have two records in my database that i cannot delete or update. i am not sure why and have tried modifying fields in hope it would delete. Still no success. If someone could look into this and possible remove the records that would be great. There are two records both for the company Array Studios. The error i get is as follows Error details: Error occured while executing on delete - validate script. on invoking a function deleteRecord Unable to update variable newCnt Invalid Numeric Format found
Adding Zeros before Number in Number Fields
In our forms we added a numeric field with a max of 3 digits. We sort our customers by these numeric fields. Our numbering system start at 001 and ends 999. We would like for these numeric fields to auto populate to 00# or 0## when less then 3 digits are entered. Is this possible? Thank you for your assistance and quick response.
idea for user rights
What I would like in sharing views and forms is to be able to copy the user-assignments I currently have for a user to another user. That would allow me to assign the same rights to a new user as a current user. Or for example when an employee leaves I can easily transfer the rights to the new employee (which has a new account). Even better would be if we were able to work with groups of users or with roles.
Does ZC able to create Effective Dated record?
i am designing an ERP via Zoho. But according to client requirement, it's needed to keep track all their staff's movement of any detail among the company. Eg. promotion, when is hired, when is transfer department and a setup of X calculation also vary among time (support back-dated will use different rate for computation) So, i go through some basic tutorial, but didn't find a way to friendly way to keep track Effective dated records. (wonder if there is any in ZC)
how can i chance my username
Hello Good day, i would like to ask some information. regarding in changes. such as if it is possible if i can change my username?? barely need you answer right away.. many thanks regards, reich
the word null during string concatenation
i created a field called Full_Name which is a formula field. the formula is: Salutation + " " + First_Name + " " + Last_Name if there is nothing in the Salutation field, the results are null firstname lastname, for example: null Joe Brown how do i stop it from including the word null when there is nothing in the field. thanks.
Input Validation with Known Data
hi all, I have imported a list of email addresses using a CSV file ....... how can I validate "On User Input" that their email_address exist (ie. authorized to move forward) vs email_address that does not exist (ie. error message saying email not found) thanks in advance
Zoho asks me to upgrade my account, why?
I was testing my application, VirtuLIMS. An error message appeared : "invalid entries found" And on the top of the screen : "This application is disabled. To do any action, you need to enable this application in the Home Page orUpgrade " WHY?
Next Page