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
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
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 ]
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
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.
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
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
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
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.
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
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?
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
Newbie Question about "print html view"
Greetings.. In my apps. I used EMBED section -->"form/view" for the "html view"and also enabling the print option as well disabling certain option. After I click the "PRINT link" the image is as below My question is, how do I disable/take out the "Edit" and "Delete" option ? I'm sure that I did disable the "EDIT" and "DELETE" option but the link is still visible in live mode and print mode. I dont want my printing contain those link. really need help pls =).
There is no such component in Zoho Creator - why am I getting this error?
When I share this as a link through email, whe people open the link the above error is displayed. If they press ok a number of times it them allows them to open the form but how can I get rid of it. Many thanks, Lorraine
How to loop through multiple values of same URL parameter name? (ex. ?id=x&id=y&id=z)
Hi, I have an HTML view that has two URL parameters, client and orderid. However, while there is only one value for the client, there may be multiple values for the orderid parameter. For example, my URL looks like this: http://..............?client=PW&orderid=PW233&orderid=PW234&orderid=PW239 My question is, how can I loop through each of those values? I think I have to put them into a list, but when I try something like orders = input.orderid.toList(), only the first value is added. Thanks.
How long can I expect to wait for the Private to become Public?
How long can I expect to wait for the Private to become Public so I can embedd the form to my site? A day? A week?...
Newbie - Pie Chart
Hi, I'm a newbie to scripting... I've created an app that has a list of clients, and I'd like to create a pie chart view to display the total client distribution in percentage. Any pointers/tips that can help me along is much appreciated. Thanks.
Edit this application problem - only one column of fields is now visible!
Just recently, when I click on "Edit this application" it only shows one column of fields available for edit. This is only about 30% of the fields present in our database. I need to edit these "missing fields." Maybe I'm viewing it incorrectly? Any solutions? Thanks, Ken
Creator - extremely slow now
Is anyone else experiencing speed problems with Creator? It is running extremely slow for me, so I can't use it for adding/viewing data and development. I must wait for up to 20-30 seconds to connect to an application. Regards, George
Print out forms?
I would like to both print out and send as a file several forms I have created to let others make suggestions but find no way to do so. If I try to highlight and copy, when pasted into Word all the formatting is gone and everything is run together. Any suggestions? - tks - jb
Making a Form public? Security concern - more detail needed
I have created a form that I need to embed in my website to collect contact information and sales opportunities. Of course, I do not want the potential customers to have to enter a username/password, so I believe that, in Zoho language, I need to make this form "Public". My question is, what are the security implications of doing this? Does this mean that a potential visitor to my site could find the link to the form on Zoho Creator and see the Form and the the Form View (where all the data
I frame and zoho login blocked by Internet Explorer
I frame and zoho login blocked by Internet Explorer is there a workaround for this please? if there is a workaround we can go to the paid version =)! thanks!!
custom action to change a sort order
so i have made my zoho creator app to manage my service calls and i have a view to see jobs scheduled on the present day. Each job has a field called routing priority which is populated by a pull down menu that has a choice of one to ten and the view sorts them accordingly. So im looking to make custom action buttons to move the priority up and down. Has anyone ever dones something like this? Basiclly the up button would move that job from 5 to 4 and job 4 would become 5.
How do I generate a picklist for a field so that the list contains information from different fields?
I have a small application that has a handful of forms (ie., person, person address, person phone). I created the tables in Microsoft Access and imported the tables into Zoho Creator using the migration tool. The person form contains the fields: person_id, last_name, first_name, and middle_init. The person_id field has logic so that the field is auto-generated. On the person_address and person_phone forms they contain a field called person_id. The person_id on the address and phone forms are foreign
Can i output the data entered in a form as a pdf document?
Hi, I was wondering if it is possible to create a PDF using the data a user inputs. This is how i want it to work: 1. User enters his friend's name and e-mail id in a form. 2. The form creates a PDF and sends it to the friend's e-mail id. The PDF has a design template, and the script only needs to insert the name and mail to the friend. Help! Thanks Srikanth Nishtala
How to get Lookup list options to take values of multiple fields?
How can I make the names of the options of a Lookup checkbox list take the concatenated values of more than the usual one field of the looked-up form? E.g. options [ ] fred jones [ ] mary smith looked up from form Names, fields First and Second. Thanks.
Failure on calling a function with a function as parameter
On Save Script this works fine: a = thisapp.myfunc(6,6); but this fails: a = thisapp.myfunc(input.Check_in.getDay(),6); with "myfunc is not a valid function". Is this a bug in ZC?
Cannot update lookup field!
suddenly I have lost the ability to edit the value in a lookup field (Product_ID) in a particular form (Account_Products) https://creator.zoho.com/hayley.rees/admin/Account_Products/record-edit/Account_Products_Validation/483991000005298057/ I can still bulk edit it, but if I attempt to change it directly and click update, the change doesn't take effect! Why? there is nothing in the on update or any other part of the deluge script to prevent this change and even if there was, it would error... instead,
Help with creating a inventory
Hello! We have encountered problems with creating an inventory. The problem is notdesigning the actual inventory in Zoho Creator. The problem is that we do not know howto subtract the data from storage when a product is produced. So the stock balance is always updated after we made a product. Does anybody know how to solve this problem, or if anyone has ideas on this pleaserespond. Sincerely
Can not access My App permalink in IE8
Hi guys, We have tested in two different countries using direct permalink of our app and the browser just blinks trying to refresh in an infinite loop! It also does when I sign in and try from the Creator home. Please help !
using html in Set Email Notification creates blank email
When trying to create a new email notification, normally i just copy an old one and paste it into the new email notification. today i can't even open an old email notification to copy it, and i've tried from three different browsers. also today, as an alternative i copied an old html formatted email from my inbox and customized it. when i saved it, all the information disappeared and the email is blank the next time i open it. if i create an email notification with unformatted text, it seems to work
Cannot add a new section
When I click the "Add a new section" button, it lets me name a new section but after clicking the "Add" button, the new section never appears. Tried on multiple browsers: IE8, Firefox 3.6, Google Chrome 5.0.375.125
Formula fields not shown on form and cant be deleted in script
I have added some formula fields but only the two first show up in the form. (Formula_1 and Formula_2) When i try to delete the rest of the formulas which does not show up in the form, by deleting them in the script i get the following error. Error modifying the page Unable to delete field 'Formula_11' of form 'Account' This form contains data. It is not possible to delete such forms and fields by just deleting the part of code You need to delete such components using the delete keyword. Syntax
unique field property not maintained
I'm trying to add a unique property to a field but when i do it is not maintained after i access the application and return to the edit the application mode. When i try to add the unique identifyer in the script must have unique Account_Name ( displayname = "Account Name" type = text width = 200px ) i get the following error: Error modifying the page Maximum size of a column cannot be reduced, when the table is not empty --
2 lookup fields messing in a view
Hi I've go a "User" database with Name, Last Name, .... + a field "Position"={Underwriter OR Assistant} I've got a "Submission" database where I assign an UnderWriter and an Assistant (I'm using criteria in the lookup field to get only underwriter in the first one and Assistant in the second.) It work great but when I'm in the "submission view, the assistant field mess with my underwitter field: when I search in the assistant field, it search in the Underwriter field when I add a criteria to the
Fields with the same Label Name
I'm having a little problem parsing e-mail data in zoho creator. I receive leads by e-mail in a standard format and am trying to get them through creator into CRM. The format of the e-mail received as well as the form I have created looks something like Name: Phone: E-mail: ---- Pickup --- Address: Postal Code City --- Drop-off --- Address: City: Postal Code. Although the label names are the same, the field names are different: address_p, city,_p, postal code_p, address_u..etc. When an e-mail comes
Dynamic Cell Reference
I have an Excel application that I'm trying to emulate in Creator. A simplification of use-case is described below: The Excel application iterates down a column and examines the values of each cell. Depending on the value, it adds to adjacent cells in the columns before and after the current column. Take note of the yellow cell and the code below. Since the cell's value is 5, it adds the two adjacent cells highlighted in green. Since Creator does not have cell references, I do not see a simple way
How do I disable users from seeing the Database View?
Hi, I'm trying to build an alumni database for my student organization. I would like users to be able to submit, revise, and deleter their own entries but not see the whole database (in order to keep the privacy of others who enter their data). I only want the developers to be able to see the whole database. Please advise! Thank you, Marissa
Drag and Drop
I am new to Creator and started a new application from scratch. On my form I am using drag and drop but nothing is happening. The red dotted line appears with the word undefined in it when I drag. Why doesn't a box appear to give it a label name?
Next Page