Can new scripts be applied to existing records?
Hi It seems that when i add a new script to a form, it works only for new records. Is there a way to get it to apply to existing records...? Thanks.
Course Outline?
I'm planning on teaching a class on Zoho Creator at the local Community College. Has anyone already done this? If so are you willing to share your course outline?If I'm the first then I'll post my outline when I'm done. This will be a one night 3 hour class. If there is enough interest then I'll do a 3 night class next semester. Herb Wexler MBA www.PreventingMediocrity.com Norwalk, CT 06854
Counting the number of times a word is displayed and then inputting this number into a new field
I am trying to get my application to count the total occurences in a view and then get the result into a field in another form. For example, one form has a field that will be used to display the total number of times that the word "Human Resources" is input into a field in a separate form or view. I need to calculate the totals so I can then create a chart with the total number of occurrances. Any sample code ideas would be appreciated. Thanks!
IMPORTANT Usage limit add row IMPORTANT URGENT HELP !!
Hello, We need once a month to import lots of data in invoices (2500). Can you increase this limit? thank you
Not Allowed so Go Home
OK, here's a really simple three-part request... Sometimes when visiting a Creator App, you may get this message: "You are not authorised to access this application in Zoho Creator. Go to Home." My suggestions: In the US, authorised is misspelled. Maybe change it to allow or allowed. Change the link for Home to the admin's account home, not the application's home. Make the message more friendly: "We are sorry, but your current credentials do not allow access to this application. For more information,
Scripting - Free flow and Script Builder code different
I have a problem with code disappearing from my application when viewed though script builder. I have code that appears in an "insert into <formname>" construct when viewed in free-flow but not when viewed in script builder. Is this a known problem? If so how do i fix it?
Composite Keys
Hi, I have a simple data structure to implement. I have 3 entities; Lecturer, Module and Allocation. A lecturer can have more than one module and a module can have more than one lecturer. This creates a many-to-many realtionship which I've resolved by creating an additional entity called Allocation. Lecturer has a unique key called Staff ID, Module has a unique key called Module Code and Allocation has a unique key which is a combination of both of the others i.e. StaffID and ModuleCode. I've creating
download question
Hello. I'm new here so be nice! What format file do I save an existing file in so I can add it to my template library?
Calendar views
Hi, Here's what I'm looking to do, on a calendar view, I would like to have all information showing. Right now, i'm using it as a print calendar, and it shows the printer then the edit, delete button. I would like it to show printer and quantity, on each date cell. Here's my calendar: http://creator.zoho.com/jasonmcguire/view/1/ Can this be done? Thanks, Jason
How to create mass email and paper-based emailing out of info stores in a Creator database
Hi everyone, I'm investigating using Creator as an online database to be used by half a dozen colleagues to store contacts and record correspondence with potential/current customers (e.g. outcome of a phone call or an email about latest training course). One basic feature that we'd be wanting to have is the ability for queries to be run on the database so that we can do mail merge emails/paper based letters. I have emailed the Zoho support team, and they have suggested I use HTML views and write
Query on exporting filtered data in to WORD
How can we export selected data only from a filtered list into a WORD document?
invalid entries found
I keep having the "invalid entries found" error in all my apps. These were apps that were working previously (how far back I'm not sure), but I tried to see if it was an error in my coding, and could not find anything. Next, I tried to create a simple application with one single field, and I still had the same error. Is this a known issue, or is it just something exclusive to me? I do not have "Required field" or "No duplicate entries" checked.
java.lang.String Error
I am getting "java.lang.String" error when I try to update a record in the edit mode. Please help. The Application Name is Job Ticket System and the View is "Challan View - New". The application is already shared with support. Thanks, Vasu
/n Line Feed
Before I was using /n in multi line input fields to create templates. It seems that this has been removed and all of my text is jumbled together. Do you now have a function for inserting a line feed? richardson.christopher
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
Next Page