HTML Views
Hi! I have been using DabbleDB. There you could to make public your custom views. I am testing now HTML Views. I have embedded it in my site. I have made it public. It still requires login access. How can I have the public of a HTML View! Thanks!
Duplicate form
I did a search and found the following on how to duplicate a form - Right now it is not possible to duplicate a form directly. However, it is possible to do so via script. Click on "Edit this Application" and navigate to the particular form. From the top strip displaying the Form name, mouse over on "More Actions" and click "Form Definition". You will be redirected to the Script tab displaying the form's configuration in Deluge Script. From the left pane, from under "Form Definition", click on "With
Radio field
How does one design a form with a radio button field of 3 selections - 1, 2 and 3 - and then have each selection take you to another form - form 1, 2 or 3? I don't seem to find a "go to" another form selection. - jb
Problem deleting rows with Rest API
I am posting a request to the REST API to delete a record and I receive a Internal 500 server error as follows: HTTP/1.1 500 Internal Server Error Date: Mon, 02 Jun 2008 18:28:41 GMT Server: Apache Cache-Control: max-age=10 Expires: Mon, 02 Jun 2008 18:28:51 GMT Vary: Accept-Encoding,User-Agent Connection: close Transfer-Encoding: chunked Content-Type: text/html 1f9 <!-- $Id: errorinfo.jsp,v 1.4 2006/11/16 10:49:08 muthumariappan Exp $ --> <html> <head> <style> body { font-size: 14px; font-family:
Ability to hold onto Record Collections across form events. OR ActiveRecord/ORM'ish relationships
Right now each form event (on add, edit, validate, etc), is pretty much it's on sandbox when it comes to variables. I would love the ability to load in a record collection "pointer"/ model that can be accesses across the events. This would cut down a lot on unneeded "state" fields that are pretty much only created to bridge the gap from say an on-add to on-validate. I recommend a "collection" field that works much like formula or just a global name space mixed variable map(). Where you could stick
Limit Autofilter Lookup results
I have a Current_Tasks view which has an Autofilter for the lookup field Customer in the Clients form. The dropdown list for Customer is getting very long, however, because the autofilter lookup returns every single customer we have ever had in Clients. I have tried adding to the criteria for the Current_Tasks view Customer.Inactive ==false, but that does not affect the autofilter. I have added the Inactive == false to the criteria for the Lookup field on the Tasks form, and this does correctly
Tip for quick record lookups.
Here's a little trick I'm using to speed up subsequent look ups of records on a form. 1. Problem.. You've dynamically pulled in a list of records into a radio box selection. You want to use the selected radio button's value to do a lookup on another record (The record you just pulled in). BUT the value in the radio button is something not very unique like a vanity date or a location or something of that nature. This will make getting that record more difficult. 2. Solution.. Embed the records
Filter dropdown based on previous records
I have 2 dropdowns in my form, when the user selects the first dropdown it filters the second one. What i would like to do is autofilter the second list based on previous records, if there is a previous record then the list will not display that option. I have tried many different code snippets from the fourms and the kbase and can not get it to work... Help please!!! Thanks, Damien.
Help with printing from Zoho Creator database
I've developed a catalog of resources using Zoho Creator. It's a merger of a "library catalog" and "resource guide." It includes an item, a description, a URL, contact information, and then a number of columns with specific categories/filters. All of this makes for a very long horizontal screen. My problem: When users search and get a set of results, I need them to be able to print those resources in a format that's helpful. Right now, if you print from the browser window (firefox or IE), and if
Help with combining views
I have managed to automatically assign a unique ID number to related records in different forms (using MaxValHolder). Now I need to combine the related records into one view. In other words, I want to view all records with the same ID number in one view. Is this possible? I currently export into Excel and sort by the ID number to stack related records in sequence. It seems too complicated for a fairly simple database function. Thanks in advance for your help.
Newbie - Sort HTML View Script - Examples?
I am new to Zoho and have just started building an HTML view showing a table of wines listing by rating. Can someone help me learn how to use script builder to sort the table by rating in descending order? I can't do this through the normal table view since I am going to use an HTML view to customize the table's appearance. The code I'm using now (minus the css) is below. It's rendering the table just fine, but it's not sorting, obviously. I have no idea how to add instructions to sort this table
User deleting calendar entry based on UID
We are using ZOHO Creator to book a location using a form in calendar view. The system sends an mail with a recite to the non registered user. Can we send a link to the user, so the user can delete the record if they want to cancel the booking?
Customized Estimate app similar to Zoho Invoice
I have an existing Zoho app to track clients and tasks that I would like to add an estimate module to. I like much of the functionality in Zoho Invoice, but I would want to tweak it, so just linking the two is not the answer. Also, once we have Estimate working, would want to add Purchase Order, which would be very similar. I would like to hear from developers who would be able to do this for me. Thanks!!
Contact us form
When someone fills in a contact form I have, where does the info they have input go - into Zoho's database? Do I have to go into the database to pick up the info? Can I have it emailed to my email account? Tks - jb
Logging into two Zoho accounts
As I will be working with two different companies with Zoho forms, I have opened a Creator account for each company. Since many of the issues I have will be with both sets of forms, I tried to log into both accounts but it appears that Zoho will not let me do so. Is this correct - one can not be logged into two different accounts at the same time? Is so, why? - jb
Suggestion on "Access this application"
Building apps with shared forms/views/sections (as we can play in a same form to show/hide/disable fields) often depend on the logged user/user's group. To see/control the applications according to the user or to arrange layout of forms is not easy when we see all the (hidden) fields : I use another browser to access to the app with the user's login : I can check if all the fields/views/sections are shown as I want to (for this user). For the following users, I have to logout, and log in again and
Grouping Forms/Views in Edit Mode
I have more than 20 Forms/Views in some of my applications, either Real Form or Stateless Form. Even I'm having 54 Views in one of my application, that made me dizzy whenever I have to edit one of them. I wonder that I can group Forms/Views on Edit Mode into several sections (like "Add a New Section" in Settings -> Customize -> Rearrange Links)), so i can easily manage them. Thank you very much! Wisnu
Tooltip & dropdowns
When will tool tips be available for Select Items? When will tool tips be available for disabled input text? Most users want to know why it is disabled. Can you not put the tool tip text on the title attribute of the associated label? I modified select Item list and they do not show up in application.
View Criteria - Related Fields - Error
I am referencing a related field in a View and it is causing the view to return the "We are unable to fetch this data, sorry! Please note that your data is SAFE." error. Here is my situation: If you type in the Deal. when specifying the criteria the editor will remove it. I have it in the code snippit below for example. Application: http://creator.zoho.com/tonythomas/ensobase/ (This application is shared to support) Error for TMView: We are unable to fetch this data, sorry! Please note
lookup field is randomly working and not working
rec = Ride_Matrix1 [Lookup_2 == input.How_long_do_you_plan_to_spend_on_chores]; input.Time_in_Minute = rec.Time_in_Minute; I have this code, it works fine if I delete it, then resave it on input of my script, but if I try to use it again without resetting the script I get an error message time in minute is null. it is not null since it just worked fine the first time, edit access should be turned on please help trying to lookup the amount of minutes to add to a date time start where input at
Zoho Creator - Printing/Exporting Applications/Records
Most of our applications have enough columns that would exceed a standard 8.5x11" piece of paper. When choosing the print option, is there anyway to display records vertically rather than horizontally? It appears as if when you try to print, export to pdf, export to excel, etc the only way data is formatted is horizontally. Is there anyway I can print/export applications/records vertically? Am I missing something? Thanks -AJ
Contact form
I used the template for a contact form and made the changes I wanted to same. When someone uses this form, the info input into the fields is sent to the database. Is it also sent to an email address of my choosing? Should I have a form with radio buttons for Sales, Admin, etc., and then taken to the correct Contact form? If I have one contact form for Sales, one for Admin, etc., how do I get the emails sent to the correct email address? Tks - jb
Managing large numbers of users
Dear ZC-team, If I would like to share an application to a large number of users, how do I manage this. The way in which users are allowed access to specific forms, views, reports etc. in ZC is very cumbersome. There is no possibility to automate this in anyway? At first glance, a matrix presentation of users against forms, views etc. with checkboxes to allow rights would seem the first step. I also notice that there is deluge scripting possible to share/unshare stuff, but is that easy to operate?
Currency field is missing ending Zero.... ?
When values are entered into a Currency field and passed to HTML view, the ending zero is missing - i.e. entered 50 and it shows up as 50.0 I have 2 decimal points (default) entered under Appearance. Any ideas on how to get another zero in there?
Re-arranging left panel of forms/views seen in "access the application" mode
Hi, Is there any way to rearrange the left panel that contains the forms/views in the "access the application" mode? I'd like to group certain forms & views instead of having them in alphabetical order. Thanks for your help!
Not certain whether I should be creating a View or a Form but its not working for me
I have 2 forms in my application. One is for Landlords and the other is for Prospective Tenants and one view emenating from each of them. I am trying to create "something" where I can combine many fields from Current Available Apartments, including Landlord's name, Address, Phone Number, Rent with pertinent info from the Prospective Tenant List when a particular apartment gets rented. On this combined "something" I need to add a few fields like the date it was rented, my broker's fee and my commission
There is not such View in Zoho Creator
I have an application with several forms & views, today I create another view , everything looks fine , I order the columns, I put some sorting columns on the view, etc.etc, then when I try to access the application I receive the message "There is no Such View in Zoho Creator", and of course the previus view defined was not there. I try these creating a New View and also using the Duplicate View function, in both cases the message is the same, is any limitation with the quantity of views?. Regards.
if scripts to fill a form field
Hi, I use Creator to list customers and clients. I am not familiar with Deluge and have been trying to write a script to use a "yes/no" radio button field to copy address components. So far i've gotten the following script to successfully save but not to work in the form. if (input.Address_Change = "no") { New_Address = Address; New_Apt = Apt; New_City = City; New_State = State; } Please help me! Thanks you
Please ask dev to ALPHABETIZE all drop down picklists for forms
In a couple places dev made the effort to alphabetize the list of forms that are needed in various places inside of Zoho Creator, but not all places. Why? It is extremely annoying to try to hunt for a form in a long list of forms, and they are not alphabetized. I know this has been mentioned in older threads, but I feel it must be brought up again. It's a simple SORT function. Please ask dev to complete the task they started and make all drop downs that list form names ALPHABETIC. Thank you.
urgent! Solution Needed for highschool project (easy)
For high school i've been asked to create a database using zoho, part of it involves normalising the information below. to get extra credit we've been told software requirements could be a repeating group, if an exhibitor needs to use more than 1 piece of software. I really suck and normalising and am struggling to come up with the right data tables so that i can start using zoho! If anyone would like to give it a go and along the way please explain how you did it, here is the information which
How to enable the 'Import' functionality on a View for non-developer users?
I can't seem to be able to determine how to enable the 'Import' functionality on a View for non-developer users. Is this available to regular users?
Error when submitting Quick Add from requester login
Made some additions to the Quick Add form and when a requester tries to submit, it gets an error and says to contact the administrator. I am new to this type of software. We are going to be using this as a support system at a high school. We have two IT guys, including me, and about 400 students. Students are "requesters" through google apps EDU. I wouldn't even mind turning quick add off altogether but I can't figure that out either.
  showing up in exported data field
I have a test string field that is a person's name. When I export to excel or PDF it now has   in between the first and last name instead of the space. It just started doind it this week. Any ideas why?
create a document with zoho
Hi, I have create a database with zoho. Now I have to create a document with some field connected to my database so they can be filled automatically. Someone has the solution? Thanks
Error when trying to Add Technician: "Invalid entries found. Please correct and submit again."
I have been able to successfully add 2 technicians. However, I now get the error below when trying to add an additional one. "Invalid entries found. Please correct and submit again."
Lookup fields and null question help
So I have application Test I have a lookup field Lookup_11 With fields for customer email, phone number ect how do I make this code allow reservations even when some of the fields are not filled out or have a different email or ect that is not in the Registrations table? I keep getting null error messages when I submit the form. rec = Registrations [First_Last_Name == input.Lookup_11]; Email=rec.Email_1; input.First_Name = rec.First_Name; input.Last_Name = rec.Last_Name; input.Phone_number = rec.Phone_Number;
List lookup related field can't be displayed in views
I have a view containing a multiselect list referring to some IDs in another form, and I added a "related fields" to display the names in the view instead of IDs. The problem is that this field is always hidden in live mode. I can unhide it, but I can't save the changes and when I refresh the view, the field is hidden again. Note that the case is that not all the other fields are shown in the view, but if I make the view to display all, my field appears. Please test the way in which "related fields"
Any particular reason why saving records is failing all the time
I am trying to edit records while in "grid" view. when I press "Save", the "Saving Records" shows and the indicator keeps "rolling". This isn't for every record, but it has been frustrating updating 200 records today. can anyone chime in?
Application will not duplicate
http://creator.zoho.com/rrsaddleclub/test will not duplicate I tried this with another app and it duplicated just fine. What's the fix?
Is 'https' required?
Just yesterday (May 4, 2011) links to Views, which I generated using scripting and form data, began to malfunction and display the view without any CSS. Changing the link structure from 'http' to 'https' seems to have solved the problem. However, I now have to manually update close to 300 records as scripted variables are not set when using Bulk Edit. Did something change? These links worked fine before yesterday. Original Link Structure input.TenantLink = "<a href='http://creator.zoho.com/codyastanley3/alstoninvestments/#View:VwTenants?TenantNameID="
Next Page