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
Entry Fields of my form are gone then trying to edit/add more fields!
I just get an empty form with the text:"Drag and drop fields here and edit their properties..." Advice please, as I want to add more fields and edit existings once. The form works fine for entry and view older entires but cannot edit anymore! I tried adding a test field which was added to the form but that too is gone then trying to edit...
Email Registration Form
Hi, I created a form for a sports registration. It was very easy to do. Here is what I am trying to do: 1. A person goes to our associations website to find the form. I embedded a link on the page. 2. They enter all the info into the form and press enter. 3. Not only does the database get populated, but a copy of the form gets emailed to the person who filled it out, with an additional message, but the treasurer of our association gets a copy as well. How can I do that? Steve Bowers
How to Create a new Tab?
Everytime I create a new application it adds the application to the pull down menu from the Home tab that was created. I would like to create another application on a different tab and rename the home tab. How is this done?
Unable to pass boolean param to public perma view
I'm trying to pass two boolean params to two checkboxes on a public perma form. It won't work! I can pass string values to this public perma form AND I can pass both string and bool values to the #hash form URL. However, again, no luck with the above public perma view. Please help. Thank you.
Edit link in HTML view - Dialog problems
Hi everyone, I'm creating an HTML view that's similar to a list view, and would like to include "Edit" links for each entry. I've gotten as far as: The edit link pops up a dialog of the edit form When you make changes and press submit, the edits save successfully.I have two remaining problems: The dialog does not auto-close, you have to press close at the top, and If you then try to click "Edit" again, it no longer works. My edit links look like this: <a href="#Form:Time_Entry?zc_LoadIn=dialog&zc_NextUrl=#View:This_week_s_time&recLinkID=<%=id%>&viewLinkName=Time_Entry_View"
Grouping of view not correct
Hi I have a view called "QCS request per person / open" I would like to group this view based on the "assigned to responsibel" Asc. Unfortunately the view still have several persons listed twice with a request below. What can be wrong? My view is placed in appl. AFB System 2.0 which is open to support. Br Skouboe
hello i want to incorporate features to my website?
thanks, everyone, i have a question in my mind, i have an account here, now i want to integrate the features of Zoho in my php based website. But do not know how to do this?Is this possible? Please, need your help, please let me know. Looking forward to your reply... Thanks in advance...
Is there a way to hide buttons
Is there a way to hide buttons in a form to show a preview only ? My B plan is to create another form where I'll not keep the data. But I'm sure there is something else. Another option could be to cancel submit if Preview==true (or something like that...), but I don't like the message : Invalid entries found. Please correct and submit again and Failed to add data Can I change these messages ? Thanks, Pascal | nsisolution
Save Script
I'm trying to back up my application. When I do I only can save it as a DS script format. Which is fine but what application can I use to open the *.ds file. Also, from your video it appears that I should be able to copy the script and drop it into my webpage. But for some reason this is not working. Can this be because I am using the Free Plan? Can you provide me with some instructions? If I purchase a plan will I be able to save the script as HTML, PHP, etc. and drop it into my webpage?
Remove but not Replace
I've been using throwaway stateless forms to perform mass operations to correct or add things in my database. I have some html strings in the database that I wanted to edit variables in, but it would taken a long time to manually do this. So I looked into making one of my throwaway stateless forms to do this only to discovered the while deluge "remove" is present, deluge "replace" is not! I finally see the need for Gaev's ReplaceAll(searchString,replacementString) global operation: http://help.zoho.com/portal/en/community?ftid=2266000000351138
Send Mail on Update Question
Hello, I am setting a simple script that should be sending an email based upon the script syntax below. This same script works with the "on add" command but not with the "on update" command. Any advice would be helpful. I don't want this email sent until the person entering the data presses submit, which is what I thought the On Update command did. The on add command sends the email immediatly, which isn't ideal. Thanks if (input.Edge_Device == "211a") { sendmail ( To
HTML View.
Okay, I'm scratching my head on this one. I created a form, the form has 8 columns. I can create a HTML view and display all the columns and data without an issue. What I want to do is Display 3 of the 8 columns with data in an HTML view , and on the left where you can view an individual record, show the full information there. Can this be done?
ZC cannot show records
Hi, Today when I started my ZC, it came up with a bug. It does not show records in my views created yesterday after 14.00 - in my views(all my views) It happens when I set the status from "new" to "assigned" The only way to find them is to search via the id no. given by ZC? It is not possible to search it via all other criterias! I have not changed any views, criterias or the like. It is in my appll. AFB System, and I have shared it to support. Br Skouboe
Data is not storing to View
I created a registration form and after enter my information into the form and click on the submit button the data is not being stored to the view for the form. When I click on View to see the data the view grid is blank with no data. Also, after I select the Submit button the name fields (First, Middle, & Last) remain populated with the information entered on the form and all other fields are cleared. I checked the Form On Success and Field User Input options and I do not have any code.
Next Page