Dealing with the paper world...
I love Creator...I'm working on my second app and provided all continues to go well I will soon be upgrading my account and signing up dozens of users. One big challenge...I am working on creating a paperless office for a business that is currently very paper intensive. There is a requirement to fax or email various forms to different external companies. The faxing part is easy - just send an email to the right destination. The challenge is how to get the completed form in an electronic format. These
filter records to list in checkbox
I have an event database application that holds all of my event data, and I have a separate Staff availability database that I am using to collect availability from my employees for the events that are located in the event database. I currently have a checklist lookup field that weeds out the events I do not want to see based on what quarter the event falls into, but it is hard coded and I would like to make the list update automatically based on which quarter is selected in a dropdown box on the
Error message in script builder
Hi I am trying to use the script builder for the first time. I have previous used the free flow scdript but this seems to give me some headace! As you can see from the attached I get an error when I try to remove the "quote" mark after input.formdata and put it in after the text". When I try to save the error apears. BR Dennis
Sort a lookup checklist by date
Is it possible to sort a lookup checklist by date? When I click the box for "Show choices in alphabetical order" it puts the dates in the wrong order because the day is listed first in this format dd - Month - yyyy. I adjusted the date format under application settings and this does not fix how the date displays in the lookup checklist. I considered using a date function to lookup the month, then the date, and combine those two together by a formula so that it would appear correctly when alphabetized,
Clear check list
Dear Support For my users in I am modifying the drop down list to only give the correct country as below. However, the country Vietnam does not add automatically and the users still have to manually select. Is there any way that I can script it so the country Vietnam is the only option? Regards Peter b = zoho.loginuser; if (b.contains("viet")) { clear Country; Country.add("Vietnam"); input.wUser = "moanazoho"; .......... etc etc moanazoho
DATE VALIDATION & CALCULATION ON A FORM
Hi, I have two enquiries... 1) How do you validate one field (Course Finish Date) based on the user input in another (Course Start Date)? I want a message to display "Course Finish Date cannot preceed Course Start Date!" 2) Based on the number of weeks entered (the difference between Course Start Date and Course Finish Date) I want a value to be calculated (in weeks). I also want to use this value to multiply it by the Course Cost Per Week to give a Total Course Cost. Simple? Thanks for your help
Mail Confirmation of two completed forms
Hi, This may be simple. I have a school booking form that is divided into Booking Details (Name, Address, E-Mail and other personal details for new students) and Course Details which gives details of the Course Type, Start and Finish Date and price. I have also created a Combined View in an attempt to combine this Booking info into one view. I am having some difficulty with this part. What I want to do is create a Confirmation Page after the user has submitted the data which summarises ONLY his Booking
Using Creator to generate Estimates?
I'm wondering if anyone has a sample app or any bright ideas on how to use Zoho to generate itemized estimates. I can create forms with prices that go with services, e.g.: ITEM PRICE bread $2.50 milk $5.00 eggs $3.25 but, how do I create a single form where I can build an estimate? e.g.,: ITEM QTY PRICE TOTAL bread 1 $2.50 $2.50 eggs 4 $3.25 $12.75 TOTAL $15.25 In other words, dynamically add as many line items and select the quantity for each that I want. I can figure out total, etc. I realize that
Trouble on ....Send email to input.email.
Hi, I have a form with 3 fields ( name - email - number) I want to send an email to <email field -- input.email> as soon as the person enters the email and goes to the next field ... I tried placing the script on Email -->On User Input & Email --->On Update. Code:- SendMail { From : Zoho.adminuserid To :input.email Subject : "verification" Message :"<p>email---On Update</p>" ( this is to identify which one triggers the sendmail. } But, at both times, the mail does not reach the address given in the
Sendmail fails on first instantiation
I have created a form embedded into a webpage and used the sendmail function to email me "on success" when the submit button is clicked. The success of the sendmail function seems to be time dependent and shows the following behaviour: 1. Function fails if no form has been submitted for a time greater than 107mins (I am still testing to find if a shorter time causes failure) 2. Function works ok if a previous form has been submitted less than 62mins beforehand (I am still testing to find if a longer
Can Anyone prepare application on Zoho
Hello Friends, I have a simple request, i have created one application on Zoho Creators. I am looking for some more features, but i am really bad on Deluge Script. Or i can say i dont know anything about Deluge Script. Can anyone prepare the application according to my need. Please. Thank You,
Corrupt Form?
I have a form called "Camera Masters" that works fine except I cannot edit it anymore. When I go into the edit screen, I get the fields menu on the left, but a blank screen where the form should be. I cannot drag fields onto the form either. Help?
security rules
Hello, To embed in my website, I use this link To prompt for login details : https://creator.zoho.com/showViewLinkAlone.do?viewlinkId=<VIEW_ID>&link=true&sharedBy=<ACCOUNT_NAME>; To access the view without login (privatelink) : https://creator.zoho.com/showViewLinkAlone.do?viewlinkId=<VIEW_ID>&link=true&sharedBy=<ACCOUNT_NAME>&privatelink=<PRIVATE_LINK>; But why I can access the application with this link? https://creator.zoho.com/showViewLinkAlone.do?viewlinkId=<VIEW_ID>&link=false&sharedBy=<ACCOUNT_NAME>;
form view not showing submitted records
I created a form, but the view does not show any records that have been submitted. I do get a email of the records as they are submitted
Break out form data across multiple tabs
It would be great to be able to use multiple tabs to break up data types that all go to one data table. I don't want the user to have to worry about selecting whatever field connects two tabs as they exist now. jherlihy
Summary view needs 'edit' button
Please add a record 'edit' button to the 'summary' view, just like the other view types.
Backup description
It would be nice to be able to add a note to a backup so i could indicate why the backup was performed.
I'm trying to copy leaveform as one of my applictions but th
I've been trying to add leaveform from creator.zoho.com/zoho1/leaveform but am unable to do so. Can you please help me to do this. I have the 25$ business version so should be able to add as many apps as I want regards, Kristof kbl
Locking a column & some other questions
Hello, I hope you can help me with a couple of things: 1. I would like to be able to lock one of my columns from being edited by any user that is not an admin. Is there a way to make a field not editable? 2.Also i would like to add a progress field where an user can update the progress of a project and keep the thread of the progress. 3. Is there a way to have multiple contacts under one account without duplicatiing the "account name"? 4. Is there a way to edit the ID field? Currently if I go to
ADD NOTES
Has the new version been released that fixes the problems with the ADD NOTES function? Is there a way around this problem, (i.e. has anyone found another way to display information similar to how it would be displayed with the ADD NOTES function?) uindy_ot_students
Email from form getting bounceback
Hi, I'm trying to have my Press/Color Proof form email me when someone has filled it out or changed one that has been filled out, but I'm getting this in my in box: The original message was received at Tue, 5 Aug 2008 17:22:56 -0700 from [172.31.251.238] ----- The following addresses had permanent fatal errors ----- <jasonm@nimblefish.com> (reason: 550 domain of jasonm@nimblefish.com does not designate 72.5.230.67 as permitted sender) ----- Transcript of session follows ----- ... while talking to
how do I create a shopping cart kind of page ?
Hi, I'm new to zoho creator, I manage to do little apps but I don't know where to start for the following page: I would like to create a page a bit like Dell for adding options to a base product and add prices accordingly, It show be possible with scripting but I don't know how to start, is there a sample or template I could look at ? thanks jl
Automatically running Custom Actions / Functions
I have created a custom action / function that updates the value of a field according to access rights given to a user (based on loginuserid). This is extremely useful for only giving a particular user access to various rows in a form/view. However, I would need to automatically run this custom action / function when the view is brought up for it to be of any use. Right now it looks like the user must manually run this custom action / function. Is there any way to set up the view so that this custom
How to create searchable-by-date filters
Ok, the whole scripting language is a bit of a mystery to me, so if anyone with more knowledge of it than me could help me figure out how to do this, I'd be really grateful. I have a database with 4 fields and date is one of them. I've already set up the automatic filters, which let me limit the db by the other three fields, but how would I go about limiting it by date? Like, for instance, if I wanted to see 1) all the records from September, for example 2) all the records from September 1-15 (or
Safari
Form does not work for people using Safari. Are there vand patches or fixes for this? Thank You Mark Hughes agencyweb
CSV export missing quotes
This is one of those crazy bugs you don't know about until it happens. I have a view with a field that has sentences between brackets [], and each has a new line \nl after it once it was created. When I export this view as a CSV private link, all the records put quotes "" around the text in this field. However, the record that does not have a comma , or semi-colon ; in it does not get a quote. This wreaks havoc on Zoho sheets, when trying to link a CVS - it does not come in correctly or sometimes
Field Linking - two way?
I have created a form for "staff"; I have then created individual assets forms for each style of asset, for instance, computer, camera, cell phone, keys, etc. I have found a way to do a LOOKUP of Staff and bring the name onto the computer form. no problems. But now I would like to be able to open the STAFF form and have a summary listing of all assets in each category for which their name appears. How can I do this? eneusta1
Issue with Date Picklist
I have a form with a list of valid dates. I have another form where the valid dates are referred to as a picklist. I want to limit the number of records entered with a particular date, but I have a problem when I try and use the input.Date_field in my form validation. I can access the field fine in the field action, but I need to do it from the validation in order to cancel submit. The code is: on add { on validate { if (count(User_Status[Date_field == input.Date_field]) > 5) { alert "Only 5 records
sharing view
Hi, I have made an application in which i am sharing 1 form and it's view with one user and one view with another user(but not it's form). But the user with which i am sharing only one view can also add info in the corresponding form from which the view is generated. Why is that happening ? In my Share Tab of the application it says 0 forms and 1 views. This does not happen if the person is accessing the application from Zoho (in that case he can just access the view shared) but since i have embedded
Flash export ()
It would be great if Zoho Creator could export into a Flash file so you could embed the content more easily. Unfortunately Myspace only accepts flash content to be embedded. Or is there already a way to do that somehow? best Florian flozombie
Auto resizing of data entry form
when I resize my web browser, the actual form does not resize to fit. This, added to my additional feedback about field titles being able to word-wrap for longer text entries is important for user interaction. jherlihy
Just need simple signing in surface!
HI When I use the imbed in your website, I would like only to show the 1. Sign In 2. Username 3. Password Our users log into the Zoho System via our Intranet and to keep our professional layout we do not need the rest!! 1. keep me signed in 2. forgot password 3. New User? Sign Up for free! 4 Signing in using Google or Yahoo How can this be done! BR Dennis
most likely an enhancement
Is there any way I could have an email automatically load to a table in my creator application...the subject would be stored in one text field, the attachment(s) as uploaded files, and the text of the email as a note field. This would make my life wonderful, but am guessing it's a long way off! ramona
Question
Hi guys I have troubles with my application, I cant open wiev of this application but I have access to the account. What did I bad or what i didnt. Thanks salwek
Dynamic Queries/Views?
I have created a view where I can select the rows that I see using a constant as in: show all rows from ProductCatalog [AccessCode == "Terracycle"] However, what I really want is instead of using a constant (in this case "Terracycle") to instead use a value from another form, such as: show all rows from ProductCatalog [AccessCode == UserAccessCode[Varname=="Var1"]] BUT THIS DOES NOT WORK! What am I missing? It is a basic feature of SQL to allow a user to select rows based on some dynamic values,
Dynamic Queries
How do you do dynamic queries in Zoho Creator? For example, when using criteria or filters in defining Views, I cannot see how to make the select criteria work with variables, only constants. I am still trying to learn the code... Examples would be great. Thanks, -dm- david.miller
Custom search inputs for View
Is there any way to customize the search input boxes for Views? I like that you can have custom filters, but it seems you can only apply one at a time. Most often you want to limit your search by multiple criteria. I know you can use the search textboxes to do this, but in many cases its insufficient to have textboxes because you want your user to choose between certain predefined options (such as those in a pick list). I see that numbers receive special treatment with options like 'greater than',
Form view
I need to be able to have text in the field description (not the actual field name) wrap around so that it does not go all the way across the page and force horizontal scrolling. Also, would be nice to set some type of field background color - or a background box that captures both the field description and the data field so that on large forms with lots of data, it is easier to read across from the question to the entry field. jherlihy
CREATOR - Chart View Not working
The "Chart View" in the "List View" only shows one field to select from for the "x-Axis" and only 1/3 of the fields for the "y-axis" What determines which fields I can use to generate a chart in ZohoCreator. gpolzer
CHART VIEW - Not showing fields
In "view list" selecting "chart view" does not show the fields in the database to create the y axis and x axis. What determines which fields show up.
Next Page