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
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
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
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
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
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.
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
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?
Usage Limits
Hi, I had this message when I executed, one of my html view. Event Type: "User defined function:" Reason for failure: : "The maximum number of statements that can be executed in one deluge action invocation is reached" Error Log: "Deluge action is aborted and the database is reverted to the original state." There's any way to increase my number of statemets??? Im on the Professional Subscription. Sergio Galiano
Can't import data.
I can't seem to import data. I have tried both by file and by CSV import. I click, and "Importing" flashes, but nothing changes. I'm using Windows 7 Ultimate, 64-bit, and IE 8. Thanks. [eta] Same issue in Google Chrome. This is not like it's difficult data. If there's an error, I'd expect a message.
iCal Feed Issue
Okay, this works with Google Calendars: https://creatorexport.zoho.com/micklerrp/build-creative-group-crm/ical/PMC_Open_House_Calendar/gGkGqwsdpq75m42Hj0XuzEJbkFeggwjfFq41ZYTTp2C9tnYN9uBay2Ovs7ZgbxaCO78TKJEbnRpJuY7Bnb9TeVW9ag9AVEZpZx1w/DTSTART=Open_House_Time_Begin&DTEND=Open_House_Time_End This doesn't work with Google Calendars: https://creatorexport.zoho.com/micklerrp/build-creative-group-crm/ical/PMC_Open_House_Calendar/gGkGqwsdpq75m42Hj0XuzEJbkFeggwjfFq41ZYTTp2C9tnYN9uBay2Ovs7ZgbxaCO78TKJEbnRpJuY7Bnb9TeVW9ag9AVEZpZx1w/SUMMARY=PMC_Name&DTSTART=Open_House_Time_Begin&DTEND=Open_House_Time_End
Information Discrepancy
In the Share options of my application Sistema de Gerenciamento there is listed user with full access, but when details of him are listed there are only few views available, wich is the right situation. I´m concerned that this user could have full access without my permision. Please, check uploaded screen shot.
Multi-select needed for Share this application screen
In the Share this Application section, under the Share tab, can you add check boxes next to each form, view and user in the database to permit selecting a person's name and then rapidly going down the list of forms and views to turn on or off the form/view for their email? Right now it is very cumbersome to have to click each form and then turn off their email. Another approach instead of check boxes would be to permit multi-select by holding CTRL and clicking on the forms/views that apply.
Default Namespace Name
All functions have "thisapp" prefixed to the name. I suggest for functions in the default namespace that this not be done. Thanks.
How do I stop record editing in Grid view
How do I stop there being edit/delete option in the grid view? The view is embedded in a web page and I dont want any records to be amended by anyone other than me and even then it will just be to delete the record. I haven't ticked any of the boxes within set permissions so I wasn't expecting anyone to be able to edit the record
Time selection could be easier
Time selection is inconvenient. Need a faster and convenient way perhaps slider or list select for hours and minutes or even move clock hands
Next Page