Views :- Rearrange colums using up-down arrow
Hi, I see that i am able rearrange colums in View by drag and drop. This is okay, for say less than 10 fields. I have about 15 fields, ( and i might add more as i develop the application). I find it increasingly diffuclt to format views for the following reasons. Display the fields in view in the order in which they are presented in the form Say intially i have the fields in this oder. ( Name , Email, Address) Now I add a new field (phone ..between email & address)... in the form. The order of display
Problem with alphabetical appearance of fetched records
Hi I have a problem when I try to set my fetched records to be shown in Alfabetical appearance. Please see the error message. I have tried many times and for several days now! What can be wrong? Br Skouboe
Employee Deletion
Hi,I'm waiting for your response on the employee deletion. As of yesterday, I have a problem deleting employee records which are uploaded by batch. Errors appear everytime I mass delete the records per page. Please assist us.Thanks,dcsanjuan777
Supporting Application ...
With voting deadline for the first cycle just round the corner ... its time to start defining, designing and developing the Application to support the selection of future cycles of the Community Driven Features initiative. I'll leave the two voulnteers ... John (niskypto) and Deepa (deepa7476) to consult each other and come up with a division of labour in the development of this ZOHO creator Application. But first, I'd like to make some suggestions for the scope and design of this Application. Here
Summing Currency Field
Hi, I'm trying to write a function to get a total sum value for each Currency field in all my records. Her is my attempt: float totals.SpendTotal() { TotalSpend=0; for each S in Payment_Tracker { TotalSpend= TotalSpend + S.Amount; } return TotalSpend; } I get following error message: Error in statement at line number 6 The template variable TotalSpend is of type BIGINT. But you are trying to update it with an expression of type DECIMAL I have tried int instead of float but to no avail. Its
HTML View - How to email the page?
I have created an HTML view, but want to take the code and email it as a rich-text email. Is there a way? PS: You cannot email i-frames, so that's out.
"like" operator statement
Hi, What can I do a "like" operator in creator? Ex. I want to get the records which contains "corp" in a company_name field...in SQL, I can do company_name like '%corp%' How can I achieve this in creator. Thanks.
Selecting view records from a multi-select picklist field
I have two views - one a list of topics and one a list of activities. I want to show a list of all the activities associated with a given topic. Activities can be associated with many different topics so the TopicRefs field on the Activity form is a multi-select picklist. I have created a custom action by row on the Topic view that calls a function with TopicRef as a parameter. The function then uses openURL to open the view. My openURL statement looks like this: thisURL = "#View:Activity_View?TopicRefs="
Resposta
Muito Obrigado pelo seu E-mail. Volte Sempre
Obrigado!
Muito Obrigado pelo seu e-mail. Volte Sempre!
Minor problem with Confirmation Request ...
Hi: Only noticed this today ... but when I select a record in a List View and then click on the Delete link ... the resulting confirmation message seems to be messed up ... this is what I see ... The page at http"//creator.zoho.com says Do you really want to [0]the selected[1] record(s) delete undefined X undefined OK | Cancel ... where X is the number of records I selected for deletion. When I respond with OK or Cancel, the subsequent actions are as expected ... just the warbled message will confuse
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
Shrink-The-Web Thumbnails?
Does anyone know how to leverage the power of Shrink-The-Web to display thumbnails based on a URL field stored in a database?
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
Deadlines for Suggestions/Discussions and Voting re: Cycle #1
Please note that new submissions for Cycle #1 of the Community Driven Feature will not be considered after Wednesday May/6 2009 (11:59 P.M. PST). Also, I am hoping to open up the current submissions for Voting by the Community on Monday May/11 ... and close voting on Wednesday May/13 (11:59 P.M. PST). Gaev
Secure page
Hello, Is there anyway to create a secure page that clients can go to to fill out a form including their credit card info? I would love to be able to do this vs asking for the info over the phone which is what I do now. I think they would feel safer doing that. Thanks, Eli
Why Can't I Change Milestone To Which Task List Is Assigned?
hi in Project Manager Plus, i want to assign a tasklist to a different milestone, but i cannot. the milestone field is disabled, when i 'edit' the tasklist. why? i should be able to do this. ...ok, i'm starting to see that i must implement a custom control on the new_tasklist form, which let's me pick the milestone, and somehow links it to the milestone ID field. i tried this manually, by unhiding the milestone ID field on the new_tasklist form, and it half worked. on changing the milestone ID field,
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.
Eye Candy for List Views ...
Although I would like the first Community Driven Feature to be the development of the "ReplaceAll built-in Function" that I suggested here ... http://help.zoho.com/portal/en/community?ftid=2266000000242421 ... for those of you that feel there is insufficient benefit to be derived from being able to transform template Emails and HTML Views with speed and ease ... I suggest another feature here for your consideration. This suggestion is actually a collection "eye candy" improvements relating to the
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
User input variable
Hi This could be a very stupid question, but I just can't figure it out or find any info in the help docs... I have created a Custom action. When I activate this action I want a window to pop up and ask for two values that will then be used in calculations for modifying the database values. But I have no idea how to create two user input variables ... Please help!
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
Next Page