Error when Executing Test for function
I am creating a function, but when I execute it, this is what I get: The function does not seem to be working because it should send an email but is not. But there is no description below the blue header like one usually sees to tell what the error is. Instead, nothing happens. I've shared my Summer Camp Online Registration & Management with support. This is the CampReminderForMonday function. I'm using Firefox 4.0.1 on Windows 7. Thanks for looking into this. Mike
Can i have an "EDIT" button in HTML view to edit the records shown as in the VIEW
I am designing an application using "Role Based Access Control" and due to the limitation of the VIEWS of not supporting deluge script in the view i have moved to the HTML VIEW. So i want to know that can i insert a button to edit the records displayed in the HTML VIEW and the corresponding changes to be seen in the VIEW too. Looking forward for your reply asap. Regards, Pratik
Check for duplicate but accept if empty
I hope someone can help me-- I have a form field that is for a UPC code, but it is NOT a required field (if it is unknown then left blank). However, when the same UPC is entered (duplicate entry) I want it to check to see if the Value $ is the same, and if it is warn the user and say that it already exists in the database. But if the Value is different, then the UPC can be a duplicate entry. This is necessary because sometimes our data uses the same UPC code but the $ value will be different so they
Automatic filling of a field
Hi, Could someone please help us with the following issue: We have two forms, one form called "atleta" and other form called "treinos". In the atleta form we used to record the data from our athlets (we are a indoor rowing club in Salvador, Bahia, Brazil). In the "treinos" form we recorded the workouts from our athletes. In the "atleta" form we have a field called "peso" to register the weight of the athlete. We need to use the weight of the athlet in a formula to calculate the calories burned in
Scripts
Hi I have written a script that I would like to execute with a button or "more actions" from a view How can I do this? tks brian
Application suddenly giving mysterious error message and crashing though none before today
For an unknown reason an important HTML View for my client's organization is now crashing with the error message shown below. I am unable to determine the cause of the crash. The error message is useless. Please investigate the cause of this crash and help me get it operational ASAP. The link is: https://creator.zoho.com/w21admin/w21data/#View:Scheduling_Day_View Thank you. --- Greg aka datazen1 aka w21admin Santa Fe, New Mexico
Can I make the database secure?
creator.zoho.com/findachristianband/findachristianband I am trying to create a data base for bands. Just their contact info. I want it assessable for anyone to view, but I don't want it to allow just anyone to post. I'm afraid of malicious post. Is there a way to make it so I have to approve of a post before it shows up. Or to make it so they email me their info, and only I can post? I was editing the database in Mozilla, then testing it in Chrome. In "set permissions" Set Permissions, I left
Retrieve all the fields from one view
let's say I have a view A with fields 1,2 and 3, and field 3 is a lookup field for a view B with field 4,5,6,7,8 and 9. So, image you are going to add a new record for view A. And in field 3, which is a lookup field, you will select one of the record for view B right? I will show all the field of the select item (from view B), so the user can be sure that he is choosing the correct field. I am getting all the info from the select item and showing it in a note field into the form. But I am showing
Contact form on a Jottit page does not show up
Hello, I used to have a contact form on this page: http://luli.jottit.com/booking_%26_en... It is done and managed through Zoho Creator. The code is still inserted in the page, but the form does not show up anymore. Is there a fix?
How to customize success message. (How long it stays, adding links to your success message, etc.)
Customize Zoho Success Message ____________ Mark Hendley http://w3.synesisintl.com
Two-way relationships
Is it possible to create two-way relationships? Here is what I mean: At present I have several products and several customers, each associated with a form and each with lots of fields. Each customer buys a portfolio of products on a regular basis, so I use the multi-relationship to assign the products to the customers under the customer form. First Question: In the customer view, it lists the products with comma in between. Is there a way to have a line break in between instead? This will make
Is it possible to re-load form fields within the same form?
Hi I am wondering if a new button could be added next to submit and reset. This button could be label "Add New" which could reload the fields already in the form n number of times by hitting "Add New". See the attached picture, any ideas will be welcome! Thanks Ray
how can i display the radio button horizontally not vertically
hi can you help me, how can i display the radio button horizontally not vertically like this shape
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
Next Page