Export data from Zoho Cretor view to Zoho Spreadsheet
I export data from one of my Zoho Creator private views (e.g. Mevi) as a CSV file not requiring login, but Zoho Spreadsheet does not want to accept it through its 'Link external data' feature giving me the message 'Problem in configuring WebData when linking external data'. What an I doing wrong? Thanks for help.
How to manage users in a Creator application
Can anyone help me find out how I can mange users in a Zoho application I have a time management system and I need 3 levels of authority (e.g., User, Supervisor and Admin). When a User logs in they can only see their tasks in the appliaction and update their tasks and they can't say run reports in this application. When an Admin signs in they can see all the tasks of all users in the application and they can run any report they want. How can I create these different levels of user and allow them
problem with hide field from others option
I want to let you guys know if a field is set to "hide from others", it often wont update properly. I noticed this because I couldn't find certain records in a view that had a criteria based on it. For me it was a field called Job Year and it updated on user input of Job Date. After, I was trying to find completed jobs in a given year. May I suggest getting rid of the "hide from others" option. It's just as easy to hide it within the on load script. I don't really see the point of having both. Thanks.
Form layouts
How can we modify the form layout, color and such? Currently, all my forms have two columns. What if I want a compact single column? I've been searching the User's Guide, but haven't found anything. Thanks, Joe
Custom Buttons Deactivated on Form
I have a form (TrialMapCrit) which is a stateless form that previously had no problems. Now, however, the custom buttons are not working after anything on the form is selected (radio buttons). I've tested it in Firefox and Safari but none of the other browsers. Please advise.
Another piece of functionality reported to have stopped working in my Client's Application
@ZOHO Creator Team: I just received an email from one of my clients (who went live in January/February) ... stating that as of the last hour or so, all functionality of a certain type has stopped working. This functionality is that ... I have Single Line Text fields in records with content of the type ... http://creator.zoho.com/MYACCOUNT/MYAPPLICATION/view-perma/MYHTMLVIEW/ContactNumber=105 ... so when he is looking at a List View, a column contains the links to associated child records. He says
Sendmail limit ?
May I ask...when I want to list a html table as below coding to show all the results of picklist (around 30 individual picklists), it failed when there are more than 30 picklists.. html = html + "<tr><td>Item Name</td><td>Price</td><td>Qty (=input.picklistA)</td></tr>"; Item Name <- Is it have a way to let me call them as this is the displayname of picklist such as input.formdata done ? I have tried to rewrite from http://help.zoho.com/portal/en/community/topic/can-the-sendmail-from-a-form-only-send-data-from-the-decision-checkboxes-selected-by-the-user
Permissions
I have created a simple form which I have uploaded onto a website. I have also uploaded the view to the website. The idea being that visitors can view and make simple filtered queries on the database. However the view (on both the website and within Zoho Creator) allow visitors to add, edit and delete records...which I don't want them to do. I haven't checked the boxes on the permissions page. Any ideas?
Pulling information from Zoho Creator
Hi, I am creating a database for customer information: I need to pull the following information EASILY: 1. Birthdays (for birthday promotions) 2. Services they receive. Currently I have services in Checkbox - but maybe that is not the best way to use it. I need help guys!!! Dana
HTML View for each record
How do I generate an HTML view for each record I have? I was hoping to use only one page and depending on the record ID, the HTML page would show the fields specific to that record. I tried adding a "thisID" parameter to the HTML view but that is a type string which can't be compared using == to the type int ID of the record. I want to be able to look at a list view, click on a link in it and have an HTML page open with a summary view (or something along this line) of that record. Is this possible?
Fetcing a SUM would be very helpful
I would love to be able to fetch a sum instead of just seeing it in the view! Using deluge script, I was thinking that if you used the "for each record" to fetch the specific numeric values from a collection/form. Than maybe a built-in numeric function called "SUM ()" to Sum all of those a values to return a specific "SUM" value to a field. This would be very helpful for our business as I use Creator to make invoices and it would save alot of time to not have to manually add or subtract 2 sums to
Employee names
Shouldn't there be a employee database linked to this app too?
Can't find View to edit
Hello, If I click on a request, I see a field called due date. This field is really Deadline_date which is auto-calculated from Priority. I wanted to have user selected Due dates so I created my own field called "Target Due Date". I managed to replace "Due Date" with my custom "Target Due Date" in almost all views. The problem is that I couldn't not find the above mentioned view. To see what I mean, click on a request and you will see a field in the top section called Due Date. I want to replace
Initializing a timestamp data type in a dropdown list fails
I have a date field in one form and use this data to populate a drop-down list in the second. By using the second form "edit - on load" event, I save the previously selected value in a variable then repopulate the list based on other selected values in the second form. I then try to set the date value back to what I saved in the variable and it fails to work. I end up with a correctly populated drop-down but no value initially selected. This technique works for other data types. If you're able to
comparing two dates in a form
i want to be able to compare two dates. The user enters one date in and then, in the same form, after the first date, they enter a second date. I want the fields to compare each other and if they aren't a tleast two weeks apart pop up with an alert. I know how to do the alert but dont know how to compare to dates in an if statement. How do i compare two dates in an if statement? is that how i would do it? I assume that both fields need to make the comparison but how do you deal with the first field
User application
Hi, how can i upload user application in Zoho ? Once done, are they running even if i disconnect my account ? Thanks Massimo
Filter View using URL
Could someone help me construct this openURL statement. The image below kind of shows what I'm trying to do. When the clicks the conflict button on the bottom right of the screen, the application will run the openURL function that will filter the view by the Associate appearing in the lookup (near bottom right of main form) field as well as filtering by the date (date only) appearing in the Start Time field. I've tried many different permutations of the openURL, but just can't get it right. Here's
File upload feature
For the File upload , we can't set only image file (.jpg , .png, .gif) to be uploaded? I don't want user to upload any program file into my server.
MAX Records reached - without adding records ALL OK now
Thank you ZOHO support in particular Ruben who attended to this issue so quickly. Everything is back to normal running smoothly. Thank you for your tips on how I can avoid myself causing this again in the future. Keep up the good work, geatly appreciated. Regards Mark.
MAX Records reached - without adding records
I was just performing a task that involved script but did not involve adding records and I received the following message. Error details: Error occured while executing on click script. The maximum number of records that can be added per day is reached. Please see the usage limits per day int the account setings I checked the Usage Limit Details and it reports that we have not crossed any limits Right now my customers cannot make any enquiries and I cannot make any bookings - Why is this - URGENT
Restrict users from seeing other users records BUT NOT THE ADMINISTRATOR?
So i want to restrict the records that users can see. I have used the code below in my view script to only allow logged in user to see their own records. displayname = "Your Submissions Grid" show all rows from LeadsYour_Closed_Deals_Submission_Form [Agent_Email == zoho.loginuserid] This part is easy and is working just fine. The problem i have is as the administrator i want to see all records and i do not want to need to duplicate all of my views. Using this method it blocks me from
Change in behaviour of combo boxes
Was there a recent change in how combo boxes could be updated? Until recently, I could use script to add records to a table and if the combo box was "-Select-" it would save it without issue. Now, when using script to add records, I get an error message if the combo boxes read "-Select-". Was there a change recently that would result in this behaviour? Leo Saumure
How to restrict zoho account users to complete a form based on choosing another users name in a drop down list
Hello, Thanks for the help in advance. Currently, any user that logs in my Form can choose any user from the drop down field to enter data to complate the form. Is there a way where if Zoho user account A logins in the application and not be able to choose user B, C, but only can choose A. Also, would like user A not be edit current rows for user B of C in my view. Thanksssss D
Mac Safari and Chrome browsers remain unusable in Creator's Free Flow Editor mode due to text artifacts (images included)
As seen in the screenshots below, Creator Free-Flow editor cannot be used in either Mac Safari or Mac Chrome due to uncontrollable text artifacts in the editor window. Works fine in Firefox, but sometimes I need to use Safari or Chrome. I know this problem has been reported a good while ago, but since Safari just released its 5.0 version, I did a fresh test. datazen1@gmail.com Santa Fe, New Mexico US
Funny Character and Favicon showing with javascript embed
Hi, I'm trying to embed a view in my website using the javascript embed code and I'm getting a  character before a £ sign - £25, looks fine in the view within creator. The page I've embeded the javascript code in in also has the Zoho Favicon showing instead of my own. Any advice to solve would be great. Kind Regards Jon
email form help!!!!!!!!!!!!!
how can I create a email form for my website? and how can I create comment box and rating for my video and pictures? thanks
Template Issue
Hello, How do I make Deadline_Date (Due Date) visible on my "Add Request" form? I tried enabling it on a bunch if views by selecting it in "Column Properties" and "Set Filters". This pertains to the Zoho Help Desk application. Thanks
Why is Zoho re-writing my code?
In my application NewINZDB2, I have a form called frmEvent. Each time I try to write the following code: //Contact if (input.cboContact == "New Contact") { varContactData = tblContact [intEventID == input.intEventID]; varContactName = varContactData.fmlaContact; varContactDetail = varContactData.strAddress + "\n" + varContactData.strSuburb; } else if (input.cboContact == "-Select-") { varContactName = ""; varContactDetail = ""; } else { varContactName = input.cboContact; varContactDetail = input.strContactDetail;
Look Up Field to Link Another Form
When trying to use the look up field in a stateless form to link to a regular form not all the fields already existing in the regular form is displayed for selection. Please help. Thanks, Jasmine
problem with openUrl and Internet Explorer
Hello, I have an application where the openUrl works perfectly with Firefox but it doesn't work with Internet Explorer. Here is the line I use, I open a URL and pass some parameters from my form to another page. openUrl("http://www.gpsopleiding.nl/bevestigingv2/?email=" + input.emailadres + "&cursus=" + input.Cursus + "&datum=" + input.Cursusdatum + "&geslacht=" + input.Geslacht + "&achternaam=" + input.Achternaam, "new window"); This all works fine with FF (it goes to the URL) but on the same
cannot add new column to a view
I am unable to add any more columns from the column properties. I can do it for many views but certain view have stopped working an i cannot add more columns. I can select them as i should be press done and it will say please wait. After a second i will redirect to the preview section but the columns are not added. What should i do? Whats wrong?
No data available
Hello, I copied an application and then imported data into the application. The views are functioning fine but the reports are saying that there is no data available. Is there a time delay between importing data and when the system will index this data so that reports will function? If there is such a delay, what is it normally? If no such delay, would you please assist me? Dion
Modify Edit Record Appearancein a View
So i have a really large form. I have many views. One of my view I have set up to see certain data from the form, only about 4 fields. I want to be able to quickly change a couple fields inside this view. I have only included the 5 fields in the grid view and it looks fine in that view. The problem is when i click on the edit button it opens the edit box that has every field from my form in it. It is very long, i do not want to need to look through all the fields. I just want the items from that
Importing form data dates
I have been trying to import some data into my creator form but cannot get dates to work properly. The dates do not show up after the import even though they were selected to import and proper formatting was used. I got no errors during the import. I know the format is correct because there is an error message if it is incorrect. Please help, i don't want to manually set all these dates!
i like this site
It is not user friendly But i like this site Can u make this as user friendly and i have problem with this site i.e can this website update the datas For example : If i am creating a pivot table for the particular datas. If i am updating in the mastersheet it is not updating in the pivot table
Records pricing
Creator is an excellent application, and I've been able to create web based forms that are quite workable for my organisation. The pricing, however, is another matter. The limit on the number of records is much too small. This would be a deal-breaker for us. We would have to spend too much money for it to be workable. At the premium level, we would need about 100.000 records for it to make economic sense.
Fetch all data for a given "Index"
As I enter data into a form, I need to look up all data that was previously entered into the same form. All of the data will have a unique Index key. As I enter the additional data, I need to compare the new data being entered with past data that was entered. I will need to fetch multiple field with all records previously collected for a given index key. Once all fields for all records has been fetched, I will need to run several IF statements. I know I will be using a fetch script. I just
Zoho Creator Mobile Access
I'm trying to access Zoho Creator on my iPod Touch (ios4). When I go to http://creator.zoho.com/mobile, I'm prompted for my logon information. After entering it, and clicking "Sign in", everything just stops working and I'm never able to get logged in. Is there a problem using Zoho Creator Mobile on an iPhone running ios4? Thank you for your assistance or suggestions.
Input fields...
Trying to figure out how to search for text entered in an input field on a web page if exists in my zoho database. Don't need to show a list to the user, just to verify that a value entered does exist in the database. Where do I begin?
Scheduler Not Working
Hi, my scheduler has usage limit to use, all my shcedules are enabled, but ther are not being executed? any idea how I can fix this problem.? Any help would be greatly appreciatted.
Next Page