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
Update does not work properly
Hi Within the last 5-7 days my update "button" does not work instantly. I have to click several times(10-20 times) before Creator update the page or database. BR Dennis
Cut-off in Microsoft Explorer
one of the fields in my form is cutting off in Internet Explorer, any ideas? (the drop down field labeled “game”) https://creator.zoho.com/becomgmt/beco-baseball-tickets/form-perma/Ticket_Requests1/ works fine in Firefx
Use of URL Format Functionality Fails When Embedded: UPDATED! New Issue for Firefox Only
Pretext: I want to make sure the user of my from has a ZOHO Account. To enforce this, the script below is intended to display the ZOHO sign-in block. Once signed-in, the rest of the form is displayed. This works well in the native ZOHO app, but stalls when embedded. The name of this form is "Form". The first line checks to see if the user is signed-in. If not, the same form is reloaded with the special URL like "form-login" added. if (zoho.loginuser == "Public") { openUrl("http://creator.zoho.com/niskypto/myapp/page-login/Form/",
Please clarify the term 'Backup' in your pricing plans
Hi there, Looking at the various pricing options for Creator, I'd like to understand what is meant by the term 'Backup' under 'Business Features' in the pricing plans - i.e. is the *data* I input into my Creator apps not backed up if I don't have at least the 'Standard' level, or does 'Backup' mean something else (e.g. I can take a previous copy of my app in case I then change something and want to revert?) Due to starting a new business, security of the data I input is critical, so I need to understand
Import Capabilities
Is there a way for shared users to import data (XLS, CSV) into a form? I can because I'm the admin of the app but how can I allow regular user to import data in batch to a form (not counting on email data import) Thanks.
enlarge field
Hello, Is there a way to enlarge the fields of the form ? I have embedded zoho creator in my website, but I find the fields too small. If I adjust the embedded code, there is no difference in width of the fields. So I guess there must be a setting in creator to have larger fields (ex. multiline) Thanks, icetea
Help for pulling data into other forms / tables
Hi there, I'm very new to this online database thing, so this is quite a newbie question, so I'd be grateful for your patience and advice! The situation is as follows: I have two tables, Table A and Table B and two forms that directly relate to them, Form A and Form B. Table A has three fields, Client Name, Client Address and Client Phone Number The situation is as follows: I want to pull information from Table A into Form B, using lookup. So, if in Form B I have a lookup drop down called 'Select
form view
When entering data I enter it into a form. Is there a way to view data in form view. Summary is close, but if I have a bunch of fields per record, it does not work well. Thanks
Multiple input forms that add data into one data sheet.
Hi, I do not have many skills with database programs, but I need to make 3 diffrent input forms, throught which we will be entering data info one database.... Because, we have 3 difrent users and each one inputs difrent part of information. Thank you for help. MM
How to update a picklist for another record?
In the On Success event of form "frmPlayer" I am trying to set the value for the picklist "Introducing_Player" (single-select dropdown field) for another record of the same form. if (input.Name_before_edit != input.Name) { for each player in frmPlayer [Introducing_Player == input.Name_before_edit] { player.Introducing_Player = input.Name; } } But this only works, if the value to be set (input.Name) already was a possible selection for this field before. using the following
Go to URL after submit
This should be real simple, but I can't get it to work (works fine with wufoo, jotform etc.). On 'submit' I want to go to a new page (URL) from the same site. The form (made with creator) is inside an iFrame on my site. I have used 'on success' form action On success, web data 'open Url' and have tried settings of open in new window, parent etc. Either it does nothing, or opens the URL inside the iFrame. I want to open URL in main window of browser (close iFrame and open URL). I don't want to open
Error Code 2892
I am getting below error when i try with RPC Specified application name is not valid.Provide a correct one Here is HTML form i am using to submit data <form method="POST" action="http://creator.zoho.com/api/xml/write/apikey=######&ticket=######"> <input type="hidden" name="XMLString" value='<ZohoCreator><applicationlist><application name="CRM"><formlist><form name="New Contact"><add><field name="Last Name"><value>Jason</value></field></add></form></formlist></application></applicationlist></ZohoCreator>'>
Deadlock found when trying to get lock; Try restarting transaction......
I edit scripts and after try to save it i have an error "[Templates] Deadlock found when trying to get lock; Try restarting transaction....blablabla..........." how can i fix it ?
Problem with using Permalink in iFrame on website.
The report permalink no longer seems to work in the iframe widget on Google Sites. Can you recommend another iframe widget?
Next Page