Make Form Public but not Data
Hi, I would like the form to be public, and accept visitor's data, but I don't want them to have access to the database. Is that not possible? The link to the form gives access to everything else... Thanks for your help :) Katia
Import data in application/spreadsheet from XML feed
Hi, I want to ask, if there is any way to import data in my Zoho Creator application (database) or spreadsheet from XML feed provided by API server of webpage? I am trying to create online database here in Zoho, previously I imported data from XML feeds ad got neccesarry information from nodes by using MSXML v 5.0 in MS Excel2003. Thanks a lot!
Edit permission for restricted users for a public application (not all apps just the ones I specify)
I have an application that is public. I have given add permission for public to add to my application, however I need to assign edit permission (/admin previledges) to a specific number of people alone and not the public. I could not find a way to do this in creator, any help will be highly appreciated. Thanking you
CSV Import with OpenID?
I created my creator account using a google login. I'm trying to use the CSV import tool, but am not clear what my username and password is. I've tried many combinations ... and I'm a bit suspicious whether the API calls support openid like the rest of the site. I see [Sign Out]johnseq1 and I've tried that, my gmail address, and everything else. Can you confirm which credentials I should be using ( and/or how to identify or confirm these ?) Thanks in advance, John
view-login url not working in IE7
http://creator.zoho.com/<admin>/<application>/view-login/<html view> Works in Firefox, but not IE7. I'm getting "No such view in ZOHO Creator"
picklist width
Hi again, I just discovered that I can't see distinguish between some of the options in my selection field as they are wider than the width of the rendered drop-down list. Is it possible to please add an option to specify the displayed width of these fields? Thanks, Anton AntonL ------------------------------------------------------ This is posted using zohocreator feedback form
New to this!!
In Dreamweaver CS4 I have some images that I would like to 'pop-out' when they are rolled-over. Can anyone tell me how to do this? Many thanks in advance
Basic version reports
Have created only two reports in basic edition, but system won't let me run them unless I upgrade. In the price list it says that I can have two in the basic version. Am I doing something wrong?
Automating a maintenance schedule
Hello, I have created a database with creator where I have the following forms: Equipment Maintenance Providers Recommended Maintenance Schedule Equipment Use History (for example, the hours we put on our tractor each month) I have keyed the unique equipment through the entire database so that it is cross referenced. I would like to automate the process of informing our maintenance providers when a piece of our equipment is in need of maintenance by the hours criteria in the "recommended maintenance schedule"
Specify a Date Range
How do I specify a date range using Advanced Criteria in the View/Edit mode? If found the section on "Conditional Operators" and tried using the operators (&& || !), but I could not get any results.
change or update field button
I am trying to create a used book sale database for our school. Not my first database but my first zoho one. I am stuck on creating a simple script that changes the field from "no" to "yes". From the view I set up a custom action which shows for each record. I just want people to click that button and it will change the book from not sold to sold status.
Seperate User Log Ins
I have one account with 4 seperate forms which are all the same. These are to be embedded into webpages to log in to the form. I want to have 4 seperate log ins for the 4 different users of each form is this possible. Many Thanks Peter
Defined a function and then it doesn't exist.
This error has occurred twice with the same function. In my Maintenance_2 app. I defined a function to generate a code. The function takes three parameters. Generates a code. The checks to make sure code is unique. If it is not, it moves the parameters around and invokes itself recursively. I entered the following code: string codes.code_generator2(string fname, string lname, string full_name) { day_num = zoho.currentdate.getDayOfWeek(); if (day_num == 1) { day_name = "Sunday"; } else if (day_num
Record Edit Error
I am getting the enclosed error when I edit a record in "Grid View" only. In other views the record can be updated with no problem, pls. reply!
customize the file name of PDF
how can i customize the name of a downloading PDF file with a field? I want to name the PDF the last name of the person, right now it downloads as "Printout", the name of the HTML view. thanks, BG
PDF Download not working
I tried to download a Chart and excel file in PDF but it did not work. The PDF comes out blank. Thanks, HHDW
Pulling data from other forms into current form
Hi all, great program! I am new at Zoho and scripting (i do understand the process, but limited knowledge of script language) i would like to pull data from another form in to a current form. i am making a job list data base. i have form called "add company" that collects customer company names and i assign a "company code" to them. i want to build a form for adding jobs that automatically adds the "company code" after the "company name" is selected in the form. The process as follows i would like
Form & Explorer - don't run
Hi, I have a embedded form that when is open with Internet Explorer display only the title. When I open with the browser Firefox it's displayed correctly. There's something that I can do to get the form visualized correctly also in I.E.? Here the link. Anyone have experienced the same issue? Thanks Mic
"Community" pages not updated?
ZC Team, I visited the Feature updates and bug fixes page and I understood from there that there are no new features and bug fixes made since February 23th . From Working on page I understand that Scheduler feature is still in private beta, (despite of the fact that it's written as an available feature on Pricing page) and there are only a few features which keeps you busy, most of them are finished and from the long Roadmap list nothing was "upgraded" to working on list for months. Is this true,
Issue with drop down box
Am not able to see the full text when selecting an option form the drop down box. Only text upto the size of the drop down box is shown. Am currently using IE 6 & 7 ( I know that both of them suck, but got no other option). Is this a known issue with these browsers cos am able to view it properly in Chrome or Firefox
How to link to a form to change an uploaded file
Hello, I have created a form where a user can upload a file. What I now would like to do is list those files in an HTML view and provide a link to go to that file's form to change the file. It's simple to show a list of all the files from the form, but I don't see how to create a hyperlink to that form for a specific file. I have tried with using the filename as a parameter but that didn't work. Hope someone has a suggestion Rob
Help using > operator
Can I add to an operator. Meaning, I want to have a script that says: if zoho.currentdate > input.Added_Time +10 So that would mean... March 26, 2010 is greater than input.Added_Time plus 10 days. How would I set up an operator like that?
Problem with Public Form
I did make a form so users can add data but I dont want them to see the records added. How to do that?
Duplicating an application
I have an application that I need to duplicate. Under the 'My Applications' page, I click on the 'duplicate' icon displayed next to the application that I need to duplicate, message says duplicating, but it does not actually create a new application. I can create a new application, and also duplicate other applications, but not the particular one that I need to duplicate. Help!
Exporting data into a document / template
Hi there, I'm hoping you can help. So, the situation is that I have captured data in my application for a customer - work details, estimates etc, and I want to send them a quotation summarising the work. That means I need to be able to export certain fields from one record of my database to another document that would then be my quotation letter. Is there an easy way to do this, using HTML, CSS, PDF or some other means? If not, is there another Zoho App (e.g. Invoices or Reports) that could take
Error Message
Illegal pattern character 'n' This is the message I am getting in my application when I try to edit a single record. What does it mean?
formula fild empty after add to form witm many rows
I add formula fild to form that's have around 7k row, all was ok, but in view formula value is empty. I make experiments, add an other formula with value 1, and see same story. As i know formula value recal after row update, so i update some rows, w/o change filds values, and formula calcs in updated row, i try more and more, some to all was ok, some a have error "Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting
Printing Views
I have read another post on this, but the problem is a little more fundamental. To get a good print, you have to export the data and then do quite a bit of work on it to get the print you want. Especially as exporting any form, seems to export all the columns (data fields) whether shown or not It would be great if Zoho was able to have a "print view" with the following features: Printing the column headings on each page Selection and order of data fields to be printed Ability to change column headings
"Provide edit permission to " not showing on App Settings
I have shared an application as a developer but when I go to the Applications Settings page the question "Provide edit permission to" does not show. How do I let this person edit the application without sharing my log in information. Herb Wexler
Get field names through a function
Is there a way to get the field names through a function? For instance you can use getFieldNames(); to determine the names of the fields in the current form, but what if I want to get the field names if I'm not in a form? So can I use something like the following: frmEvent.getFieldNames() I appreciate the help. Leo
Accessing information from other ZOHO applications
I would like to create a custom application accessing information from our ZOHO CRM instance. Is this possible?
No Edit, but Edit Triggers
I have started the roll out of my application. Several Forms have script that sends an email to the users when the record is edited. The problem is that the users are poking around the application to get used to its features and whenever they look at a record through the edit button, it generates an email whether or not the data is changed. I know I can compare the old and new values before sending the email, but that it a lot of code. Is there a simpler way to detect whether or not the data actually
I can't seem to access the form to edit it.
I created a form that I want to edit and find that I can't access it via the Form view. The form view is totally blank yet I can see the columns etc when I click the view tab. This is the first time I have used Zoho creator purposefully. I have only played around with it before now. Can this be fixed or do I start again? If I start again I would like to know how to avoid the problem happening again.
Updating Multiple Records at once
Ok, heres the scenario... 2 Forms... Form A Form B They share a common field, Location, that is filled in on both forms Form A has a field called Pyramid How do i bring in the data in the Pyramid field from form A to fill in the matching Location in form B I know i need a for each record command, but im struggling to write it, thanks
Stateless from, 'Insert Into' a table only when data in field is not null, using if (input.DATA != null)
I have the code below in a stateless form. The idea of the stateless form is to enter inventory movements. The heading of the form has the data that is common for the inventory transaction (date, Inventory to location, Inventory from location, Number of transacion). And the lower half of the form has multiple lines to enter a product code and quantity. The idea is that the user enters the basic information only once and then fills in all the product codes and quantities necessary. On click, the stateless
Multiple Choice exam on My Database
This wiki site is excellent! I'm kicking around the Zoho Creator, et al. I have a web site written in ASP net 3.5 It has a simple exam generator that sits on top of a multiple choice question and answer database. How can I incorporate this into the wiki? Can I rebuild it using creator? Or can I import my code? Or should I just url out to my site? Any help would be great! Cheers, Dave
jQuery JSONP Request Breaks ID Values
I'm working on an application which pulls data out of Zoho Creator using JSONP calls through jQuery to manage the cross-domain data exchange. I'm debugging in FireBug / FireFox. When I load the JSON data directly by pasting the URL into a firefox tab, the values in the Zoho Creator ID fields for the records are correct. But when I load the same data from the same URL via jQuery, the values of the ID fields are wrong. Specifically, the ID values are correct up to the last three digits. Some of the
Field Names not Updated in OnLoad
When I changed the name of a multiline field, the Form would not open fully (the box appeared, but nothing it it) when I clicked on either "Add" or "Edit" in the View. It turned out the field name was not being updated with the new name in the Load section of the Form's scipt. Changing it manually brought back the functionality.
Problem importing
Hi, we are experiencing a problem when uploading data to the application. We have this problem since last year, and we have contacted support, without any solution. The problem is that when we use the "import data" form, both pasting the content or uploading a file (csv format) the application does not do anything, so the data is not loaded. Can you please help us with this? We need to use the application, otherwise we will have to use another solution. I'm uploading a demo csv file. Regards
Zoho Creator API docs need (serious) work
Hi all. A few things that have caused serious wasted time and frustration for a new user. First, the Creator API requires a "ticket" value. As far as I can tell, there is _no_ mention of how to obtain the ticket value in the docs. I found two posts in this forum with some sample code, but without those posts I have no idea how I would have ever been able to discover the URL to get a ticket value. Second, the docs for the API are pretty aggravating. For example, the Update Record - REST API - POST
Next Page