Complete loss of access after application name change.
This problem was very serious (from my perspective) but was fixed by eliminating "quote" characters from form and field titles! Note to all Zoho creators: DON'T USE QUOTE CHARACTERS IN FIELD TITLES!! ----------------------------------------------------------------------------------------------------------------------- I had several lists under the application title: "My Movie and Shopping Lists" so I changed the title to "My Lists". After that I now have no access at all to the forms, or the views,
Self-Customized Layout
Hello; I love Creator to bits, I just started using it lastnight, I just have one, take note ONE problem: As this is a Database, I need to customize a view with personal layout preferences so that I can print a form based on Relational data. My application needs to have a "Order Form" and an "Invoice Form" with a specific layout as per the Invoices that the company uses now. How do I do this pleeeease, or is there a 3rd party tool that can access the data and records on ZOHO, then create a "Report"
date stamp records
How do I add a Date stamp to data entered from a web form? I want to have it so the date that the web form is filled out gets recorded in the database.
Quickbooks Integration
When will quickbooks integration be available for zoho creator?
Viewing Images not working
When I go to view the images uploaded with the form in my application in Zoho Creator, the view is completely messed up. Not to mention the fact that no images showed up in the first place. I need the images to display in the views. Help please
create a PDF of completed form
Hi; i'm not a developer but i have been able to create an application that suits my needs, just have one last problem. i have created a stateless form that auto-populates data from another record within the application, but is there a way to print the form once the user has completed it? ...or even better yet, to create a pdf of the form, say by clicking one of the form buttons at bottom of form? alternatively i could redesign the form so that it is not stateless if that makes it easier. mike
Url Submit Form Questions
I want all links to show up in a new page. How do I set that to be an option that is automatically checked and cannot be changed? Also, can I propagate the "Link Name" field automatically and make that unchangeable as well? I would like it to say Visit Our Website by default.
current date and time
Hi. I am pretty new to this. I am exploring as much as i can and I am very bad in programming. I am trying to create a form whereby the first line on the form needs to indicate the current date or time as long a user wants to enter a field. But I am not sure to go about doin' that? any experts here could lend me a hand?
There is no good way to print from Zoho Creator
Is there a way to print from the "View as Summary" view? This is the ideal layout for printing. I would like a way to print data that is aesthetically pleasing and also contains the information from all 17 of my column -- one ONE page. If I choose the Print option, I am only able to print a portion of my data, and the rest is cut off. There is a HUGE need for this in my organization as we use the database in relation to clients and would like to provide them with a print-out of the data we queried.
Why can't we print View Summary from Zoho Creator?!
Is there a way to print from the "View as Summary" view? This is the ideal layout for printing. I would like a way to print data that is aesthetically pleasing and also contains the information from all 17 of my column -- one ONE page. If I choose the Print option, I am only able to print a portion of my data, and the rest is cut off. There is a HUGE need for this in my organization as we use the database in relation to clients and would like to provide them with a print-out of the data we queried.
Custom Size MultiLine (textarea)
Is there any way to specify a size for a multiline text box? I want some to only have 2 lines worth of text space used in the form, and I would like others to be a very large area for writing a whole email in the form. Any help is greatly appreciated!
Vendor "fixes" e-mail and breaks the Zoho Email Data into form functionality - Can anyone help?
All, We have a process that has worked like a charm for nearly 2 years. From a vendors site an e-mail is generated with dynamic info that is e-mailed into our Zoho Database. The vendor has modified their code and placed a "<BR>" at the end of each line. The vendor is currently not motivated to change their code back. Is there any way from a Zoho perspective that I can work around this? Zoho will import properly up to the first <BR>... I have tried stringing the source onto one line to avoid the
Count laboral days
Hi, I want to know how can I count laboral days between two data. Any Idea? Sergio Galiano
How to let my users use my forms/views as templates and save in a different file name
I'm trying to find a neat way to all a group of users to create, manage, duplicate and share multiple 'spreadsheet' style documents based upon a pre-defined template that I create, so that the data is always in a standard form. Creator seems to get partly there but I can't find a way for users to use my forms/views as templates or for them to be able to save the data under a different file name. A simple example of what I'm talking about is quotations - multiple rows of information in a standard
Labels for Subtotals & Grand Totals in View...
I've enabled the sum function for a numeric field, and I get subtotals and grand totals for that field in the view. The downside is that my users might not readily know what these fields are. Can I add a label in the view to define them? I've attached a screenshot for reference.
How to Customize Form
How do I go about customizing the Zoho form to fit in with my website? All I am seeing is the iFrame and the PermaLink. I have tried viewing the source for the PermaLink, but the form does not process right. Help!!
Dynamical Line-Item Form
Dear all, I would like to create a typical form-document in ZOHO Creator. With a Header, table and footer. For example a Sales Order Document: User can enter the Customer information, Dates, ... on the Document header. Then user wants to select the Products in the Table area. The table area should add more and more lines dynamically, as more lines the user would enter. For example the first line will be displayed per default with columns like Product Code, Product Name, Quantity, Price, Tax, Discount,
Filters for Dynamic Picklists
I've created a dynamic picklist using script. When I attempted to filter a view by that field, I noticed that there were no options (since the picklist is populated from another form). I thought then I might have to use a lookup field (because I tested it and noticed that the field values were available in the filter) but then noticed from the help topcics : Note: You cannot set the criteria expression based on field values in the current form. The lookup field could not meet my requirements because
Implementation details of iCal Feed
This is how the iCal Feed will be available in Zoho Creator. - Views(List,Summary or Grid) which has a Date-Time field in its list of columns selected, will have an additional option "iCal Feed" under More Action. - Once the user clicks the option, a pop-up window similar to Embedding Options will be opened - In the popped up screen, User will first enable the iCal feed. - Once enabled, user will get a default feed url - Options for matching the view columns with the iCal property names will also
Using "if" statement if nothing is selected in multi select box
I would like to send an email only if at least one item is selected in a multi select box. However, I am not sure how to do this. I've tried (see highlighted text): if ((((input.SenttoEncode != "") && (input.STPandDolby == "No")) && (input.Force_Eval_Email == "No")) && (input.Videographer != null)) and if ((((input.SenttoEncode != "") && (input.STPandDolby == "No")) && (input.Force_Eval_Email == "No")) && (input.Videographer != "")) but neither of these work. What is the
Subject of your feedback
Hi - Is there any way to script something to delete old records (say, records prior to 1 year from today). Thanks Alfio
Scheduler Workaround: SOLVED
I know the ZC team is working on the Scheduler (to be released in June I guess). However, I have been toying with a workaround using free serveries that send scheduled emails. The idea being to kick-off some code when the email is received. My question is, how to I get this to work with a private application? I get this result: "You are not authorized to add record"
Hitting 2 birds with one stone
Hello friends, Is it possible to fill in 2 fields at once using lookup in Creator? My database has 2 forms: sales report and tax rates. From the tax rates forms I have 2 fields: COUNTY and TAX RATE. Both these fields are also in the sales report form. Instead of using the lookup object for both, can I not just select the COUNTY and have the corresponding TAX RATE automatically filled in? Or do I need to write a script? Thanks!
Sequential Dropdowns
Hi I am trying to alter the options available in a dropdown field based on the values entered in 2 preceding dropdowns. So, for example dropdown 1 allows the choices "core", "higher" and "advanced", dropdown 2 has a choice from 10 values (e.g. general, acutely ill, cardiothoracic) and then dropdown 3's list depends on the combination of values from dropdowns 1 and 2. That means Core-->General-->dropdown 3 choices will be different from Higher-->General-->dropdown 3 choices. Can you give me any guidance
ZOHO Reports: Cost vs Value
This follows from the Cycle 3: The Path Forward discussion which got off track: http://help.zoho.com/portal/en/community/topic/cycle-3-the-path-forward Please use this post to continue the discussion on the value, strategy, and cost of ZOHO Reports for Creator... To start off, I think the Number of Reports = The Number of Applications/plan
Change Email
Hi, How can I change Zoho.UserID (Email), in order to send emails using other email (not the one in my account?) If necessary, how can I change my account email? Thanks Nuno nunoalexandre
Cycle 3: The Path Forward
Since Cycle 2 has been completed and Gave has stepped down, the community needs to consider a path forward for Cycle 3. I'm fine being the new coordinator, unless somebody else feels strongly about this. In this role, I will again offer a ZOHO app for you to submit ideas, followed by an evaluation phase with Charles et. al, and finally a voting phase. Let's discuss the path forward for at least the next several days before we start the ideation session.... Thanks,John (NiskyPTO)
Can custom actions be added to Summary View?
I created a custom action and added it to my app's Summary View - but the action does not display on any of the records. Is there a limitiation that Summary views cannot use custom actions? or is there something I need to setup to allow it?
Reset radio button on edit record?
Is it possible to reset a radio button to a certain value when I edit a record? I have a radio button with the simple options of "Yes" or "No". How can I make it so that when I click "Yes" and then submit that the next time I edit that record the radio button goes back to "No" automatically? Thanks in advance for any help
How do I assign an image to image upload field?
I have an image upload field in my form. The image upload is optional - but I want to provide a default image for those cases when the user does not upload an image. Sorta like a "no picture available" type graphic which gets stored with the record. How can I get the form to pick up my "no pic avail" image into the image upload field? And where would I store the image so that the script can access the image?
Can Summary view have custom actions?
I created a custom action that I use in my List View. I've added it to my Summary View but it does not appear. Is there a limitation? or am I missing something? I have customizations on the summary view- does that matter?
For each record criteria & formula fields
I have two forms (A & B). Form A has the following fields: Lot Description formula field combining the two fields Lot_Desc. Decision box Form B has a lookup to form A using the Lot_Desc field. In a script on Form A I am using a For Each Record in Form B with criteria to match on Lot_Desc. No records match. However if I change the lookup to use just the Lot field the criteria works correctly. Are formula fields not allowed in the criteria? for each x in Batch [Lot == input.Lot] works for each x
How to use boolean for empty text field
I want to enable an action (sendmail) only if the two conditions are true: 1) Text field "SenttoEncode" has no text entered 2) Radio button is set to "No" How do I write the "if" statement to do something when the two conditions are met? I have tried: if ((input.SenttoEncode != null) && (input.STPandDolby == "No")) and if ((input.SenttoEncode == "") && (input.STPandDolby == "No")) Neither of these work as the next step is to send an email if the condition is true, and even though the
Creator Form fields don't match view fields
I was editing a field the other night and canceled out of it. The fields I see in the application form view are all there (I have several), but I only see a few of them in Edit Mode now. What happened? How do I get them back?
Form Fields in edit mode don't match fields in application view
I was editing a field the other night and canceled out of it. The fields I see in the application form view are all there (I have several), but I only see a few of them in Edit Mode now. What happened? How do I get them back?
Dates are a Mess!
Dates are a mess....you guys need to understand that the U.S. market uses a different format than in India. It is month day yeasr - not day year month. With the date field on a form, if you enter using slashes as mm/dd/yy the system interprets it as dd-mm-yy. So I have lots of bad data in my system. In such cases it should be interpreted as mm-dd-yy. Please fix.
Zoho creator+google maps
Using Zoho Creator ,Yahoo Pipes,and Google maps to Build cool mashups. Note:I will upddate links and Images for your Reference shortly please check for my blog mesporatitech.blogspot.com/2007/11/using-zoho-creator-yahoo-pipesand.html Intro: Integrating Data (overlaying in developer terms) onto maps (Google, yahoo) has become a fad these days, the applications range from trivial to Interesting. By opening up their Mapping platforms Google and Yahoo, have given Interesting framework on which developers
Google Calendar iCal feed setup question
I am trying to add a Zoho Creator ical URL to Google Calendar without success. In Google Calendar I go to Add/Add by URL then paste in the following ical URL and select 'Add Calendar'. I get the following error...."Failed to add imported calendar at https://creatorexport.zoho......... for user@gmail.com" I followed the ical feed steps at http://help.creator.zoho.com/iCal-Feed.html My Zoho App is private, so I selected the link that adds in the encrypted code. I've tried two versions of the URL.
Set a variable in a FORM from a VIEW
I've figured out how to do some custom actions / functions within zoho -- but now I'm trying to figure out how to have a custom action in a VIEW populate 2 fields in a FORM. This is an application that helps us manage child sponsorships in South Africa, Moldova, and Brazil. We're trying to add a little more functionality -- and have photos, ages and first names available for people to look through as they are setting up a new sponsorship. User Action would be like this: User goes to VIEW - which
script for returning values in a Multi-Select field
Dear Friends: I'm a newbie to databases and scripting, so I need a very basic helping hand. I've created a database to collect data about metrical events that occur in lines of poetry. The fields I've created, together with abbreviations I use for the individual events, are these: Lines (Single-Line) Properties (Multi-Select) Penthemimeral (Single-Line) (pc) Hepthemimeral (Single-Line) (hc) Bucolic Diaeresis (Single-Line) (bd) Homodyne in 4 (Single-Line) (hm4) Heterodyne in 4 (Single-Line) (ht4)
Next Page