Reset form On Success
I am using a form in an iframe to create a Facebook tab. To do that I am using an Wordpress plugin, Facebook Tabs. This means I effectively have an iframe inside an iframe. This is OK, except the form will not redirect On Success. Is there a way in the script to at least clear/reset the form? I can cope with the redirect failing, but I do need to empty the form. Adam
Bulk Edit-Bug or Feature
I'm not sure if this is a bug or a feature. I tried to do a bulk edit on a field that is shown in the view but is hidden on the form. There was no error message but the value did not change. When I removed the hide statement from On Edit->On Load I was able to bulk edit the field. Thanks Herb Wexler
Photo upload
Hi, I am setting up a database/online form for a project called Muddy Water Watch in Zoho Creator. I have enabled a field to upload photos so that the volunteers can send in their photos of sedimentation pollution when they enter a Site Report. I can view my test photos in the database, but I can't view the photos when I export the data and they are not attached to the automatic email notification even though I have enabled User Submitted Data. Everything else comes in the email, but not the photos.
Search and Auto-Complete in bi-directional lookup fields
Hi ZC, I have a lookup field with bi-directional links (both multiselect). 'Search and Auto-Complete' is enabled (Form A). On the other side of the lookup field (Form B), I want to enable 'Search and Auto-Complete' too ; but then, in the original field (Form A) the 'Search and Auto-Complete' has been automatically switched to disabled. I did the reverse, and it's the same : actually 'Search and Auto-Complete' is possible in only one side. Other remark about the 'Search and Auto-Complete' with checkbox
Zoho App Hosting
After creating the online database can I have it hosted elsewhere in other webhosts?
Creating Facebook-like Public Facing Profiles?
I'm thinking of using Zoho Creator to give my vendor-clients the ability to manage a publich facing profile that our customers can view. In some ways I envision it being something like facebook, but without all the permissions issues. I simply need to create a long form that all vendor-clients complete, and maintain. We currently track about 100 different attributes about each vendor (like whether they have upgrades, cost, bolt on products and such) and with over 200 vendor-clients I'm looking
Updating existing data in a form through Excel import
I want to update existing data in a form through Excel import. How to do it?
Login Issue in embedding in other site.
I am facing an issue. I had created the form in the Zoho creator and it is in private Access. Once i embed the form in my webpage, It will ask for Login for the form. It was shown in the attached screenshot. [File name: beforeSignIn.png] After i logged in, The form is embedding in the same iframe. Refer to afterSignedIn.png. But i want to redirect my webpage to another page, which contains the form of my application created using zoho, once it is Logged in. Is there is any other options to use
CAPTCHA component in Zoho Creator forms
Dear Zoho Creator Team, Is it possible for you to introduce a small CAPTCHA field in the toolbox used to create forms? I think that would be very much beneficial to combat spam robots visiting the form. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Update count
Hey, I'm trying to use the Fetch and Update records to update a count/total number of items. eg I have an inventory form with toner cartridge with a count, eg I have Model: "lexmark T644" Cartridge: "black" number: "3" And so on for each item. In another form, when people input they changed one of these, how can I update the count from 3 to 2? eg minus 1?
Missing Feed URL tab
I would like to generate an RSS feed on my database, so i can import 'm in Google Reader. On this webpage https://help.creator.zoho.com/Import-and-Export-Data.html i see a FEED URL option, but i can not see/ enter this tab.
Ticket ID: 934663 (7 Days A go)
Dears, I send 2 mail but no any answers. I am still waiting... Rgds CTG
How do I paste the contents of one field into part of another field?
Hello - In my database I have a field called "subdomain", and then I have six other fields called "URL Europe", "URL Alaska", URL Caribbean", etc. The six fields have exactly the same content for every record, with the exception of the subdomain. i.e. - http://[subdomain].europe.myvacation.com http://[subdomain].alaska.myvacation.com http://[subdomain].caribbean.myvacation.com I would like these fields to auto populate once the subdomain has been entered. What is the code to program this? Also,
Workday function
I am familiar with solutions from here https://help.zoho.com/portal/en/community/topic/calculate-number-of-business-days-weekdays?reply=true But I don't understand how to use it. I have formula field named "Day" with this formula: ((zoho.currentdate - Start_Date) / (1000 * 60 * 60 * 24)) "Start_Date" is data field. I want in output to exclude weekend days (Saturday and Sunday). In other words I want formula only to calculate business days. I am happy to pay consultant for help.
creating a pivot table or report which contains text
Hi I am new to Zoho - I have created a database which contains statements - goals to be exact, that are filtered by a number of sub categories - I want to present the data in a pivot table so the views can be easily changed. however I can only get the pivot table to show numerical data - is this correct? is there a solution? Any help would be greatly appreciated. Sophie
How to export to Excel
While the help topic says to go to live view and there will be a drop down menu of more actions, and then select export data. On going to more actions I do not see the option "exprt data". Can any one help ?
Delimiting Multi Select field with Line Break instead of Comma?
Is there a way to make multi select fields put each new entry onto a new line? Rather than delimiting with a comma delimit with a line break? I want my multi select field to put a carriage return after each selection so that when it shows up in a view it DOES NOT LOOK LIKE THIS.. 09-Jul-2010 - First Sale - BC Boxing - Strategic Edge, 13-Aug-2010 - Meeting Room Rental - Best Western Duncan - Strategic Edge, 29-Jun-2010 - First Sale - Raemar Restorations - Strategic Edge, 12-Jul-2010 - First Sale -
Will not graph a calculated field
I have created a simple graph that plots two simple number say x and y - all OK. When I create a calculated field y * 100 it will not plot and says data is unavailable though the calculated data can be seen in the data view OK. I can see no reason for this so tearing my hair out! Chris
---> !! ---- > !! . How to have drop down choices stay selected and not reset to top after submitting a record ?
So here is the set up.. The way my form works right now , is teacher picks from drop down their name, then their location from the second drop down. Then the teacher enters name of a student in one "single-line" box, and the students email in another single line entry box. .. then they press submit.. Only to then repeat the process, each time re-picking their name (instructor drop down) , location (drop down), then entering student, name and email into single lines ... So my thought was, could
Spreadsheet feed not importing some data
Hi, I have a problem with my View CMC RSS Cardstudio CartdoDia, because when I capture the data with Excel (spreadsheet feed) a column called "Pacom válido até" still no importing data and display a blank column. Thanks Mic
Stateless Form Submission and input.ID
I have a stateless form that submits data. Part of this data is a url link to the record created by the stateless form. The problem is, in constructing the link in the stateless form OnSubmit script I'm using "input.ID". This value is being assigned null in the record. I was under the impression that creator might hold a value for ID in case the stateless form called for it. I guess not. Now I'm left with having to script and assign my own "ID" to reference this record. Am I totally wrong, or is
Create a form and view by anyone is not free NOW !
Why ? I use zoho creator during 6 months. And now, when i want to use form to anyone, the option "To access the form without login" is not allowed ! Please go back ! I need it !
Grid view does not work properly.
I can change the display view from List to Grid OK in "More Actions/View As", but I can't set it to be the default. If I choose Grid to be the default Display Type, it shows in List format.
Data collection and input with restricted access
Hi, Just a quick question. I am looking for a data collection application much like microsoft access in which variables can be edited and submitted by my clients, however they are unable to view other individuals data. This is vital as the data I am collecting is confidential. Is thia possible on Zoho, or is it only possible to allow the individuals full access by making the file public? Any information would be gratefully recieved, Kind regards, Andy
Problem editing and deleting entry
Hi! I have imported data into Zoho Creator and all seemed to go well. However, i noticed that I cannot update or edit the updated data. When I edit an imported data, it first said that "Data Updated Successfully" but then later I got this error message: Error occured while on Update script. In the subString function length of the parent string is 0 but the end index is given as 2. Please also see attached. I don't understand this because I don't get the same problem for the manually entered data.
multiple criteria in .contains ?
What is the syntax for .contains for multiple criteria? field.contains ("blah") something like field.contains ("blah" OR "foo")
Where to I go to add custom text to the top of my database?
I use Zoho to host a coupon database on my website: http://www.simplesavingsavvy.net/coupons/oklahoma-inserts/ I need to edit the text a the top of the database (please see link). I can't remember where I first added this. Have looked everywhere. Help!
How do i get a submenu field to = the option chosen in main form dropdown field?
how do i get a submenu field to automatically correspond with the the option selected by a user from a drop down field in the main form?
Change ownership with Google Accounts sign in
Hello! I would like to change the ownership of my Zoho Creator project, but I want to pass on the ownership to someone who will log in with a Google Accounts ID and not a Zoho ID. I know I can change ownership by adding an admin and then make it as primary, but since the "Add a new email" page asks for an email and password, I don't seem to be able to indicate that the passing on will be through a Google login. Is there a way to override this?
custom action to download attached file from multiple records
I've a form with a "file upload" field. I want to build a custom action to download this file from multiple selected records. Any ideas?
Noob Question
I have manged to get my head around populting the fileds within creator and then linking them back to corosponding fields in zoho crm but what i want to do is create line of instructional text to show on the form. Can anyone give me an idea of who i do this with maybe an example, explination or code snippet. Thanks Chris
Import date errors in Zoho Creator
Hi When I import any data into zoho creator document view I have created, if the date on the data is older then the todays date it give an error Row 15 Col 15 - Value '24-Jan-12' is not a supported date format Row 15 Col 16 - Value '24/1/2013' is not a supported date format Row 18 Col 15 - Value '01-Feb-12' is not a supported date format Row 26 Col 15 - Value '01-Feb-12' is not a supported date format Is there something I am missing? I have a lot of data and I don't to want add each date manually....
Set the Minimum Characters in a Text Box
Is there a way to set the minimum number of characters required when a user fills a text box? I need to set a team number to be exactly 10 characters. I see how to set the max, but wasn't sure how to set the min. Thanks
Checkbox
Is it possible to add script to a form that would result in unique data entries for checkbox selections -- for instance, I have a form with "Date" -- "Lecture ID -- "Students" with Students being a checkbox listing each student. The default creates a data row for each submission with all student names in the same cell. I would like to code it so that for each student checked a unique data row is created in the view. Is that possbile?
Chrome compatibility
Seems the google's browser not compatibile with ZCreator. If you try, x exemple, to edit a Form, after More Action and after Set Email Notification the screen remains gray... nothin happens. The same trying to put that post in forum from chrome... Please check it and let me know...
Moving Forms
Hi, quick question. I created a form in a new application and now want to to be associated with another application. Is there any way to transfer or copy the form to another application in creator without recreated it? Thanks heaps Jason
Parameters in url to filter a view on related data (lookup field) ?
Hi, is there a parameter to use in URL to filter a view with data witch comes from a related field ? I know I could add a field in my Parent form and copy the data (of child form) but I have a lot of related fields, and if we change data in child form, data won't be updated.(-without writing a script) Do you plan to allow it please ? thanks Cyril
Need Help
Hi When the lookup field drop-down, it was the rich text field covered, it's need to fix? Thanks Stanley Guo 2012-2-18
Looking for a Zoho developer consultant to help freelance
We are a boutique advertising agency and set up a zoho database for a major client with a web developer who has retired. HELP we need someone who is very zoho savvy to freelance for us - make updates, train our client, offer advice, support ongoing for hourly fee.... We are in Australia (Brisbane) ideally someone local but fine if overseas
Disable Rich Text-not working
When a Rich Text Field is Disabled it still allows users to type in the field. As a test I switched it to a multi-line text and it is disabled as expected. Thanks for looking into this Herb Wexler
Next Page