Error On Deluge Autonumber Script
the validate script below is giving me the following error: "Invalid entries found. Please correct and submit again." this is an autonumber script, copied from the Deluge manual. here's the explanation. x = MaxIDs [ID != 0]; input.TaskID = (x.TaskID_Max + 1); x.TaskID_Max = (x.TaskID_Max + 1); why am i getting this error? i'm using it in the Project Manager Plus app, from Marketplace. THANKS
FORMULA
I have this formula in my spreed sheet and wanted to know if there was a way to put in zoho Creator for a form i am creating thanks =SI((E85<=24,99);(E85*0,12);SI((E85<=100);(2,5+((E85-25)*0,08));SI((E85<=1000);(7,75+((E85-25)*0,04));(52,75+((E85-1000)*0,02)))))
Another issue with hidden fields ....
@ZOHO Creator Support Team: In order to dynamically filter the record in a List View ... so only records where fieldX=abc are shown ... I append ... /fieldX=abc ... to the url for the List View. This works ... but ONLY as long as the List View is defined with column for fieldX being visible ... if it is left hidden, ALL records in the Table are shown. This is yet another case of a hidden field causing unexpected results ... similar to the previously reported case of the hide fieldX command causing
Dynamic fields
I am building a survey, and I need to display some fields for one survey and another set of fields for another surveys. The surveys are for each country. There are 200 countries and each country will have its own set of fields. How can I do this based on URL parameter? Ramin
Is there a way around this ?
I have an HTML View that contains an embedded (via iframe) List View (so I can dynamically filter the records displayed in the List View). Each record in the List View has a Row Button ... the function associated with this Row Button navigates the User to another View within the Application ... this is done with the openurl command. When I use "same window" as the second parameter ... no navigation takes place ... the current View remains displayed. When I use "new window" as the second parameter
PDF of HTML view
Hi, HTML views are primarily used as dynamic reports, passing some unique ID as paramter. It only makes sense to have the "report" as pdf file that can be saved ( & emailed if need be) Do you guys think, ZC users could use this ???
Decision Box Display 'Alias' True = 'custom msg' False = 'custom msg'
Hi, Here is a small but extremely useful feature. Decision boxes are extremely useful in terms of simplicity and elegance of input: Check or Uncheck As against individual radio buttons, with Yes or No or XXXXXX or __ But on the Views we see values such as True or False. The text is Black and it doesn't help to distinguish between both at a glance, as we don't have colour variations for different values, and as Gaev has pointed out so many times, each lacking
How to use ZC API METHODS
I am new in the ZC API METHODS. I tried to use the REST API METHODS LIST (url: http://api.wiki.zoho.com/REST-API-Methods.html). For test purpose I have a JAVA program that use the view Record - Get Method (url: http://api.wiki.zoho.com/ZC---View-Record.html). Find bellow the program. Due to security reason I do not include my apikey. When I run the program I do not get nothing ! can some one help me ? Antonio -------------JAVA-------------- public static void main4 () throws Exception {
picklist update
I have a form that contains a picklist element as defined below: must have firstChoice
(
displayname = "First Choice"
type = picklist
values = weekends[activeWeekend].label
)
As you can see, the values are populated by pulling from another form with a criteria. Here's the thing, this is exactly how I want it to work when the data is originally submitted. However, I've noticed that if I want to edit this info after it's been submitted, the same criteria is being applied.
Unable to select view fields for use with custom action
Hi, Here is a view I've created, with a custom action I've just added. I've had to add the custom action using the view definition free-script editor, because I was unable to select the field "FullEpisodeNumber" as argument for the function in the "create custom action" wizard. Why?? list Subs_a_bajar { displayname = "Subs a bajar" show all rows from Capitulos [Sub == false] ( Serie FullEpisodeNumber Title Filename DateAdded ) filters
How to translate "user submitted data" ?
email notification with user submission data works perfectly well, but zoho creator writes "user submitted data" in the email body before data : People I write to are french, I'd like to write them in french. :-) Is there any way to remove or translate "user submitted data" ? THX. -- Nina
dropdown menu displays in alpha order even though box not checked
Hi, the dropdown menu in my applications is now displaying the items to select in a strange order, instead of the order in which they are listed.They are not even displaying in alphabetical order. They are displaying in a random order.By the way, the "display in alphabetical order" box is NOT checked.here's one of my applications which has been shared with supporthttps://creator.zoho.com/cindychoi108/form/1082/edit/
images not displaying in view
Hi, I have a view that displays the result of the formula below: "<img src='" + Image_URL + "' title='" + Image_Name + "' alt='Display Uploaded Images in Zoho Creator' />" This had worked for weeks without any problems until I checked it today. Now, instead of seeing the images, I see only the alt text. I know this isn't the result of any changes I've made because I haven't edited the application in over a month. Any ideas why this would happen? Thanks!
Compare Two Lists
I know how to do this in Excel using VB, but cannot get anything working in creator. Basically, I have two lists in ZC, call them A and B. These are separate single column databases: List A is a vary long series of numbers while List B is very short. What I want to do is tag List A with any entries that match in List B. I'd add a new column (text field) to List A for the tags "matched". I'm just about ready to pull these into Excel and do it with VB, but wanted the Zoho community to take a look first.
How do I import data from a spreadsheet / csv file with carriage returns in the data?
I am trying to import data into a creator database from a spreadsheet, and one of the columns has carriage returns. Do I need to conver the carriage returns to another character to load the data, or am I just totally missing something in the load? Thanks.
Any Help?
Hello, Basically I am developing an application on zoho creator its quite simple, its a holiday booking system and basically the user shouldn't be able to double book a cottage,I have 2 date fields in the reservation form one for date in and one for date out. I have selected no duplicate entries so they can't book for the same day, but this doesn't stop them overlapping e.g. one person stays the 22nd april - 25th and a second person stays from the 19th- april to the 23rd the system will still let
Lots of bugs in firefox.
I've found many bugs using firefox - I recommend that you ask clients to use IE only. Dan
embed the entire app
1 when I access the application, I can embed in a website. But, in facts, only the current form is embedded. I would like to embed the whole app, with the layout and tabs as designed in the design choosen. 2 When a printing button will be added to the app ?
Zoho Creator
Can i create forms in 'Zoho Creator' that adds records to 'Zoho DB'? Right now they seem like 2 completely seperate products. If not, this would be very useful.
Can I use HTML view to control Forms fields?
So that I could style and locate fields the way I want? and use this form as a page to collect data? Ramin
Dynamic picklist clears at start of action
Hi - I'm trying to build a dynamic picklist from the selections in another dynamic picklist using a custom button on a stateless form. Here's the scenario: 1. Picklist1 is populated based on the selections in other fields. (Works great) 2. User selects entries in Picklist1 then clicks on Add button to add entries to Picklist2. (Works the first time) 3. User can then change entries in Picklist1. (Works great) 4. User selects entries in Picklist1 then clicks on Add button to append entries
Opening Remarks from the Community Representative ...
Thank you Charles for inviting me to be the Community Representative. I am happy to quarter back this process and deliver the User Community's collective decision regarding the first feature to be developed. As I am charting new territory here ... I don't know of any other vendors offering this kind of formal channel for their User Community ... so I suspect we will not get it all right the very first time. Hence my approach is to invite all users to not only make their suggestions for Candidate
Client side API
I am trying build a custom look and feel for the form and tried out Client Side API. I can see the fields, but I cannot make the functionality that I built in ZC work. For instance, I could add ?id=xxx to URL and it would prepopulate fields for me, but with Client Side API, I cannot pass the parameters. Any thoughts. Ramin
Vanity URLs
Does ZC apps support vanity URLS? i.e., could I have www.mydomain.com/appname/formname/etc.? Ramin
'Nex' instead of submit?
All- I'm developing a lengthy form and would like to break it up into multiple pages... What's the easiest way to achieve this?
Applications list is not displayed
When opening Creator, the list of My application is not getting displayed 50% of the time. The list below My Applications is empty. I need to reload the page number of times (sometimes close to 10 or 20 times) to make it appear. This seems to happen with Chrome -Jag
Best way to link to another form
What is the best URL to link to another form within an application? Does it change if provided to outside users?
Newbie here needs help.
This is my first post to this forum. I'm pretty new to Zoho, and I've created a few forms to help track members to my group, as well as RSVP's to my group's events. However, I can't seem to figure out how to have Zoho keep a running tally of how many "yes", "no", and "maybe" responses I collect from my form. I found something called "iterate data in radio buttons..." (my form collects RSVP's via radio buttons) but I'm still having a hard time understanding the scripting language. Can anyone help?
timesheet
I want to make an application to fill timesheets. How can I easily fill-in a time variable (starttime for example 08:30) , end-time (16:45). As a result the the worktime has to be calculated. I don't want to use the date/time widget but just want to fill in as stated above. any ideas.
Extended browser support
I'd propose ZC team to focus on browser support, now limited to Firefox 3.0+ and IE 7 + . I was in situation to ask a client to put a notice for the visitors of his website to use only IE or Firefox, knowing that almost half of his visitors use Chrome or Safari, and this because the solution I provided in ZC does not work with these browsers. More than that, Firefox will be upgraded in a few months to the version 3.5, it will be a major upgrade, and if you are a developer and use latest beta builds,
fill in textboxes with url
Hello, I've been using zoho creator for some time now, but what I like to do is getting a variable string from the url. Meaning I can create a url with 2 variable which opens my form on the zoho website and automatically fills in 2 Single Lines. Is this possible? I've been fiddling with the deluge script, but can't seem to get it to work. Can anybody help me, or direct me in the right direction. Thanks
Wish List
This follows on the very long post here: http://help.zoho.com/portal/en/community?ftid=2266000000241253 With the advent of a community-driven voting system, I thought to post my wish list just for fun! Prioritized... Fix ZC bugs iCal feed ZC Scheduler Time-only input field (customizable 12/24 w/option to not include seconds) Basic rich-text editor in multi-line input field (must include hyperlink editor) Scripted views for On LoadHappy Earth Day
Built-in Function ReplaceAll(searchString,ReplacementString)
Following my own suggested guidelines for proposing a Community Feature for the very first cycle, I suggest that ZOHO Creator provide a new built-in String Function that would ... Replace all Occurences of a specified SubString within a specified String (field or variable) with another specified SubString ... for example ... sourceVariable = "Jack and Jill went to Jack's place in the city";
searchString = "Jack";
replacementString = "Bill"
resultVariable = sourceVariable.ReplaceAll(searchString,replacementString);
Creator: redirect to another form
Is there a way I can redirect to another form. This should happen once I am able to verify user credentials on my page...
Query functionality in list view
Hi, I feel one feature that can significantly enhance user-friendliness of ZC is some kind of query functionality (run-time) in the list view. Presently we have the search functioanlity. But it does not support search based on boolean logic (for example status of project being "Completed" OR "Nearing Completion", start date being BETWEEN 01-April-2008 and 31-March-2009, etc.) Using custom filters do not give so much freedom to user as in the case where he/she enters criteria values to run the
Multi-dimensional Lists
Hi, I had given a 'green-light' for Gaev's suggestion for 'search & replace' functionality to be our next community-driven feature. But in the event that the function might be anything less powerful than Regex itself, or take 'a considerable amount of dev time' to implement, which any good function normally would, I propose this feature instead: Multi-dimensional lists with sort functionality. Currently we can have a List Animals: lion fox bear gazelle fish BUT: I would like to be able to have List
How do I access the data collect by this form?
Hello, I want to export the data collect by the form. How do I access it.
problem on Zoho Marketplace
Hi! One week ago I wrote a message to support using "feedback" link. In that message I asked for an urgent solving of a problem on Zoho Marketplace. I did not receive any answer, probably my message was somehow missed by ZC support. But the problem seems to me a very serious one, and I want this post to be a as a warning for the developers who published application on Zoho Marketplace or intend to publish there. What is about? I discovered that the Deluge script code of any application from Zoho
From HTML view to pdf
Hi, I have created a nice invoice for my application, based on a HTML View that combines data from various forms. I have discovered in the process that HTML Views are incredibly powerful: congratulations on the 3.0 version, which is truly a major improvement. Problem: how do I actually send the invoices to our customers? I was hoping to just print them on paper or print them into a pdf file, but this is much trickier than I thought. The HTML View in question is triggered through a Function, so I
A Message for Senior Management ...
ZOHO Creator Team: My client had a simple request ... To be able to view a list of records within a certain date range that is specified at run time ... group them by a another field (defined in Edit Mode) ... and for each Group show the count of records for the group as well as the Sum of another field (also defined at Edit time) ... something mundane as this should be possible without resorting to HTML Views ... but not with ZOHO Creator ... so the workaround was to setup a Stateless Form for the
Next Page