Can I use a inputed data as lookup criteria?
I want to reduce the number of options from a lookup field A, when the user select on option from a lookup field B. Is this possible?
Not Gettting Zoho Creator API Error Codes
When I use a wrong ticket number on purpose or try to generate another type of error, I don't get an error code in my response from Zoho. Instead, I get a string containing HTML code and an error message. For example, when I use a wrong ticket I get: <html> <head> <style> body { font-size: 14px; font-family: "Verfana"; } div { margin-top:150px; vertical-align: middle; text-align: center; } </style> </head> <body> <div> An error has occured. It has been reported to Zoho Creator support. We will look
Automatically assign numbers
1. I know to assign the numbers but how to get numbers to change automatically with next new record. I keep getting the same number in field. 2. My [Next] button does not go to next form. It goes to a default page and I have to log in again. I am unfamiliar with writing deluge script. 3. On customer form I want to begin typing in Customer name (say last name) and have dropdown list show up or if name is the only one, have all information show up.
Calendar showing data from 2 tables
I am trying to build a Calendar view that shows data from 2 tables at the same time. I have to related views Users and Projects. I was trying to build a calendar that shows information from view Users, but once you click in one particular entry, it will show all the data from the user and also will show all the projects he is working with. Is something like this possible to be done? Can insert some script code into the calendar view's definition to achieve this?
Problem submitting edited forms linked to by URL
My users have reported and I have confirmed, that when a record in a certain form is accessed by a URL for editing, and the Submit button is pressed, the "Please Wait" message appears and seems to hang. The record is never updated with the edits. Sometimes the URL just leads to a blank white screen, i.e. the editing form does not appear. Other times the editing form appears, but cannot successfully submit. And then, a few times, it will all work as intended -- i.e. edits are made and submitting
Create a function to transfer data from one form to 5 others
First, I apologize if this gets posted twice. When I tried the first time, the post appeared to just disappear. I am new to Zoho Creator, and I love the flexibility of the program. Most of the tutorials have been very useful, but I do not understand the instructions for creating a new function. Here's what I'm trying to achieve: I have a web page with 5 tabs on it. Inside each tab is an iFrame containing a zoho creator form. Up above the tabs is a 6th form that has just one input field. I want
Transferring or copying a form from one user to another
What is the fatest way to transfer a form from one user to another?
Understanding email addresses
If I understand it, when one fills in a contact form, an email is sent to the person that filled in the form and one also sent to the email address that was supplied to Zoho when the account was established. Is there a way to instead send the data input into that form to a different email address instead? I.E. - What I would like to do is have 3 contact forms - 1 for each of 3 departments - and when filled in by a customer, have the contents of the form sent to a different persons email address
lookup advanced display and related fields
I have a lookup field for states. It is set to store just the abbreviation (e.g., "FL"). Using the advanced display options, it displays both the abbreviation and the full name (e.g., "FL - Florida"). I access the data through a json feed and would like a list of just the state abbreviations. Two impediments: 1. The default view of the "states" field does not display what is stored ("FL") and instead shows the advanced display ("FL - Florida") which I only wanted to show in the form itself. 2.
I need to move data from one form to another
Sorry in advance as I am new to creator and are finding my feet I am currently trying to move data ( the current record only ) from one form to another, based on a check box being checked on the form or the press of a button on the form I am transferring from. Is there a way to do this via the GUI or does it need to be done purely via scripting. I await your reply Regards Paul H
How to do lookup with criteria
I have two forms, persons, and services. On services, I'd like to be able to choose a person. However, I don't think combo box will work because over time this will have a lot of people in the list. I can't figure out how to get a popup to work - I keep getting http 500 errors whenever I select that as an option for the lookup. Thanks, Keith
lookup field link to summary view - navigation problem
Regarding this feature: "A lookup field can be shown as a link in the view. The link will take to the summary view page of the related form." These links open the summary view in a new page instead of a modal dialog like the other "view" links. This behaviour is causing a navigation problem when applied to an embedded view in an HTML view because there is no way to navigate directly back to the HTML view.
How do you perform a case-insensitive query?
I have a form with a name field. When validating the name I need to check if the name already exists in the data base. The check must be case insensitive. Is there a way to do this without using a FOR EACH loop? I tried the following, but it generates an error. It doesn't like the part of the code that is underlined below. Does anyone know the proper syntax, or how to do a case-insensitive query? //check if name already exists recCnt = count(NAME_FORM[NAME.toUpperCase() == input.NAME.toUpperCase()]);
Critical Error: [ t_734872000000029031_PIDX] Exception occured while inserting rows Failed to update data.
I have a very similar error to this thread : My app uses a series of stateless forms to update a master form (pretty large but most field lengths have been optimised for character length) and if I attempt to edit the main form it throws this error. My error reads: [ t_734872000000029031_PIDX] Exception occured while inserting rows Failed to update data. 2 examples: FORM = 'Main' I open the 'Main' view and select EDIT and manually change a look-up field. It fails and deletes the current field value
Getting Error Message, worked fine previously, have not changed anything
Hi I am getting a log error message and I have not changed anything... as far as I can tell anyway it worked fine last week...any ideas?
Email pdf of html View as Attachment
Is this still not an option? I just had a client email me fed up with the link to my html views not working. I searched the forums and found that you can now use Scheduler to attach views but the html views aren't on the drop-down list.
Critical Error
I am getting the following error: [t_378509000000032009_PIDX] Exception occured while inserting rows Failed to update data. This is happening when editing a submitted record. Can you advise a corrective solution?
Importing Data into Creator
How do you import data, like an Excel spreadsheet, into a Creator database?
Script issues
I need assistance with script. I am creating a database for stationery products. We have 5 Groups: Writing, Filing, Paper, Accessories, Private label Within the Group there are Catagories so for: Writing - you have Pens, Pencils, Markers, Art Filing - you have report covers, binders, expanding files etc Withing the Categories there are subsets so For: Pens you have Ballpoint, Ballpoint w Grips, Ballpoint Retractable, Ballpoint retractable with grips, etc Report Covers - Poly, Paper etc If one
Revoking API Keys for PUBLIC api.creator.zoho.com Apps?
In a previous thread it was made clear there is a distinction between how Private API access is handled. Simply share the app with one of your users and if they abuse their access it's simple enough to revoke access. Is there any such control if the app is made "public"? Are there any other ways to protect the access to the data? Perhaps as a Google App or something else? I'm trying to avoid paying Mashery a princely sum to manage access, keys, throttling, etc. I'm after a less API management solution
Revoking API Keys for api.creator.zoho.com?
Is it possible for ME to revoke someone's API key to my private app?
List Manipulation
Here's a puzzler: Let's say a list has a maximum number of 10 elements. If a form is loaded, and a user defines two elements (at index 0 and 1) out of the maximum 10, how can we script to add arbitrary values for the remaining 8 elements? What I was looking for was something like mylistsize=input.MY_LIST.size() ; for index = (9 - mylistsize) to 9 { MY_LIST.add("XXX"); } To add 8 more arbitrary elements to the list to bring it to 10 elements. Am I totally missing something obvious? John M. Whitney
Counting Records Meeting a Complex Criteria
Let's say we have a database like this How can I code a general function to count the number of widgets meeting any criteria (color, size, gloss, material)? Test case 1: Color = yellow and Gloss = H Test case 2: Size = L or S and Material = glass John M. Whitney
Alt. row color not working
For some reason the custom themes and the standard themes are not working. From reading other forum posts it seems like the custom themes don't work due to the https, which is fine. However, the standard themes don't show entirely either. For example, I want the View to show alternating row colors, which several other databases I've seen in Zoho Creator have. It shows this option in the Contemporary theme. However, when I apply the contemporary theme, it does not alternate row colors with bottom
Success message in a stateless form?
In Creator, how do you show a success message in a stateless form? I'd like to do this as part of the 'on click' action of a button i've added to the stateless form. Thanks, -Jeff
passing values in url to embedded form
I have a form embedded in my website. I want a contact to click a link in an email that takes them to the form and populates the form. I can get the following to work: tempContact = Contact [ID == 1234]; input.Name = tempContact.First_name + " " + tempContact.Last_name; But, how do I do it if I want to pass the contact ID in the url?
Custom action openurl for stateless form fails if date field is empty
Good evening, I have a stateless form that students use to submit registrations for classes and accommodation. On click, the data is inserted into a temporary registration form. In the view for this temporary registration form I created a custom action with an openurl for another stateless form called accept_registration_temp. This opens the student registration in order to allow admin to perform certain tasks before it is accepted (and loaded into other permanent forms before being deleted from
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
Next Page