how do i import data from multiple fields to one field to select from a drop down menu?
i have multiple products for different clients and i need to be able to choose from all of the products (fields) from one list. Thank you, Bob
How to randomly generate a 3 digit number?
I need to randomly generate a 3 digit number when the form loads. The field is called Payroll_ID. Any help would be greatly appricated. Thanks, Michael McNeill
Leading spaces only in first row of view.
I copy my data from a browser generated by permalink. (see attachment) This data I paste in excell for running a macro ect.. Only the first row is not correct pasted, almost every column has a leading space. My data looks good, after a sort on the same data with permalink view. It is again the first row that have spaces, the earlier row is now good. Question: can this be fixed ? Yes I know I can export data to different extention, but a small among of data I thought it is faster.
Making an entry a hyper-link from importing data
Hi. I have recently started to use Zoho. I am trying to import csv files but entries of URL's become normal texts rather than hyper-links. First, I make csv files with Google Document and download it onto my desktop. Some of the columns are URL's here. Then, from the live-mode I try to import it. But the imported data, having the columns of URL's, show no hyper-links at all. All entries are normal texts. For confirmation, I have tried to enter data one by one, then it was fine. So I assume I
Can I Hire You to Create Real Estate CRM Version
Hello, I'm an internet technology consultant that works with real estate agents. I primarily focus on Home Search lead capture websites including integrating MLS listings into Wordpress, but am moving into pushing data from them into a low-cost CRM. I am looking to swap expertise with a real estate agent (or technology consultant for a real estate agent) who has customized zoho for real estate and can provide me a template. I'm also particularly interested in Lead management elements. In return,
PDF Download of Embedded Form
Please make it possible to allow PDF download of embedded form to enable users to print. You guys are awesome! smspdd
Script has white font on white background! Cannot Read!!
In free-flow mode on Chrome 3.0.195.38 the code appears to have a white font on a white background. The result is I can only read the code if I highlight it. In Firefox I get a similar problem.
Themes with Dark Backgrounds?
I'm not seeing a way to have a theme with a dark background. I'd like to embed my db view in my WordPress website, which I have done, but it's pretty Jarring when it shows up all White on a black screen. Do we not have a way to have dark backgrounds? Also, my Gradient header on my view did not come across on my embed. Here's an example in case you need one: http://www.windyweather.net/wp/2010/01/18/zoho-creator-database/ thanks, d
Remove Delete Functionality from a View?
I have tried everything possible and no matter what, when I display an embedded view of my List it displays the Delete function which I do not want functional. Does anyone now how to remove this? Thanks, Linda LDay@rooftopgarden.com
How to remove the copy application and the save as script options?
How can I remove the copy application and the save as script options, on my applications, sometimes i see it, sometimes I don't, I don't want people stealing my work so how can I restrict that? Thanks, Michael
How to make a dropdown fields options change on users input?
I am wondering how you can make a dropdown field where there are two drop down fields, and once you select one of them the other option change to match the user input. For example, if the first dropdown lookup menu had options A, B, C, and D then if the user selected option B, in the next dropdown lookup menu it would list options Z, Y, T, and F but if you were to select A from the first dropdown lookup, then the second dropdown lookup menu would change to select X, M, L, and K. I really need some
Unable to Export Script
Hi I just designed an application and I want to export the .ds file. But I click on the "Copy to Script" and it just sends me to a blank page, it doesn't give me a .ds file. I need this fixed ASAP!!! Please Help! The URL is http://creator.zoho.com/connectedsitesolutions/mosmobileshrm and it is shared with Support, please help me fix this. You can also attempt to download it and email it to me at macfamily dot wilkes dot michael at gmail dot com. Please help me get this fixed ASAP! Thanks, Michael
checkbox field with three answers required
How can I configure a checkbox field with 6 choices to return a error message if less than three fields are selected?
Ical Feed - Google Busy/Free
I was finally able to get the Ical Feed to work in my application; however I am now trying to figure out how to only show free/busy details on the Google calendar (if the user is not logged into that Google Account) For primary Google calendars, you can maintain this under the "Share this calendar" setting - "Share only my free/busy information (Hide details)", but I don't know how to do this or if this is even possible. The purpose for this is for a reservation calendar. I want the user of the
Populate a stateless form with data using function
I have a few stateless forms in my application that are similar in appearance, other than a few fields. Each one pulls similar data from different forms (tables). Instead of tonnes of code for each form, I would like to populate the fields in this form using a few functions depending on the form being used. An example of the some of the unbound forms would be something like this: FieldName FieldType EventID Number Associate String Agency String My question is, what would the
PROBLEM: No FINISH button when Importing a .xls file to create an application
Problem: After uploading and attempting to import a .xls file to Zoho Creator to create an application, the on-screen instructions say to click a "finish" button when the user is done making changes in preparation for field and data import & app creation, but there is no "Finish" button visible. I tried this same process in 3 different browsers (Safari, Firefox, and Google Chrome), and the results were always the same - no "finish" button. (See the attached screen shots and .xls file attachment.)
Calendar View
I wish there were an option to have the Calendar in 'Calendar View' begin with the current week rather than the first week of the month. hughes
Clear an integer field from a stateless form
Dumb Question... How do I clear a value from a BIGINT on a stateless form? I've tried setting the field to: "" and null but I get the following error messages: Error in statement at line number 30 The template variable intEventID is of type BIGINT. But you are trying to update it with an expression of type STRING Error in statement at line number 30 The template variable intEventID is of type BIGINT. But you are trying to update it with an expression of type NULLTYPEand clear and reload don't
Database Restore Not Working
I have a database that I had backed up in order to safely fiddle with the code in the live version, with the option to restore the previous version if the code didn't work. Upon trying to restore the database, I received the following error message: com.adventnet.appcreator.parser.application.ParseException: Encountered "1" at line 10, column 19. Was expecting: ... I can recode the application, but it will take a long time. Is there any way to restore my application properly? Thanks Leo Saumure
HTML Problems
I keep getting errors when i try to run this script. Any assistance would be amazing. Here is the error: Error occured while executing the script. Unable to update variable Error occured and here is the HTML: htmlpage Dashboard() displayname = "Dashboard" content <%{ TeamName = thisapp.employee.getTeamName(); role = thisapp.employee.getRole(); addEmpUrl = ((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#Form:Basic_Information";%> <table width="100%" cellspacing="10" cellpadding="5"
formatting text in multilines fields
I would like to add some test to a multiline field using Deluge on the On Edit / On success action. Someting like input.LongText = input.LongText + "added on " + zoho.currentdate; Say thay I want the date on a new line and in bold. How can I do this ? If I use escape characters for new line and carriage return ( ) for some reason they are only executed the second time I load the form (I have to reopen it and resubmit it) and if I use tags for bold (<b>) they are executed in View but are
Help Needed: Making Password Recovery
I am making a password recovery app for a website that doesnt hae any sort of password recovery. I am having trouble with the Fecth Records part of the app. I have the add records thing down but i need help with the other. I have Allow Edit for support on it.
Newbie Question: How to make a form with dropdown fields behave according to user input
Hi there, I have been trying to create a custom form, kind of a diagnosis tool for a medical website, that will react according to what people input. I would like you to help me a little if possible with the basic/simplified template, and I should be able to work the rest by myself (hopefully!). I have tried to work it out by myself by looking at the help section, the support forums and by trying it but I just cant make it happen. The form should help user to find common outcomes and treatments
How do you have the date automaticly generated?
I have a date field and I want to know how to have it automaticly fill in the current date. Any help would be great. Thanks, Michael
Signup Form Error
Error details: Error occured while executing on validate script. Unable to update variable Error occured Username: michiananetworking application: MNMembership
Multiple select and Counting them indvidually.
I am using multiple select check boxes and want counted individually, now it puts all option in string. How do I get out of this? I want each counted as an individual variable. Please check off all that apply I would like to have more data for funding reports I would like to know how long it takes for my staff to complete certain tasks I would like to better calculate our impact I would like to improve our communication and outreach
How to make a hierarchy?
I am designing a HRMS and I need to know how to make a hierarchy so that I can allow people to only access information they are privileged to see. Is there anyway I can do this? Any help would be greatly appricated. Thanks, Michael
Mailing List App
I'm looking at options to improve the user experience for a mailing list (announce only) service. Right now, my organization is using Mailman. It seems to me that the Creator platform could provide a very nice mailing list service with features only available on high-end mail apps. For example: a newsletter could be personalized with "registered" user's names personalized "un-subscribe" links could be added to the bottom of each email (url encoding to stateless forms) user's could have a dashboard
form does not save records on submit.
Please help. I have a form that works....except it doesn't save records!!! I will share this to support.
Renamed application still appears with old name for shared users
I renamed an application that has shared users, but the old application name still appears in the list of shared applications that users see. When a user clicks on this, a message appears saying application does not exist. I had to remove the shared users from the new application name and reassign them again for the new application name to appear in a shared users list. The old application name however still appears. Is there any way of removing this old application name from the shared users list?
Currency
Would it be possible to add GTQ currency for Guatemalan Quetzales?
Formula Scripting help
So I feel like this is probably a simple answer, but I can't find reference to it in Help and it's taking me a really long time to figure out: When I'm defining a formula, how do I refer to a value that's in another form? I know I need to do Fetch Record, but everywhere in the form definition scripting that I try to put it seems to be wrong.
How do you add a button on a form?
I would like to add a button but am not sure how, could somebody enlighten me. Thanks, Michael
How can I add new values/items in a lookup field?
I know lookup fields can be used to create a one-to-many relationship between 2 forms. I have a "Company" form (the "one" of the one-to-many relationship) and a "Issue" form (the "many"). When I am editing an "Issue" record and discover the necessary Company name is not in the lookup filed, I would like to be able to add the new Company name without leaving the "Issue" form, adding a "Company" record, and coming back to a "Issue" form. I've seen several posts about limiting/filtering the values in
Email having data deleted.. pl. help
I have created a questionnaire (form) for collecting data. (Perhaps accidentally) I deleted the email (received in my Gmail account) having the data (filled questionnaire). (even I could not find in Trash and Spam). It was very important for me. Please help.
Linking Creator forms to Spreadsheets for accounting?
Hello, My organization uses Zoho for a funding request system, where we manage about 140 different groups, giving out money to them using a form-submission system of approval for purchases. We already use Creator for our forms and keeping track of where a submission is in the process (Submitted, Pending, Approved, or Denied). However, we want to take it a step further, so that the dollar amounts that have been approved can be automatically added to spreadsheets, that could then track groups' spending
Copy Record To Another List
Lets say I have two lists(forms): Leads and Clients How can I add a button to each entry in the Leads list that would say "Copy to Clients" and copy that record into the clients list The lists are formated like this: Leads Name - Phone - Email Clients Name - Phone - Email - Address Thanks for any advice or info!
Linking Forms
I have an input form which I have created. I would then like another form to be created where the first field would be say - Job Number. Based on this job number, fields would be populated with details entered on form 1. Additional fields would then be completed as necessary. I would want an automated form of look up based on a condition where the job number = xxxx. Any help much appreciated.
removing "View Log Details" from a form after submission
please tell me how to do this.
Embed in website not working?
Hi I am new to this product (it's great so far!) however, when I try to embed the form I've created in my website, I don't get that as an option in the drop down for "More Actions" in Form view. Any suggestions? I'm using it for free at the moment - not sure if this makes any difference as to the functionality....Thanks.
Next Page