Is there a way where you can use a single line field to look up a list of employees from a lookup field and only choose from that list?
Thanks in advance! I have an Employee Name dropdown field with over 100 entries. I am looking for a way where there would be a single line box where if user ABC starts to type AB, it will pull a list from a view that begins with ABC. I am trying to avoid a long list to choose from in a dropdown. Right now my dropdown is configured as a lookup to its view list of employees. Thanks, Chris
Cannot edit any records and views have stopped working
Today i made a change to a field type from number, to text. It was a field that only had a couple entries in it. I read the typical delete your reports message which was fine since there were no reports based on it. I then tried to edit the field that i just turned into a text field. I was unable to save the changes when i clicked on edit and made changes. I then went to grid view and was able to make changes and save it. Now this field that was changed to text does indeed have numbers and words
Placing Button on Form
I somewhat new to the developer side of ZoHo Creator .. so maybe I just can't see an obvious thing .. but .. How can I add a simple button to a form to spawn off another web page? -bob
Single Line Text fields showing as multi Line
Noticed this morning that when editing the definition of a Form ... if I click on the Edit this Field link for a Single Line Text field, the resulting popup form shows the current value for the dropdown labelled Field Type: as Multi Line The visual for the field is still for that of a Single Line Text field ... but I am concerned about making any changes (to other properties of the field) in case it corrupts Client's Application data. @ZOHO Creator Team ... please investigate and advise ... - when
Converting a date/time string to the right Zoho date/time format
I have a date/time string in the format of "2010-08-01T18:07:22-06:00". I'm trying to convert it into a date/time variable in Zoho. I'm using the .toTime() function on the string like this: datetime = datetimestring.toTime("yyyy-MM-ddTHH:mm:ss")When I execute the script, it gives me an error that it's "unable to update variable datetime." So there is an error in converting the string to a Zoho date/time. I'm thinking it might have to do with the timezone on the end of the string (-06:00), which
Embedding a Creator Form into a secure site (SSL)
I have created a form in Creator, which I embed in an iFrame on a web page that has an SSL certificate. On certain IE browsers I get an error loading the page stating that some elements may not be secure. The only element on this page that isn't secure is the iFrame. My hosting service had me check all the HTML that we could find, looking for links in the iframe that referred to the unsecure (http:) site address instead of the secure one (https:), but we couldn't find any. Is there a way to
Google Login Disappeared
Hi, The google login button has disappeared from Zoho creator. The only way I can get into my account is to log in via zoho wiki and then open creator. I have tried IE8, Firefox 3.6.8 and Chrome 5.0.375.125 beta. See attached screen shot. Can you explain?
Zoho Invoice is make with Zoho Creator?
Are all types of forms, lists, features that can be seen in zoho invoice can be done with Zoho Creator? Thaks for all.
Creator.zoho.com link timing out for last 10 minutes
Huston, do we have a problem? Im in Wellington NZ I can access other apps, calendar & projects Richard
Numeric Picklist?
I am trying to create a picklist with a range of numbers (1-9), but it seems to save the selections as stings rather than numbers. Is it possible to have a numeric picklist?
HTTP Headers when using Zoho Creator
Hi, Fist of all I would like to say that Zoho Creator is a great product/service! I was looking into do some integration with some Google API's, so is it possible to define some HTTP headers, like Content-type, etc ? In some Google services you have to do things like the example bellow. Is it possible to do it with Zoho Creator ? Regards ------------------ Google - Obtaining an Authentication Token To obtain an authentication token, submit an HTTP POST request to the following URL: https://www.google.com/accounts/ClientLogin
Unstable Questionnaire
HI! I'm using a Zoho creator questionnaire for a graduation project where people have to give feedback on and upload their training sessions for the Amsterdam marathon. However, some subjects complain about not being able to upload their training sessions. After filling out all the required field the 'please wait'-text appears but than nothing happens, I'm not receiving the sessions either. Could it have anything to do with the verificationcode? The questionnaire can be found www.elkestaptelt.com
Make my form public
Why cant i make the form i made public? It will only allow me access to private. All i get is an error on page. Can you help?
Error message
I often get an error message that records could not be updated. There is an option to click for details, but when I do, details are out of view in the box and can't be seen.
How to Feth HTML Data with Xpath?
I would like to retrieve data from html pages using xpath. With Google Spreadsheets this is possible using this kind of code: =importXML("http://www.google.com/search?q=live", "//a[@class='l']/@href") The problem with Google's service is their limitation of external calls. I've read Zoho's documentation about retrieving external data, however I don't quite get this. It looks like one can only fetch xml files, not html pages? Is there a solution to this? If it's not so easy, I'm willing to pay a bit
I can't add any record. My limit is zero
Hi I can't add any record. My limit is zero. I can add upto 1000 records using free account right? Thanks
Semicolon Bug in Grid View Mode
Hello, I would like to report a problem / bug. When a user fill out a form to insert a semicolon in some field, no problems. But when I view this form in grid mode, and try to update it, the semicolon induces the system to interpret it as a jump to the next field, so that, in theory, data filling in "move" a field forward. For example, I have a form fields A, B and C. The user fills the field A = "aaaaaa", B = "bbbbbb;" and C = "ccccc", and C required field. Verify that B has the ";" semicolon, and
Load forms conditionally?
Is there a way to load a form from a script other than the openUrl? I want to redirect the user to another form where they enter default data when they first start using the application, but once it is populated they no longer need to see that form. I wish I had more time to read every posting, there is a wealth of ideas and information in these forums. Thank, Ken
data dictionary problem
My application was working fine and then I started to get these errors. I deleted all the data and even tried recreating some of the fields, but I can't seem to get it fixed. What happened? 1 . [t_547125000000097967] Exception occured while setting value in PreparedStatement for the Column [aborted_547125000000123120] Check whether the datatype for this column is given as specified in the data-dictionary .[t_547125000000097967] Exception occured while setting value in PreparedStatement for the Column
form disappeared
Jeez. Form disappeared. Can't access it. Spreadsheet still there. Help!
How to Populate Dropdown with Selected Values from Multiselect field
I am trying to use the selected values in a multiselect field in one form to populate the dropdown values in another form when the records match. 3 forms in all are linked. For example, if I have a multiselect field called "MM" in a form called "FormA" and a dropdown field (called "DD") in a form called "FormC". FormB contains a link field called SubID. FormA has fields: ID MS FormB has fields: ID SubID FormC has fields: SubID DD So if I select a SubID in FormC I find the record in FormB where
Moving an application
How do you move an application created in your personal workspace to another workspace?
User Account Info Help
How do I allow other users to edit my applications? I have other users set as developers in my account but they do not get the "Edit this application" option when they are viewing my applications.
Zoho Form and Trac Wiki
Is it possible to embed a zoho form within the trac wiki system? Joss
How to have a field (with number entered in it, e.g. 12), produce a corresponding number of fields for entry.
I am working on building an educational assessment tool for teachers to share data. I can't seem to figure out a simple way to do what I want, so I thought I would ask. If the user enters "12" when prompted for the number of students in his class, I want an action that generates 12 blank fields for student names. I hope someone can help
Specific Email Check Validation
I only need to accept form entries from certain email addresses. For example only people who have "@usc.edu" in their email address needs to be able to submit my form. If they do not have "@usc.edu" in their email address they need to see an invalid email address message. Does anyone know how to do this? Thank you in advance for your help.
Linking Zoho accounts/files
how do I link Zoho Creator files with Zoho project accounts
Access ZOHO Creator Application through ZOHO CRM
We are using ZOHO CRM enterprise edition in our company and we have around 50 users. I am the ZOHO CRM administrator. Basically, I want to create an application in Zoho Creator and include it is a part of the ZOHO CRM using the Web Tabs. My question is ... will the other users of ZOHO CRM be able to access this application. Regards, Renuka Chillal RIM : 09320 551753
Deluge help: adding to a list in another form
I'm trying to write a Deluge script that will add a name entered in one form (interview form) to the relevant address records in another form. Since the address records may have more than one name associated with them, I need to be able to add a new name to that field without compromising the old ones. In addition, I need to be able to remove the name from the address record just by removing it in the interview form. So far I have gotten the addition and removal to work when the addresses associated
Function Insert into
Hi, I have script which insert the data in to different form when condition happened, from last two days it stop working, i have gone through the script, it's fine no change has been done. Please do the needful. I have already allow access to support. my form name to_do_form (application penta_crm_10). Script start from line no 115 to 141. Comment // Auto Cash Entry in Finance Thanks.
Google Map integration in HTML View
Does anybody have a sample app using Google Map in HTML View ? I'd like to show a customer or a list of customers on the map. Thanks, Pascal
How can assign a permission to users for a Form or View?
Hi Harsha How can assign a permission to users for a Form or View? it's mean is user can't see the form or view if admin not assign the permission. but I knew that Office Sharepoint can do that even assign a permission to a record.it's future very usefull. Thanks! Stanley
Allowing new members to add themselves to the database?
I want to allow people to add themselves to my database from a web page. I realize I need to make the application public. However I don't want anyone to be able to read the database, and I don't want them to have to fill out all the fields. How do I restrict reading and limit the fields offered (through a view?). -- Kristy Dyer
Can not Share Views - Error: You are not allowed to view / edit the script.
When I edit views & forms, there is no 'share' tab - I am logged in as admin user. If I click on 'View Definition' for the view, I get the error: You are not allowed to view / edit the script. I finally found the 'share' tab so that I could assign non-admin user permissions to the custom view I created. However, whenever I click on the share tab it takes me to the 'Add Request Via Email' form & the share tab goes away. Thanks! -Randy
Is there a way to hide user input with dots or stars?
Is there a way to hide user input with dots or stars?
[ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
I tried to view the form via "form definition" to look at the code. But I got this: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' It's in my app movies*******
Is there a way to hide user input with dots or stars?
Is there a way to hide user input with dots or stars?
Linked To Asset: null - Can't link Requests to Assets
When I create a Request, I assign it an Asset. But when I view the request it shows: Linked To Asset: null When I edit the Request, I see that the Asset is assigned. I don't get it. When I change the Request so that no Asset is assigned, the main view of the request shows: Linked To Asset: -None How can I get Requests linked to Assets? Thanks. -Randy
Export of blobs
I have just created a test-db with a file-upload field. How can i export/mass download uploaded files (blobs) from a creator db?
URL Link to change the value of a decision box in a specific record
Hello my Zoho-ites, I've been reading the user guide section, but cannot solve the issue I'm trying to make. I would like to provide a link to a decision box to change the value from false to true by clicking on it. Does anyone know how? I don't want the user to view the record. Thanks for any help! Joe
Next Page