Disabling the standard edit and view links in a view
Hi, I badly want to know how I can hide the standard edit and view linktext in a view. These linktext always seem to be present in a list-view. I do not see some settings to disable those (and I need this because I want the users to edit the recors via a function via Edit a record via Record ID). Or is this dependent also on whether you are an admin of an application? Any help is appreciated. Kind regards, Silvester
You are doing it again! Fix it!
I have had this same issue in the past and I was told it was fixed. You are adding a variable name to your JSON api calls.... Like this.... instead of just {"Client":[{...... it's var zohosrhyneview204 = {"Client":[{... Fix it! This is like the 5th api bug I have had to point out to you guys.
forms not working anymore (private / public issue ?)
Hello, Two Zoho Creator 'contact' forms have been used with success for quite a long time already on two different of my sites. Yesterday, a third one was implemented on a third (in the making) website (see: http://sites.google.com/site/kuntheacom/contact-1). It appears that, while the application remains 'private', the form must be made 'public' for it to become accessible to anyone. It took me a while to understand this, because the procedure was different before (as far as I remember). It was
leading zero
Hello, i have used an int field for my zip codes. Now i discovered that there are zip codes with leading zeros which disappear. I can't change my field to string, it's tooo much work. Can I do it an other way with some other tricks to let leading zeros be where they belong to? thx
How to show a field that is in another form?
On Add, I would like to add code that will allow me to Show and Enable a field from another form. When I select the Show option the pull-down menu does not display the fields from another form.
Filters contra views - performance
Hi, I wonder, what is best to use - filters or views, if performance in ZC is considered? Br Skouboe
Can't copy view
I tried for five minutes to copy a view and cannot do it. I get an error: Error occured while duplicating this view.<br>Kindly refresh the page and try again.I tried to refresh multiple times, signed in and signed out, tried with different browsers and nothing worked. What is going on?
image loading is very slow
Is there a problem with the loading of attachements as the service is very slow, and is almost unusable due to the process. It actually appears as though it stops. Can you advise please? dp
Need calendar widget that shows database rss feeds for an "events calendar"
Hi I need to make a calendar or widget that pulls in specific things to do for each day that comes from our zoho creator events database application. can anyone tell me how to make this - if one already exists - or if I can use another third-party calendar or tool that will show a calandar of say, the week ahead's events, and music only, arts only, etc, etc....?? Thanks! andrea
When using IF I want to use the or function for a set of inputs but cannot make it work
When an input is made on a form and on field actions on user input I want to set a set of or conditions if (input.Key_post_code_area == "AB") however, I cannot make this save, and have had to add it condition by condition, which slows the process. Can you help? dp
Disable export in Zoho Creator
We have been helping customers get started in Zoho and ALL of them ask if Zoho can disable exporting and printing. This feature is key to protecting business data. I see that others have asked for this feature. When will it be available?
Unexpected Zoho Creator behavior changes
Hello Support, I am really tired of you making changes to your application environment and behaviors WITHOUT NOTIFYING YOUR USERS/DEVELOPMENT COMMUNITY! Example. I have had the same 40 users using the same application for about 5 months. I have two forms embedded on one html view. For the last 5 months when submitted, these forms just refresh the page. NOW when either of the forms are submitted. They SHOW ME A LARGE "Data Added successfully" Header in the middle of a blank page! I am sure it has
How to program dynamic calculation ?
I explain my problem : I have a Project , containing Steps (Step A & Step B, for example). My users declare activities on project belonging to step A or step B. These activities have a value of days (0.5 or 1 or more). I would like to have an dynamic udate of the consumption consolidating all activities declared by step. For example : 2 users declare activities on step A. 1 declare 3 (days). The counter of consumption for step A becomes "3". Then a second user declares 4 days on step A. Then
Add selections to multiselect checkbox field
I am trying to figure out the best way to add selections to a multiselect check box field in a current record. I do not want to open the entire form and edit it but just see that one field to edit. I've created a function that successful opens a stateless form with the checkbox fields and the parameter for this list selections are being passed to the URL, but it is not actually selecting the corresponding fields. Is it actually possible to populate a multiselect checkbox field from a URL parameter?
Can anybody help me?
I am very new on zoho creator... I want to know that.... Can I create a database like http://www.mintarticles.com.. It is an website that has an option for user of mintarticles.com. Users can earn money from that site. They submit article and then they will be get a bill for every article. If i can create database like that please send me some information... How can i create a database like mintarticles.com
Announcement: Migrate your MS Access Database to Zoho Creator
We have built a simple migration tool using which you can migrate your database from MS Access to Zoho Creator. So with this new addition, now you can create your application in 4 different ways. Create from Scratch Import data from your Spreadsheet Write Deluge Script Import MS Access Database (new) Follow these steps to migrate your MS Access Database 1. Download the plug-in 2. Import your .MDB file using the menu "File -> Import MS Access File" 3. Once the import is successful, the tool lists
Lookup field limitations?
I am creating a form for class registrations. I have one form which contains the details of the class, including drop downs for location, class type and state - and single line forms for name and other such things. I have a second form which contains the student registration. My goal is to connect the two forms in such a way that from the student form I can pick which class the student is attending. My goal is that when the class name is picked the other information, from the Class form, will
2 step reservation process
I am trying to create a 2 step reservation process where the customer enters in their data providing them with a quote, which I am using the dynamic features of creator to do this as they enter their information. If they like what they see, in terms of the pricing I would like to have them press the submit button (rename it "Reserve") and have them navigate to a Personal reservation form where it imports their selections to review as they enter in their "Customer Information." I am fine up to the
Questions About Column Sorting
I'm trying to figure out how to do the following, but can't find answers in the forums... How to visually indicate sorted column(s)? How to un-sort a column? How to un-sort any / all columns and apply sort to different column, all in one step? How to make it clear which is the primary sorted column and which is secondary? Any advice would be greatly appreciated. Thanks!
Layout when trying to Edit Forms ...
@ZOHO Creator Team When I went to edit a Form in one of my old Applications ... found the layout to be messed up (see attached image). This happens for most of the Forms that I tried (being a Lab Application, there are many many Forms in it) ... but not in a few other Applications I just tried. Please address this urgently ... as I can not edit the Forms as they stand. f.y.i. I am using Firefox 3.0.14 under Windows XP Pro SP3. Gaev
Requesting Ideas / Help in Creating a Dynamic Table on Zoho E-Mail
Hello. I've been developing an order processing Zoho application for one of my clients. I would like some ideas / suggestions / assistance on helping put together a "Receipt" e-mail that creates a dynamic table or as a minimum the right amount of items on the e-mail message of the Receipt. I have multiple items and need to put them on a dynamic table (so it grows with the size of the pulled data) where for example: Table: PN Description QTY Price Ea. Sub-total
Form Validate : alert message not displayed, is this a FF3.5 issue?
Hi Team, I am trying to have some data validation done at Form Validate However, when i just give Form - Validate Alert (input.email) This alert fail to appear when the form is submitted. Could this be a FF.3.5 & IE 8 issue? -Deepa Govind
help with Iterate on application
Hello I am looking on help with script writing to iterate on an application. I have an application for swimming club members where data is input in a form with multiple fields for different stokes and distances fo each individual member in this I have a view off all the data, but would like to be able to automaticlally iterate on all the fields and produce an individual record from the data for each member of the best time for each stroke and distance. Can anyone advise on this Thanks Andrew
Linked Dropboxes - For Example State and City - Possible?
I'm building an app to accept a US address (among other things). I'd like the user to select the state abbreviation from a dropbox containing 51 values (the 50 states plus DC). Then I'd like the city dropbox to autofill with *just* the cities in the state selected. I have the full list of city names in Excel. But I don't know how to code the dropbox linkage. Is something like this possible? Thanks!
Nice Form Formatting
I just came across a public form at http://creator.zoho.com/beltz02/ja-finance-park-date-signup/form-perma/JA_BizTown_Date_Signup I like the way the fields are grouped into two columns. How is that done?
Filter a view via a function using more than one argument
Hi All, I've created a simple function that will filter a pop-up view by the name of the associate (see code below): void basSelectedInterpAvail(string Associate) { //This code will open a view which displays a list of all of the speakers of the selected language, displaying their availability information. openUrl("#View:vwLangAvail?cboAssociate=" + input.Associate + "", "popup window", "height=100,width=100"); } I'd like to add an addtional argument that would further filter by the language spoken
Aggravating but not a deal breaker
Can anyone tell me why the list of forms (in design view) keeps jumping around? In the two files attached, you’ll see that the “Event” form appears towards the bottom in one instance, and then in the middle of the list in another instance. What the heck? Leo
Formula field refresh iframe
Help please, I have a html view with a view inside. I want to put this view into a iframe into the html view and refresh the iframe passing a param everytime I click on the formula field. I already did that with and "action button" in my view but I wanna do with a Formula field. Thanks Sergio.
Form vs Tables in Zoho
This part of Zoho is confusing me- In Zoho are forms the exact same thing as tables? Is there a way to view and edit the tables directly? e.g create new columns, without using a form? Can zoho use different forms to edit the same table? For example I want to use the inputs of two different forms to be related and be in one table.
Cycle 2: Rich-text editor for multi-line input field
Suggestion: Rich-text editor for multi-line input field Purpose: Allow users to type rich-text in the mult-line field. Motivation: Basic rich-text (bold, underline, italics, fonts, font colors, font sizes, hyperlinks) allows users to be more expressive when conveying information in a form. This is an often requested feature and is in the roadmap. Example: An announcement board to post news relevant to an organization. Colors and links will provide extra detail than just plain text. Implementation:
Add notes to default views
Hi, I like to add some notes/instructions for users on the zoho views. Any suggestions how this can be done...? Thanks :)
Allow user to edit their records
I like to use the Zoho Creator to maintain a small membership list for a non-profit organization. My plan to import all the records that I currently have in Excel format, in to the Zoho database. Is it possible for me then create a webpage (using embed weblink) and setup a password to allow each member to access and edit their own record and ONLY their record.
Various Questions About View Display
I'm a Zoho Creator newbie, so please forgive my ignorance... I need to find out how to: > Hide the message near the bottom of my view display that says, "All times are in (EDT)..." - I'm not displaying any times, so the message is meaningless and just clutter. I *do* have a date field, but it's just MM/DD/YYYY. > *Un*group a column without forcing my visitors to refresh the page > *Un*hide a column without forcing my visitors to refresh the page > Remove "search", "hide column", and "group" from
Download file that has been added to the ZC application via File Upload field
Hi Team, The form uses the "file upload" field to upload documents (doc / exls/ pdf/ txt) -- This is working absolutely fine -- I am able to upload a file & submit the form -- I see the file (course.txt) in the view as well However, when i try to access the same txt from the view (ie.. download this file from view & see it) .. the url just displays this string (http://creatorexport.zoho.com/DownloadFile.do?filepath=/1253261765429_CourseList.txt&sharedBy=worlduplanning&appLinkName=worldu-data-tables&viewLinkName=Issue_Tracker_Resolved)
Interesting issue when dealing with strings.
I have created an application that allows the user to select a venue that is dependent on an agency that is selected, as well as allowing the user to add a new venue for one that does not exist. To do this, I have created the following simple function: void VenueTest(string AgencyName) { openUrl("#Form:frmVenue?cboAgency =" + input.AgencyName, "popup window", "height=100,width=100"); } I then call this function using the following code when the user selects “New Venue” from the Venue picklist:
Why does ZOHO Creator do this ?
ZOHO Creator Team: When you type something like ... input.Field1 = input.Field2 + "something"; ... if Field1 is mis-typed, ZOHO Creator does not point that out at Save Script time ... instead it decides to turn it into ... Field1 = input.Field2 + "something"; ... i.e. turning it into a variable ... this then causes Run time unexpected behaviour ... resulting in time spent investigating the cause. What is the thinking behind such an automated change ??????? Gaev
Lookup records using a field that is not a ZC form
I have a User table that was created on my host for users to log into the website. This table has the user login information, such as, name, phone and email address. I'm trying to use that login name (email address) to do two things: 1.) To look up the registration form to edit the information. 2.) To open the registration form and user the information from the User table to auto-populate information on the registration form. I saw on your website under Help General a document that explains how to
Show Image on Form
Hi all, In an application I had on a Form,a upload field, and a Notes field, to upload and show a image. The Notes field contained : <img src="http://creator.zoho.com/DownloadFile.do?filepath=/" +\logo_upload="" +="" &sharedby="username'"> This used to work, but now it doesn't work anymore. Maybe somethin broke, or did I miss an alternative way of show images on a Form? Thanks, Danny Sterke
Validate a Date
I'm trying to determine if the current date is less than November 30, 2009. I'm using the IF condition If (zoho.currentdate <= '11-30-2009') When I click on the Done button the curso just spins. What is the correct way to do this?
Error Creating a new Application from an Excel Spreadsheet
I am trying to create a new application based on an existing Excel Spreadsheet. I went to "Create New Application" and chose "Import XLS" on the left side. I specified the application's name, checked "Import Data" and selected the Excel file to import. It then brought me to a screen where I can choose the Field Type and Label Names for each column. Very cool. This is exactly what I was hoping it would do. The only problem I'm having is this. It says "We have identified 'Field Type' based on
Next Page