Auto Populate List
Hi I cant seem to get my head around the following: I'm creating an app. One of the fields require a int value > 0. For example lets assume "4". How can I built a list to contain 1, 2, 3, 4? If the int was "5" then list must contain 1,2,3,4,5. I need this for the following reason: Int "4" means that certain field values in the form must be copied to another form on submit, 4 represents the amount of data rows, so: 1. Name, Surname, Mobile 2. Name, Surname, Mobile 3. Name, Surname, Mobile 4.
Linking to related Lookup records inside a view
What's the easiest way to provide links in a view, unique for each record, that will direct the user to the view/edit form for the related record? This feature is built into other web application developer systems. Example: A form [Companies] has a lookup field called "CEO" referencing another form [People]. In the Companies table view, the name of the CEO in the CEO column is a hyperlink. When the name is clicked, the view/edit form for that person is opened.
Display count when grouping in a view?
When I create a view and group on one of the fields, is there an easy way to display the count of the records that are included in each group? Rick Clay
Form not working
Dear Sir, My application http://creator.zoho.com/abhinandansharma84/form/5/ is not working. You are requested to please provide a solution for same on urgent basis. Waiting for your response. Also, please mark a copy to apsplacements@gmail.com. Regards, Abhinandan Sharma
Allow edit access to support?
Is this why my forum questions have gone unanswered? Was I supposed to allow edit access to support? If that is not the purpose of this option can someone explain what it is used for? I searched the creator forum for the term access support and nothing came up. I am sure I missed something somewhere, could someone point me to a forum post regarding the option or a wiki article on it or something? Thank you.
Dropdown Manipulation
Hello guys, I'm using Zoho Creator to make a simple form of registiration of an event .. I simply want to make a dropdown with all available times .. with a unique time for each registerant .. If the user wil select and element from the dropdown menu, it'll be stoted in the databse and next time it won't show in the dropdown box making way for the other items to show .. Any thoughts on how to do so ? Thanks!
Printing documents based on form inputs
Hi Consider the following scenario: I have 2 docs that I have publicly shared on Zoho Docs. The docs are available at https://writer.zoho.com/public/<username>/1 and https://writer.zoho.com/public/<username>/2 respectively. I have a form in Zoho Creator with a 'Number field' as the only input. If the user enters 1 and submits the form, the document at https://writer.zoho.com/public/<username>/1 should be printed; and similarly if the user enters 2, the other document should be printed. Please
Can't feed Ical Feed to work
I have been trying to get the Ical feed to work from a view. All of the dates I need to pass are "Date" fields rather than "Date-Time". Is this an issue. When I add the URL to my Google Calendar, I do not see any data. Following is the URL I am using from my view: http://creatorexport.zoho.com/carlgifford/vacation-rental/ical/SLR714/ORGANIZER=GuestName&DTSTART=CheckIn&DTEND=CheckOut&CREATED=created_time&SUMMARY=GuestName&ZC_SET:CLASS=Public&ZC_SET:STATUS=confirmed&ZC_FULL_DAY_EVENT_VAR=true Guest
Simple view criteria not working!
I have a view with the following criteria: Asset_Owner.contains("WestLB") Asset_Owner is a multiselect lookup field. The view displays the error message: We are unable to fetch this data, sorry! There is another field in the same form called Asset_Scout. It has the exact same settings as Asset_Owner (multiselect, lookup, alphabetical sort, criteria etc.) but references another form for the lookup. With this field as a criteria it works. A quick response would be very appreciated as I was supposed
Need help with scripting!
See dvdborrowing.blogspot.com for the form that I am having issues with. When users fill out the form and click on "submit," all that reaches my e-mail is the sentence, "I wish to borrow a DVD." How do I configure the script to get the rest of the form info to show? (e.g., their name, dvd they wish to borrow, etc). I am a novice at scripting, and need a little step-by-step help. (I read about scripting in the wiki section, but could not find examples specific to my need). See attached photo of my
Accessing Form Values/Hidden Values
I'd like to update, via javascript, form values in an embedded iFrame form but since none of the elements have IDs, only names, I haven't been able to figure out a way to update form values via javascript. My goal is to create a form that has a hidden field that I can update without the user knowing and have it be submitted with the form. Thoughts? Comments? Questions?
MS Access migration Problem
trying to upload MS Access database and consistently encountered the problem described as "Problem encountered while creating application. Error in line;25. Unable to import value from. Batch_Sheet ProductID Picklist/Check Boxes/List/Radio buttons cannot be imported." What do I need to do to fix this prblem. My MS Access database is for a Quality Control application.
Is there a limit to "send mail" in Zoho Creator?
Let's say I want to add/import 700 email records to one form in an application and create another form within the same application that would send mail to all records in the first form. Will Zoho Creator send mail to all the records regardless of the amount of records, or is there a limit to the amount of emails an application can send? If the the latter is true, what is the limit and does this depend on account level?
Not able to edit html views
Hi, Whenever I try to make any change in the html views in my application, I get the following message: "Error in statement at line number 1 The Left expression is of type STRING and the right expression is of type DECIMAL And the operator - is not valid here" Can anyone help please? -Arghya
Cannot duplicate record from View
An error occured while I tried to duplicate a record from the View display. I was able to duplicate the record last week. Has something changed in Zoho? Cheers.
Render Uploaded Image
Is not working. It's really serious guys. I have several apps in my clients that are not rendering the uploaded images. why?... I'm using the formula that is that is told in the Zoho Help document: ("<img width='100' src='http://creator.zoho.com/DownloadFile.do?filepath=/" + Image + "&sharedBy=" + zoho.adminuser) + "'/>" please tell me how to fix it? Rodny :( Blist Solutions
Chain-linking fields from several forms
Hi all, I have a simple application for a basketball club membership on Zoho Creator. I have created three forms: 1. Person (containing individuals' details, e.g. First Name, Surname, Date of Birth, Street Address, Suburb). Suburb is a lookup from the Suburb form. 2. Suburb (containing Suburb Name, Post Code and State). State is a lookup from the State form. 3. State (containing only State). I would like to display on the Person form the Suburb Name (which works) PLUS a "calculated" field which,
Display name being taken as field name
I recently tried to bring an application from one account to another. I exported the data out of the application in one account and imported it into each view in the new account. Everything seems to be fine, except the column properties in the views. The columns are taking their names from the display names rather than the actual names of the fields. For example I have one field with the name, "Basic_Rope_Technician_Completed", with a display name of "Basic Rope Technician Check-Off". All of the
How do I get tech-support for Creator --
e-mailed and dialed the tool free support line several times... No reply in 3 weeks
reset css on form for embedding
So anyone else tired of messing with the wierd padding and margin added to forms in a perma view? Add this CSS to a "note" field on your form to zero out the form.... <style type="text/css"> html{ margin:0px; padding:0px; } body{ margin:0px; padding:0px; } /*overwrite zoho*/ div#zc-component { padding: 0px; } div#zc-pane { padding: 0px; } blockquote { padding: 0px; margin: 0px; } blockquote p { padding: 0px; margin: 0px; } div[elname = "zc-component-your form name"] {
Inline Frame (iframe) Wieredness
This is inside an intranet. We have a web-page that lists file links on a shared drive. The page displays links as this: file://bdwy08/docs/atn/ansi2/default/04529700.pdf Which we opened show this in the browser: file://siibdwy/docs/atn/ansi2/default/04529700.pdf But, if I take that page and place it in an ZC HTML view as an iframe, the links all get botched like this: http://bdwy08/inet/\\bdwy\docs\atn\ansi2\default\04529700.pdf Why is ZC assuming something about my links and adding extra garbage
About ZOHO Creator's Access Control Model ...
Charles: I am starting a new post in response to your response here ... http://help.zoho.com/portal/en/community/?ftid=2266000000389255 ... as it is otherwise likely to be buried amongst other points raised by the author of that post (niskypto) Naturally, you will start to handle authorization in your application logic, which we don't want to encourage for the fact that it is liable to be hacked. You have Zoho Accounts for authentication and Zoho Creator's Sharing module for authorization. Any enhancement
How do I get the date and time and input it into a field upon success?
When user clicks submit, I want the date and time to be inputed into my field, so that data will be shown in view.
Customizing Label widths in a permalink
When I use a permalink and customize the width of labels, the text wraps correctly in Internet Explorer, but not Firefox.
Print My Form
Gosh, some people still like paper copies. I have a request for a print button be added to a form being viewed. The user wants to fill-out the form, then print it, then submit it. Under "More Actions" a print option is expected. Possibly a view PDF is also OK. Is the only work around to populate an html view after submission and then prompt for printing (or PDF)?
possible problem with file attachments
hi zoho, Problem is in form view mode. When I click on an attachment uploaded by the user, it does not download . Instead, the click takes me to this url : https://creatorexport.zoho.com/DownloadFile.do?filepath=/1256072884521_bemdts.doc&sharedBy=stressrecess&appLinkName=therapists&viewLinkName=Approval I cannot access these attachments, nor can I download them. Is there a setting I need to change or is this a problem on your end? The problem is the same in IE7 and Firefox 3.5. I was able
Creator - issue with importing linefeeds
My Excel do contains with linefeeds in them. This is used when creating multiline data cells. When importing this data in to Creator, it incorrectly interprets then as end of lines. The end of lines are actually marked with CR/LF. Anyone any suggestions as to how I can fix this?
possible bug in search box at zohocreator.wiki.zoho.com
Hi nice zoho people, clicking in the search box now seems to refresh the page if you are using firefox 3.5. It works fine with IE. seems to be a new problem since yesterday. have fun! Dax (Devorah) from Stress Recess
How do I keep names in a Single Line form in alphabetical order?
I have created a form called "Add Name" using a "Single Line" box. With this form I have also have a view which can be configured to display in alphabetical order. I have created forms which have a dropdown box with the "Field Type" set at Import Data from the Add Name form. All names where first added in alphabetical order so these are good but when I add an addtional name it goes to the bottom of the dropdown. Is there a way to keep these newly added names in order? Thanks for any help
problem with calculations and the enter key
Hi folks, I have a routine the calclates a total dynamically from user data in 5 fields. The total field recalculates whenever the user enters or changes data in the field. As long as the press the tab key, (or click to the next field), they can see the total recalc as they are working with it. but if they press enter....[scary music]. The enter key automatically presses the submit button before the user is finished. They get red errors all over the page during validation for the fields they
Zoho Creator Enterprise Design Question
Hello. I'd like to ask the user community for some ideas/assistance on a design that I'm working on for an Enterprise client (200 + users) whose functional design specification using Zoho Creator (and yes - they want to use Zoho Creator) is to: 1. Track & Report on National Data - a compilation of each State's Data. 2. Track & Report on State Data - a compilation of each City, County, and Region that utilizes the software for their own respective Entity. The National data will need to be kept in
Creating several entries with one form?
HI, I was wondering if I could create a form that would make several entries to the table? For example, if I am trying to keep a record of my spending transactions. Say I have a Walmart receipt and I want to split it up into 3 different categories with respective dollar amounts. But, I want to keep track of the this particular Walmart receipt. So hear is what I would like to see in the table: Walmart 1 - food - $10 Walmart 1 - household - $5 Walmart 1 - household
question about building combined views,
Hello, Here is my case: I have tables "Officer", "University", and "Country". Officer is one-to-many to University, and University is one-to-many Country. And, Country has a column "Region" I am creating a view of the Officer table. I would like each row to include the Region it's in. (Essentially, I want to display the 'related field' of an already 'related field'... So, when I write the form definition for the View1_Officer, I am having trouble referencing the Region column. For example (this
The irony of "info" feature on Zoho Functions
To Support : Please taken lesson from debuggers like Firebug.. The point of a debugger is to figure out WHY YOUR SCRIPT IS BREAKING! Which brings me to the "info" feature while building functions. Wouldn't it make more sense to SHOW US OUR INFO/ MESSAGE LOGS even when the function does not execute successfully? I think it's sort of odd that the only time you can see a message log is when the function works.. Which in many cases means the I'm constantly commenting out blocks of code to get to a place
Customizing alerts & warnings
Is there a way to customize "Failed to add data" or "Enter a valid email address for.." for forms. with on validate we can write our own alerts but still messages above appears. I would prefer these messages in my native language. I think you can rearrange form bulider to customize these alerts.
Why does modifying a referenced dropdown picklist value generate Creator error in Safari?
When, in Safari browser, a dropdown picklist from another form is modified remotely (as shown below), a ZC error gets thrown (see below).... but not in Firefox, Chrome, or Opera. (Don't have IE to check) The offending (to Safari) statement is highlighted here: r = People [ID == input.Picked_ID]; if (r.State != input.Verify_State) // "State" is a dropdown list { r.State = input.Verify_State; // this statement throws a ZC error when executed in Safari } ... where the record in the
Creating multiple records from a single entry...
I have a database for tracking tutoring referrals at a school. Teachers currently select a student name from a dropdown menu, which is a lookup field from another form. They also enter a written description of the assignment in a text field. I would like to be able to choose multiple students from a mult-select field and enter the description for the assignment in the text field -- and have the database create a record for each student selected in the multi-select field. Or... could it be possible
Test data / test application -- how do you do it?
Aside from copying applications to do test, how do the ZC creators structure test scenarios? Is there a way to two applications act on the same dataset? Curious about test/production setups... Ian
if condition then OpenURLl else if condition OpenUrl
erros on the Elfse if, why if(input.I_want.contains "demo" && input.I_want.contains "supportcenter" ) { openUrl("http://www.manageengine.com/supportcenter","same window"); else if(input.Sexe == "M") { openUrl("http://www.manageengine.com/supportcenter","same window"); } }
Auto populate fields (or pass data) between a form and a view via an Action Button
Greetings - I have a question on passing data between a view and a form. Currently, I have a Member view that lists all Members with their first/last name, address, etc. For each record, I have created a custom Action Button of "Add Donation". When the user selects the "Add Donation" button, a popup form displays, allowing the user to enter donation information. On this Donation form, I would like to auto-populate the Members First and Last Name, carried over from whichever record they chose
Next Page