Format phone number fields
How do I format a phone number with parentheses, spaces and dashes in a form and/or view?
Error importing ical feed url into Google Calendar
Hi, I have created an ical feed URL for a view which appears to generate the feed correctly. However, when I attempt to add the URL to Google Calendar the following error is shown: "Settings Error Could not fetch the url because robots.txt prevents us from crawling the url." Can someone please advise where I am going wrong? Thanks, Anton
Can I use javascript in a HTMLView??
Hi, I have a View with HTML, and in the table I put a checkbox column, but now I like when somebody clic the checkbox it execute a function, by example an alert box, is it possible?? using javascript? any suggest? Thanks a lot!! Regards
Time Field
Hi, Could someone help me to find a way to use time format like 10:43:01, wich means 10 hours, 43 minutes and 01 second? I really dont know why there aren´t a Time Field in Zoho Creator. Thanks in advanced,
cannot delete view
I am trying to delete some of my "views" but when I go to delete them I am told they cannot be deleted because they are "referred to for SubForm". Anyone know what this means and how I can change it. I seem to have a several views I do not need, but can not delete. Thanks
404 error when creating new app in Creator
I get the following error when I try to make a new app and form in creator: Not Found The requested URL /dannilicic@gmail.com/test/edit/ was not found on this server. The name shows up in the edit list but it can't be edited/found. Is there another setting that I am missing? Thanks for any help.
Filter by Criteria Issues
Thank you in advance to anyone able to help me with this issue. I have a Task Form and in that form is a lookup field "AssignTo" which pulls from the Employees Form to have a dropdown list to pick who to assign it to. Within the Employees Form is a checkbox and the AssignTo has a criteria to filter the dropdown to only show those Employees with the checkbox marked. That way there aren't a hundred names to scroll through but just those that you assign an item to. That works fine for what I need.
How to close window on success?
I have a form that displays the 'Data addedd successfully' message on successful submission. How can I have this window close automatically after this message appears? Is there a on success command for close window?
Extending success message and another question
I've figured out how to send email in response to user input, but have a couple of other questions: 1) I want the user to be see an confirmation of his her record. I've included that in the success message, but the success message only stay on the screen for a couple of seconds. Can I extend the time the success message is visible, or is there another bit of script that would take the user to a confirmation page? 2) Apparently, Creator does not allow the email sent to the selected person to be from
New bug - Form not working properly anymore
I had a form that -once all its fields were filled- used to close automatically and display "data added succesfully!" Now it stays open, doesn't display the message, we have to click "close" and refresh the page to see the new entry displayed in the view... Any idea as to what could be causing this new bug?
Success Message
Is there any way to keep the success message (after a "submit" entry in a form) up for a longer time on the screen? Right now the success message is appearing for only a split second and I need the success message to appear for longer. Thanks!
Help with getting the success message to show in Embedded form
Hi, what is wrong with this script to get the success or error message to show in my form? <script id='zc_external' type='text/javascript' src='http://creator.zoho.com/appcreator/js/embed.js?'https://creator.zoho.com/rrsaddleclub/reserveticket/form-embed/Reserve_Ride/7rFOYP0CO9M3uv3yVTRvD3w56TZHPbeZXKShQhwuRtuBrfD68gsQN6BG9nn3xKaOEZkq9tFGN88PwxOpgQGrg3TsZ0QghbpvvQZ4/'></script><iframe height='500px' width='100%' id='zoho-Reserve_Ride' name='zoho-Reserve_Ride' frameborder='0' allowTransparency='true'
Success Message not popping up on IFrame
Hi there, success message not popping up in I frame for firefox or IE, I saw a solution posted while looking for something else, forgot to bookmark it. What is the solution/workaround please?
Linking Creator Date/Time field to Calendar.
I'm making a form that is going to work as a booking system, where clients can reserve a date and time from my calendar. The form is going to be on an external website so i can show the calendar with no problem. How can I set it up so that when a client selects a Date/Time it will add it to the calendar?
CSS file not found
Hi! There is a problem browsing Zoho Creator forms and views. Can't load the CSS file. URL below is not found: http://zohodynamic.com/creator/css/3295/l4c4.css Cheers.
Problems with Report Builder (again)
hello, Reports Builder in the application: Copy of Tambayan Online MIS is broken again. I tried to make report from Children's Participation View, it can't fetch data from one of the fields: Specific Activities. Please see Report: Child Activity Participation Report Trial. Hope this acted upon soonest. Regards, Edith
How can I pass parameters between form and html view?
Hi, I have an HTML View with the CRM Contacts List, but I like filter by example by Last Name, I embed a form with a label text and a button, in the button clic event I execute the list and I like to pass the result to HTML View like a parameter, can I do this? How? Thanks a lot, Regards!!
Offline Use
Can you create form using creator and use it offline? IE: A sales order form that you can fill it while on a customer site?
User Access
How can I have a tab, available for only me to view (administrator) that lists my users and allows them to edit/delete/add info in the view tabs???? I need to allow some people to do this and some to not have that permission
Date and schedule question
Hi, a few pointers needed,,, if I have a date field for example course date, and use add.year(3) to add three years to this date (this would be renewal date) how can I store this date and use it to schedule reminders via email to chase renewal up for renewed business......
Data Entry: Managing Duplicates
Hello, I'm hoping someone can help me with this. I am building a database with several people inputting data. I would like to include a field (I'm thinking their unique email address) where if there is a duplicate, it looks up the existing record so that the second user can edit it (to say that its their client as well). I don't want two records... but I'm stuck trying to figure out the best solution.
Problem: "Duplicate" function in list view does not work
I cannot get the Duplicate function to work in one of my views. I select the record and click Duplicate, and it says "Record Duplicated Successfully" --- but it isn't. No duplicate record is created. This is the link to the view, it is shared w/ support: https://creator.zoho.com/w21admin/w21data/#Page:Events Please help. Thank you. --- Greg aka datazen1 aka w21admin Santa Fe, New Mexico
How To Retrieve Specific XML Data
I want to be able to retrieve specific xml data from a specific website and then update the values of other fields on my form with that data. I have been messing around with the executexpath and get url commands, but I cant seem to grab the data. So basically, I have a form, and when a user types in his ID number, an xml file is called, to retrieve other data. For example: ID: Name: Age: When a user types his ID in, I want to poll a live xml doc on the web, (http://www.domain.com/(ID).xml,
Free account - Public Request
Hello Please can you advise how to check if Public request for a free account is enabled? Will it be via email? One more question, will change the trial version to free automatically? Thank you in advance.
Сonsequence of deleting a related row
Hi, In Form2 I have a field from Form1 (become by selecting through Lookup). Now I delete a row in Form1 and the field goes out also from Form2. How can I disable deleting row which has relation to other Form (table) ? Thanks, Alexander
Embedded form expands if criteria is met showing more fields?
Hey guys, I am trying to embed a lead form into my website with creator but I don't want to scare the client with tons of questions (fields) that are relevant only if a certain service is requested. So I would like to show 10 fields or so, but if one of those fields is marked "Yes" the client, a few other fields appear for him to input additional information. So the form would start off small, but then grow as the lead puts more information in? Is this possible? Thanks!
Static form, users change same data
I am trying to create a form where the data that is input stays for all users. For instance if user A checks a box, when user B opens the form the box is then checked. We would also need that info tracked, so if a user changes that box it would also track that information. I am a newbie here and I'm sure I could do it with code but I wasn't sure if I'm missing some easier way to do it than coding it. I looked around on the forums and couldn't find anything or even think of what to call it to search
Migration error message - How
I'm trying to use the Migration tool to populate a table with XLS spreadsheet data. I've got a Windows 7 64-bit computer, so I get this error: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine." On researching, I see that Jet won't operate in 64-bit. I read that, "The solution is to configure the application pool and enable 32-bit application support." Is this a setting somewhere on my computer or is the application pool on the server? Please help....
Set last entry date as default date
How do I set the last entry date to be the default value of the date? E.g. If I key in the first entry, the date is 1st May, then for the second entry, I want to default value of the date to be 1st May too.
Sharing new views automatically
Hi Zoho, I have an application and regularly have the need to add new views. I find that every time I add new views, I have to re-share the application to all of the users so that they can see them. Is there any way this can happen automatically? Thanks, Kim
Is there any way to add more than one filter to a table?
I have a large table of organizations, and I need to make it easy for others to browse it as a database--they need to be able to narrow it down into various groups and subgroups. The problem is that you can only filter for one category at a time. For example, let's say I have three columns in my table: (1) "Organization Name," (2) "Type" (e.g., non-profit, government agency, or school), (3) "State(s) of Operation" (e.g., Texas, Massachusetts, etc). If I want to see a list of all non-profits on
Excel 's Data Problem
Dear all , i managed to export to excel my data , but all fields are considered as "General" , is there any way to have it with the same format? eg.. sale "Number" , when exporting it shows "General" in excel. thank you :)
Sorry, but brain is dead need help with alerts
I hope i placed in the correct sub forum. Its been a little while since i had to update my form and having some issues. I have it set up for a 'coordinates' field, with the format as ###|### (#=number). I have an alert to pop up if they input the coordinates wrong. I am also trying to have an alert pop up if the new coordinates are already entered. I do have it checking for dup's and will give an error like: 'invalid entry for key2' ... What i would like is for it to compare to DB and if already
[t_741848000000027025_PIDX] Exception occured while inserting rows Failed to update data
I have a form with a list view. When the data is entered via the list view edit form, I get the Exception error above whenever the dropdown fields need to be edited. Please help
Why won't this script lookup wildcard matches?
I'm looking up two fields here, Case_Name and Adverse_Party to see if there is any wildcard match in the database. Adverse_Party works fine in this script but Case_Name only shows a match on the current entry and never matches any historic data even though I know there should be matches. What's going wrong? cnt=count(Case_Management_Form[(Case_Name.contains(input.Case_Name) || (Adverse_Party.contains(input.Adverse_Party) && Case_Code != input.Case_Code))]); if((cnt > 0)) { records = Case_Management_Form[Case_Name.contains(input.Case_Name)];
Invalid XML - while exporting data as RSS
Hello, I am using zoho creator to gather data and used it in my iPhone application by exporting it as RSS (xml feed). In last few days I have updated some of the data and try to use it as xml feed. But now I am facing an issue with exported XML while parsing it. It gives me an error like invalid XML. I am using W3C validator to check XML. I have attached XML feed data with this post for ref.
How to allow user to see all records in one table that match criteria in another table?
I have 2 tables: customer and appointment. I can search the customer view to find the customer record I want. I have a Lookup in Appointment to Customer, so that when you create a new appointment, you choose the customer. But, how do I then click on something to see *all* past appointment records for this customer? I can imagine a button in each row of the Customer table where I could click "See Appointments" and it would bring up the Appointments page, but of course, only showing the records
Error defining picklist
Hi, I'm getting an error trying to define a picklist...code is below: must have Office ( type = text width = 200px on user input { if (count(Order_form[Office_Name == input.Office && Received_Impressions && Sent_to_HK == false]) == 0) { clear Order_List; } else { for each y in Order_form [((Office_Name == input.Office && Received_Impressions) && Sent_to_HK ==
email adresses
Hi, I have a form and I want it to be completed by my players in an online RPG so they can submit their orders online. I have an email account where the submitted form should go to but I would also like the following if possible. 1. For them to be able to preview the orders before sending, ie confirmation of what they have put in. 2. For them to get a copy as confirmation it has been sent. Is this all possible? regards
Reply To : Address Problem
When i insert a reply to email address in my sendmail on success script, the reply to address that actually gets used is different... instead of "@gmail.com the mail contains "@xn--gmil-mg0l.com" Anyone know how to fix this???
Next Page