want a report of counts of multiselect selections
Hi, I'd like to be able to do the following. 1. Create a DB with a form with a Multi Select box with (say) three items, call them Apples, Grapes, and Bananas. 2. Add a bunch of entries with various combinations of the items selected. 3. Create a view that gives the following report: Apples: 43 Grapes: 7 Bananas: 14 That is, I want a summary of the marginal counts of the selected items. The Group By feature in views is cool, but doesn't seem to do this. Is there a way to do this in the current version
Problem with editing the criteria of a view
Hi, I cant edit/delete the criteria of the view: staff profile. The error message is: Exception occurred while publishing message to the topic:: [Data ModelTopic]
Is there a way to NOT do a form submit when the user hits a carriage return in a single line field?
I'm using a bar code scanner to enter data in a form. The scanner always appends a carriage return to the end of the input. On multi-line input fields, that works great, but on single-line input fields, the carriage return causes the entire form to be submitted. I'd like to either have the carriage return ignored, or have it move to the next field in the form. Any way?
Embed Form
Cannot find where the Embed option for forms is located. I want to put a request form within my website.
Collect data in forms & Print the form in prescribed formats
Dear Team, Zoho has a facility to Print while Submit. Going beyond, I would like to Print the Details collected in Templates by feeding the details as received from forms at appropriate places. If Form has, Name: Address: Phone fields, then my template will have, I, ____________ residing at ___________ having a phone__________________ wanted to do this thing. Once I click submit, the information should come to me and the persons who have submitted should be able to get the PRINT in the template
Why so many brackets / parentheses?
I am just curious as to why the system adds superfluous brackets to code? For example, this: if (A && B && C && D) { //statements }is automatically converted by the system into this: if ((((A) && (B)) && (C)) && (D)) { //statements } The former is much easier to read and follow than the latter. Anton
I can not display grid for Users use in Views
Hello All, I have changed a view to be set to "Grid". However, the user does not see the grids, but rather the list. Any ideas? Thanks, Bartley
How do I ..Select a name from the filter located in a list view, then press add record, etcc... theProject @ 99.9% ..
I have an app, that allows users to enter their email and then are forwarded to a list view that only shows their info, based on email.. Then when they press add, it opens my input record screen. But then when entering a record, it then makes the user reselect from a drop down of name. So I want to see if this is possible once a user has entered email in my stateless form, and gotten to the list view (showing only their records) When they press add, my record submission form pops up..which is what
We are unable to fetch this data, SAFE PROBLEM
Hi, today ZOHO with any browser return this problem (and are not allowing using the system) We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com THanks Mic
Duplicate Entry Restriction on hidden field
Hi, I have a drop down called "Client Type" on my form. One of the values in the "Client Type" drop down is "Realtor - Team" and the other is "Retail". If I select "Realtor - Team", I am showing a field called "Team Name". This field has the "No Duplicate Entries" check box selected. Here is the problem, if I select "Retail", this field is not even shown. However, when I try to submit the form, I am getting "Duplicate Entry For Key 3". This validation should not even be checked for "Retail".
Concatenate, and Formula questions ( Project at 98.8% done) ♠♠ ♠♠
So I have a some fields I would like to combine ... Hour, Minute, and AM_PM .. and Concatenate this into the Time field The form you see , lets users select, hours from a drop down, minute (in 15 min increments) from a drop down and I have script to a form.. that figures if they mean AM or PM. its only from 9am to 8pm.. so its easy to.. So I would like to have the Time field shown in image... to combine whatever they place in hour, minute, and AM/PM So that the time field will say [ 10:00 AM ]
Can I add search to Summary View?
if I can add a Search bar to Summary field this is a home run!
Please List Supported Browser Versions
ZC team, Please give us an update on what browser versions are currently supported. Thank You, John M. Whitney
Formula field does not reflect the current data
In one form I have a formula field in MyForm: "<a class= 'zc-formbutton' href=\"#Form:NameOfTheForm?TransactionID=" + TransactionID + "&Client=" + Client_ID + "\">Add new record</a>" Works as I expect. Most of the time... I have now identified a record in the form where this formula field works, where this does not work. The formula is different. The formula grabs the right TransactionID, but the the client ID is for a different client. How could this happen? Is that because the client assignment
Creator - External Users
Good Afternoon I've started to look at Creator again after a few years. Is it possible to create an application which can accessed from external user without buying a full licence for so say an ecommerce site. Salesforce / force.com has sites which offer this function. Best Regards Ben
Appilcation is set to private any new section is default set to public cant seem to set to private
As per title, my app is set to private, i add a new section (even for the existing reports section) the following is shown 'NNNN- Internal' section is Public change (link) Anyone can access your data and the data will also be indexed by search engines like Google, Yahoo and others. I click the change link nothing happens , I would expect it to go to private Basically my app is all for internal use i need all sections private Am using FF 3 latest Thanks
Repeat is supported only if the start date is a date field (not date-time field)
I am setting up a Schedule to send out a reminder a year after a membership form has been filled in. I have a System field set up within Column Properties. When I try to set up a Yearly repeat Schedule I get this error: Repeat is supported only if the start date is a date field (not date-time field) How can I change this System date-time field to just a date field? Thanks
How to login from my domain to Google Apps mail using zoho creator ?
hello, I want to setup a login form in my website where people will enter their google apps login to access their google apps mail. How to do this with Zoho creator forms.
Sharing forms will all users within a domain (for Google Apps)?
Hello. We have a database with three tabs and a few forms. I have set it so users can access this database through our organization's Google Apps email accounts. For two of the tabs, we want anyone with an email in the domain to be able to access the tabs. Can we do this without having to specify all of the individual email addresses within the domain... by using a wildcard of some sort? For the third tab we only wish to share it with specific email addresses. Thanks for your help! Great product!
Activate Zoho Creator for your Google Apps Domain
I'm following the instructions here but do not see ZOHO Creator listed in the Google marketplace https://help.creator.zoho.com/Zoho-Creator-for-Google-Apps.html John M. Whitney
Google Apps Marketplace indicates Free with 3 users. Is this not true
The application says that it will expire on June 25. Before installing, the in Google Apps Marketplace it indicated that it's free for 3 users. Is this not true?
Google IDP Authorization and Google Apps
How does the Google IDP Authorization work with Google Apps? We are using our own domain for Google Apps. Clicking on the "Sign In Using Google" link takes you to a page where you can only sign in with an "@gmail" account. I don't see any option to sign in with a Google account with a custom domain. Apologize if this is a double post - I got an error on the first one. dvalerian_ntc
HELP @ 95% DONE.. In need of instruction (search form, stateless form, to view) ☺☼☺☺☼☺ $25+ to complete (via paypal)
NOT SURE WHY THIS WAS POSTED 3 TIMES>, THEN IT VANISHED>. SO HERE IS MY REPOST .. $25 via pay pal.. to whomever can close out this project.. in need of completion Ok, so I'm very close to completion of my project. The project is a entry system for instructors. They enter their workshop dates via a entry form. A have lookup fields, and such to pull store data, and artist data to make their entry easier.. I want to know how I would make a search form, that when a artist enters their email, it will
Ambiguous Error Messages: WHEN will dev ever fix error messages?
Please tell me how I'm supposed to troubleshoot this message below that appears when running an application? If the program knows a variable has a problem, it should know which variable it is, and display it's name, the line number the problem occurred on, etc. Oh, line numbers in error messages when compiling a script, don't get me started on that subject. Sometimes I wish the Creator dev team would simply go back to basics and get a few fundamental issues with Creator correct. QUESTION: When will
Radio button break down by categories
I have a question about radio button. For instance, Group A item 1 item 2 item 3 item 4Group B item 5 item 6 item 7 item 8 Is there any way to select ONE answer from either Group A or Group B not both? OR how do we break down radio listing and insert label Group B in the middle? Thank you for your help, woodpecker04
Need Java Client Library for Zoho Creator
I am using the Java Client Library for Zoho Reporter and get the data successfully in csv format. I want to get the data in csv format from Zoho Creator. So, I want to like that for Zoho Creator, Is this possible ?
Zoho Creator Free - will these limitations hurt my wedding registration?
I created a form for people to RSVP to our wedding. It basically has users enter their name, meal type, etc. There are only expected to be 250 people invited. I can't seem to find a break down of what the free version offers compared to more advanced paid versions. I don't have a need for zoho creator outside of this form, so I don't want to pay for it as of right now. Will there be any issues that will affect my registration and limit me somehow? I dont want to send out information for people to
Date, Date-Time, but how about Time?
I do remember there was a response here to a time only field like "it's on our road-map". I want to emphasize the importance of this right now: In a form using the current Date-Time input feature, I find the implementation frustrating because: 1. It's in military time, and most western nations are more familiar to AM/PM notation 2. I don't need seconds, or at least I'd like to have to option not to display seconds 3. In some cases (browsers) the java app does not appear and manual entry is cumbersome
Time Format
Is there a way to change the time format to display in 12 hour - am, pm rather than the 24 hour format?
A dropdown field - updating after choice
Hi, Is possible to have a dropdown field with 20 choices combined with Date (20 choices for everyday) that, when people select an option and submit the form, the dropdown field automatically update and, in the same day, offer 20 options - 1, and so, until all options are selected for this day, and system return that there are no more options for this day? Anyone use a similar script? Any suggestion? Thanks in advance. Mic
Edit Record via URL is not working
According to the help page at https://help.creator.zoho.com/Editing-Records-via-Record-ID.html the following format allows editing of a record via a URL: http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> I've had this function working for months, but it seems now that I'm checking it that some of the records either don't appear fully (i.e. a blank screen) or some do work properly or inconsistently. Here is a URL that should work,
Enter email in search form, to then open views based on data related to email .. ��� HELP 95% DONE ☼☼☼☼☼☼☼
Ok, so I'm very close to completion of my project. The project is a entry system for instructors. They enter their workshop dates via a entry form. A have lookup fields, and such to pull store data, and artist data to make their entry easier.. I want to know how I would make a search form, that when a artist enters their email, it will open a view that shows only their workshops in a grid or normal view.. this way they can see what they have entered in total, and make corrections or changes as needed.
Import data function in Shared views
Hi, Is there a way to let a user use the Import Data in a shared view ? Thanks, Pascal Veilleux
Schedule automatically duplicated!
Hi, my schedule automatically duplicate and the schedule that did run is not the schedule that I can see in my list of schedule! And I can-t access at the freeflowscript! Urgent help please! Mic
Drop-down type fields are not displayed in the "select field" list in the lookup field "advanced display options" (new feature)
For example, I have a "Salutation" drop down field (Dr, Mrs, Ms, etc) and this does not appear. When I change the field type to a single line text field it then appears as an option.
Calendar view, and grid view .. any way to change "all records" from appearing first ?
My question is fairly simple. I have an application, that allows instructors to post workshops. I have made a calendar view, that allows potential students to look up via city_state , to see what available in their area.. Here is what I would like as an outcome.. When a customer opens the calendar view They don't see any workshop dates yet, until they select the city_state The filter then shows workshops in that city, and state. So far all works well .. except .. The issue I have, is when opening
Contact Management with time\date stamp
I created a form to enter customer information. I have two follow up questions based on that. 1.) Our clients call and give us special instructions for future jobs. What I want to do, is to enter notes when a client calls and have that be date/time stamped. A client eventually will have multiple notes with different date/time stamps. 2.) I am also going to create another form called inventory. All our clients can have inventory with us. I want to include a drop down that has all the clients
Compare Data
Is there a way where I can take the previous entered data and take the data i just entered and get a percentage from that?
Bug: "Access this application" tab in script editor not going to correct destination
I've noticed over the last few days that when I click on the "Access this application" tab inside the free-flow scripting view, it no longer launches the module being scripted, but instead launches the general application, which is not how it use to operate and is obviously an error. EXAMPLE: Clicking the green "Access this application" tab above in the script editor now takes me to: https://creator.zoho.com/w21admin/w21data/# (the general application startup view) instead of https://creator.zoho.com/w21admin/w21data/#Form:Add_an_Event
How to edit a use information through mail?
Hi, I have a form and I am filling the user information myself. After that I want to mail the form to the user (to the email address that I have filled myself and with the ID section hidden) and ask if he wants to edit any of the information. If the user edits any information and mails the form to me, I want the data in the database to be edited automatically according to the hidden ID mentioned in the emailed form. Is this possible at all? Many thanks, Vera
Next Page