Success message for stateless forms
If you use a stateless form to make some things such as inserting records or updating some existing records, it seems that there is no way to display a success message (as the one which appears in the normal forms). This is the situation, in spite of the fact that at More Actions - Form Properties in edit mode there is "Success Message:" which is completed by default with Data Added Successfully! . Success Message script from Deluge works only in normal forms. If there is a way to display such a
Problem with toString()
I'm using toString() to validate a time entry in my app. For example - entries are only allowed in increments of .25, so I take a decimal number and split it on the decimal point using the following two lines: input_hours = ((input.Hours.toString()).getPrefix(".")).toLong();
input_minutes = ((input.Hours.toString()).getSuffix(".")).toLong(); This works fine, except if i switch into Script Builder view, it automatically converts the above lines into this: input_hours = (input.Hours.getPrefix(".")).toLong();
input_minutes
text not wrapping in FF on View
When I click on the View button to the left of each record in a view everything is properly displayed except for a multi-line text box. It is fine in IE but FireFox does not wrap the text. Is there any setting I can change to fix this? Herb Wexler MBA www.PreventingMediocrity.com
Is it possible to make permissions field based?
We'd like to limit certain users to only be able to edit certain fields within a view. Is this possible? Thanks!
Plese Help! Need Multiple Forms
Hi was hoping I could get some assistance. I am trying to build a rather lengthy form to collect a large amont of data from users. It is not practical to put all fields on one form as there will be over 300 fields. Is it possible to: -Have a user input information on form 1 (ie name & address) click "continue" button; -Form 2 Loads. Enter more informtion on form 2 click "continue" button -Form 3 loads. Enter more information on form 3 click "continue" button Etc... Then have all info stored in
"search" link in "summary" views
Hi, On my view called "impression", I don't have the option "search" in the view header (I have only the filter option). and I would like to have it. is it scriptable ??? Display property of this view is "summary". (I have the search option, when the display is "list")
Status of IP Address Feature ...
ZOHO Creator Team: In the Wiki page where you maintain a list of items being worked on ... http://zohocreator.wiki.zoho.com/Working-on.html ... for quite a while the item "IP Address Field" has been marked as "(nearing completion)". However, I notice that when using the Script Builder (wizard) ... and (say) the "set variable" command ... I can choose zoho.ipaddress as one of the ZOHO Variables. So, is this item completed (and just not updated in the wiki page) ... or is it still being worked on ?
Imported Picklist- Show in Sort Order
I am importing a picklist of dates from a view that is sorted by date, but in the picklist, the dates do not show up in chronological order. How do I make the dates show in the correct order? Thanks
Field transform and/or value import
----------------------------------- ***** Problem Solved **** ----------------------------------- Hello, I have data imported from a 5 columns x 500 rows .xls file. It all came in Single Line fields, with the following structure: C1 C2 C3 C4 C5 entry 1 | entry 2 | entry 3 | link-for-entry-1 | separate-link-for-entry-1 [...] entry X | entry Y | entry Z | link-for-entry-X | separate-link-for-entry-X Can anyone think of a smarter
RSS to iCAL
newbie post! Anyone have a script to convert creator rss feeds into an ical format? Thank You
make relationship
Dear all, I have made my own database application. But i need to make a relationship about 2 fields in different form. How do I make it ? Thanks for your attention Regards, Bang Said Tangerang - Indonesia
Decimals in number field possible?
Hi I have a number field where it seems as it is not possible to have decimals. Do I have to create another type of field of is it possible to let the type of field handle decimals? The system should be able to handle 3 decimals. the error message on update is; Br Skouboe
What does this field actually do?
Hi I have a view that include a calculated field called "total_times_used_minutes". This field calculate the sum of two fields. I have noticed the field and tried to activate it so that it shows but I do not see any differencies? what does it do? What I would like to see is that the total sum of the calculated field in the view (in the bottom of the column where I have the calculated fields). If the above does not solve this, do you know how to do this Br Skouboe
Deluge Future
I read that one of the future features in Creator will be support of the syntax of different languages in scripting. I was wondering if the Zoho Creator team plans to keep Deluge as the primary scripting language or if it will eventually be deprecated. Thanks!
Mega form - more than 200 fields? It is reliable?
Hi all, Please advice me on this: I don't know what is better: a) Create a Mega form, with kind of 200/250 fields, to work as single database, and create several stateless forms to feed it (On submit - INSERT TO). Then make several views to filter the information as i need. Or, b) Create several forms and register my data in independent forms, (but always have several commune fields). What i intent do know is if it is reliable and fast to have a form with more than 200/250 fields. And the Pros&Con
Creating Charts in Zoho Creator using Zoho Sheet API
Zoho Creator charting functionality helps you to quickly and easily analyze data in a visual format using a variety of graph types. To create charts with data from multiple ZC forms or to display grouped data, you can use the chart API supported by Zoho Sheet. The Sample Application named "Student Management" demonstrates this functionality. In this application, we have defined a function called "getChartUrl" (you can see the function used in the application under the Script -> Functions tab in
Re: Debugging
Hi, Would you be able to expedite the debugging so we could use the application and consequently upgrade our subscription? Thanks, dcsanjuan777
"Edit" in a webpage embeded "view" do not work.
Hi! I have embedet a "view" of a data base in a webpage. When the user clicks "edit" and changes the data, the "please wait" message sits an the screen and the "edit" box do not close. The data is not updated. What can be the problem? Best regards Benjamin Sjur Blom
COLOUR
IS THERE ANY WAY COLOUR CAN BE ADDED TO A DATABASE?
I am hitting a maximum # of chars - or some limiting factor - in a Multiline field
I am cutting from Word docs and pasting large amount of text into a Multiline field. Most records display just fine - but some of the larger bodies of text are not fully displayed, the text being cut off mid-view. Since I note that the FAQ's claim there is no limit to the number of chars in such a field, I wonder what could be causing this? Many thanks for help.
View not editable by shared-to user
I have created a view for co-editing with one of my shared users. The app is open for support access (it is called "ich und mein lichtenstein", the view in question is called "Eingabe View" - its the only one for now anyway) The shared-to user is able to enter data in "Eingabe" but cannot retouch / edit anything she has done in "Eingabe View". Am I missing something here? Thanks for your help.
Script has stopped working
For Support: I added selections to some lookup fields in my "Farm-Based Education Material Database" and now when I go back to the "Search with Options" form, the "on user input" script for the "Material Sub-Categories' is not working. The script is there and I can see it, but in the actual form, it shows no evidence of detecting the script (ex. no little arrows turns). I would expect the arrow turning even if there was an issue with the script, but there should be no issue as i changed nothing with
Age Math Does not work for me
I want to calculate someones age from their birth date. I noticed in the help there is sample code. I copied this code exactly from the zoho help into a function. value = ((zoho.currentdate - DOB) / (1000 * 60 * 60 * 24 * 365)).round(0) When I execute this code if I choose a birthdate before December and after May it tells me the person is one year older than they should be. Example if you choose a birth date of November 3, 2007 it tells you they are 2 instead of 1. Why is the
>= zoho.currentdate
hello! I am trying to figure out how I can have a calendarlike list showing entries that are after the current date, but also up to 2 days before the current date. this is the closest I get .... (my_date_field >= zoho.currentdate) best Flo
Function Does not Work From View Header
I am using a the openurl within a function to create a link to a "Full Record View". The function works when I use the button from any individual record. It does not work when I select a record any use the function from the custom actions drop down.
Difference Between null, "", and "-Select-"
If you have a dropdown menu, what is the difference between using: if (input.dropdown != null) if (input.dropdown != "") if (input.dropdown != "-Select-")
discontinued the support for javascript
Hi I have received an e mail regarding the above. Please help me defining if AND WHERE I use any javascript in my application AFB System 2.0. This is a very vital program to us. BR Dennis Skouboe
Print Button
Any ideas on how to create a print button in Zoho Creator, window.print() doesn't work in the script.
HTML View - Embedded summary view
Hi, When I make an HTML view and embed another view in it of the summary type, the "Edit" and "Delete" links remain visible and functional even when I disable them in the embedding dialog box. Any way around this? Thanks.
When a criteria is reached in an if statement
How would you go about ignoring the rest of the script in on user update field once a certain criteria is reached? For example" if (criteria) { run script } else if { run script } else { } if (criteria) { run script but stop all other script below } //Is there a way to ignore any script below here else if { } else { } if (criteria) { { else { }
Bug in CRITERIA
When I have two criteria connected with an AND (&&) the related VIEW doesn't work. When I have the two criteria seperately it does. THIS DOESN't WORK show all rows from Data [(Confirmed == "No" && Zoho_User_Name == zoho.loginuser)] THIS DOES show all rows from Data [(Confirmed == "No")] AND SO DOES THIS show all rows from Data [(Zoho_User_Name == zoho.loginuser)] The View just shows "We are unable to fetch this data, sorry! Please note that your data is SAFE. Report this problem to support@zohocreator.com.
Hiding Fields
I'm wondering how I can hide a field on my form. It's a Stateless form currently with just a 'Next' button. It cycles through the records of another form. I can't use 'Hide' and 'Show' except in 'On Load' and 'User Add' I think. I want to Show a field that says 'Last Record' when on Last Record, and Hide it any other time. I've been able to remove the label by editing the Form Definition, but can't remove the Text box outline. Any ideas would be welcomed! Thanks - Graeme
Freeflow Scripting Syntax
Ok - Very basic question . . . where can I find some documentation about scripting. What I'm looking for is just exactly how/when to use {}()[] etc. What has to be enclosed in what & when. Sorry - it's got to be the most basic question I could ask but at this stage it would be really helpful! Thanks v much
Question about User defined variables
I've declared a variable in the 'On Load' section . . . viz: nextIndexField = '01-Jan-2000 17:04:16'; if (count(Workshop_Job) > 0) { //get First record myCollection = Workshop_Job [Added_Time > nextIndexField] sort by Added_Time range from 1 to 1; input.Customer = myCollection.Customer; nextIndexField = myCollection.Added_Time; } else { //this is last record ... now what ? } But then if I try to use it in my Button Click code . . . viz: //get 1 record ... whose Added_Time
Log-In Problem
The system won't list my applications.
About Latha's Blog ...
In her Blog of April/30 here ... http://blogs.zoho.com/creator/functionality-based-urls ... Latha (of ZOHO Creator) refers to "Advanced URL patterns for Zoho Creator Forms and Views" ... and describes the ability to "To set criteria for a view" via URL parameters. It goes on to link to a page in the ZOHO Creator Wiki ... http://zohocreator.wiki.zoho.com/Functionality-based-URLs.html#criteriaconstants ... which lists all the op-code values that can be specified within URL parameters in order to filter
View criteria: "date" before...
I try to set this criteria: Show Restricted records Criteria: "date" BEFORE 01/01/2009 The date format is the format I you use for my appl. I confirm with "Done" but the result is always Criteria = none Can you help me? Thank you in advance Lucia
My Form won't Submit
When I 'Submit' my form, it just says 'Please Wait' and never says it was succesful . . . and doesn't appear in my views. It's pretty simple as I'm just starting to learn this stuff . . . it used to work. I have shared it with support. Appreciate your help.
Zoho has no affiliation with www.zohocreator.com ?
I was logged in my account, and I tried to open in another tab www.zohocreator.com. The following message appeared: Access Request www.zohocreator.com is asking you to grant access to your Zoho account details. By clicking "Grant Access", you give Zoho permission to enable www.zohocreator.com to access all your user data available with Zoho Services. At any time, you can revoke the access permission to this site. To revoke access, go to "Authorized Websites" page in My Accounts Note: The Zoho privacy
Creating REALLY dynamic views.
Hey fellow Creator Zealots. Another great find for me and I hope this helps you. Subject-How to: Open an html view with MULTIPLE conditional embedded views by passing parameters to those views! Clarification: So instead of just having say ONE edit form open you can pass those record ID's to multiple embedded forms or views creating a whole page full of conditional information on the fly! It starts with the following code COURTESY OF RUBEN! He's great! <div elName='zc-component' formLinkName='Test_Form'
Next Page