Accessing state of multi-select picklist
I have a form to record orders taken in which a sales type has to be selected (Retail, Trade, etc). I wish to summarise this information in a scripted form, whose only purpose will be the presentation of summary information from other forms - i.e. not a data-input form. I have added a lookup multi-select checkbox that looks like this: [ ] Retail [ ] Trade [ ] etc I have added an unbound numeric field for populating with the number of matching orders taken. I have created a script which correctly
cancelling on load actions
I have written a short 'on load' action which alters the value of a field in another form. If I 'cancel' the action the altered value in the other form remains altered. Is there a script that can run 'on cancel' to put things back to where they were?
Zoho Creator security roles assignment/copying a user
I have a user whom I assigned access to some forms and views. I am adding another user who is going to have exactly the same roles and views as the first user. I want a "copy" function to realize this menial process.... can this be achieved?
Embed in blog
I've created a form that i want to embed in a blog. I can remember how to generate the script to embed in my blog. How do i access that feature. thanks
Page Break in E-Mail
With regard to an email generated by "Creator"... Is there a way to insert a page break for printing? I'm using ZOHO's "Creator" to generate a report, of which I need certain pages to contain isolated data. Any help is appreciated!
Issues with upload fields
Hi all, We have 2 issues with upload fields: - Upload seems to work, but downloading the file (by clicking on the link) does not work. We have tried with pdf and word files, to no avail. What could be causing this? - We cannot remove an uploaded file, only change it for another. How do we remove uploaded files? Many thanks in advance
Sendmail From...
My organization uses Mailman for managing email distribution lists. We will be sending a weekly newsletter to our large subscriber database soon. Due to the way Mailman works, the ability to relay email is based on the FROM value in the email. As you know, ZOHO only allows two types of FROM values, the admin and signed-in user. This limitation poses a problem for me because I have 10 different lists with 8 different email addresses with the relay privilege. As I cannot script a sendmail event to
Is this Possible
I would like to have a quoting system for my web site. I envision a series of 4 dropdown menus. The client would choose a product from the first dropown. The next dropdown could be color, followed by quantity etc.. I would then like the form to total the cost based on their input and display the quote to them as well as email me. Is this possible... Yes i am a newby
Grid view error
Sometimes when I define a view type to be grid, when running it, it still displays as a list view. Example, "fantasma shipment view" under "fantasma" section, in my app trademaster. Could you please look at it and solve the problem? Thanks.
Creating Views Dependent on a Value in another Table
I am wanting to restrict a view based on the client who is looking at the view. I have 2 tables. User Table: This contains the User Name, Email and the Client Name View Table: This contains all sorts of fields including Client Name Any suggestion on how I would restrict the view so only records that match the Client Name are shown? Producing a new view that has a filter for each client is not very workable, as I will have to create a new for every new client. Glenn.
Field Limitation
I cannot add an more fields in my application. Is there any way I can add more fields? I currently have 96 fields ranging from Single line text fields to drop down menus.
Creator view drops columns
Several columns that appear in a view disappear when the view is printed. The columns are "unchecked" in hide columns so that they appear briefly but there is no way to save this data. When the view is printed the columns are gone and the check boxes are blank. Plz advise. Thanx
Developers should be treated as login owners for error messages and Hidden fields.
Creator places the login in the URL of the application. This forces us to use generic logins so that our names are not in the URL. We set users to developer so they can develop the application and participate in the Forums with their natural names and not have to log in and out all the time. A. This permission field is should be for ALL login owners and users marked as developers. B. When a script error is generated while logged into a developer account the developer user does not get the error message
RadioButtonSet.Select() does not invoke RadioButtonSet.OnUserinput()
Hi, I have a radio button set. I'm using the .Select() statement to programatically select a radio button option. I'm expecting that when I do this that the code behind the radio button's field action OnUserinput() will be called. But this is not happening. Once I issue the .Select() how can I invoke the OnUserinput()? Obviously when I use .Select() I'm expecting that it would behave as though the user had selected that option. Any ideas or workarounds? Thanks, Tony.
Managing User Access - Sharing
I have built quite a few apps now with Zoho Creator, and expect to build more in the future. One issue that is taking up time and I find very annoying as it does not allow the business to manage their own users, is that it is up to the Developer to share forms and views. It would be so much better if there was the ability like in Zoho Business where a user can be added to a group and then they gain access to the bits they should. Is there any way for a non-developer to manage users and share out
Can't set Added Time during import
I am trying to import 5 years of data from an existing database into a new Zoho Creator database I have made. However I am unable to set the Added Time field while importing. This is a problem as I need to keep track of the original dates of the contacts from the old system. Is there a way to override this field during import? Thanks, Kevin
Free-flow Scripting set to default
I never use the "Script Builder" anymore. While it was fun at first and a help to find system objects it has several drawbacks. I exclusivly use the "Free-flow Scripting" now. It is inconvenient to have to always switch to it. I would like it to be my default editor mode. Also, once in Free-flow mode when I switch to the form editor or views or anything else and back to scripting it reverts back to Script Builder.... frustrating. Please add this to your feature request. Set default script mode. Thanks,
Yet Another thing Broken ...
I am building a Stateless Form for another Client ... here is the code I have entered for a Button ... if ((input.MyCallsPerDay == null) || (input.MyCallsperDay == 0)) { alert("Calls Per Day is Zero or Unspecified"); } else if ((input.ApmntsPerWeek == null) || (input.ApmntsPerWeek == 0)) { alert("Appointments Per Week is Zero or Unspecified"); } else { CurConvertPercent = (input.ApmntsPerWeek / (input.MyCallsPerDay * 5)); CurConvertPercent = CurConvertPercent.round(1);
Lost data - HELP!
hi - i made some edits on the weekend -including adding a field.. now i've logged in tonight and the data from the new field is all gone.. GREAT if anyone can help out here ? is this typical with zoho - i'm new - i can't afford this kind of data loss. i don't know if there is a restore function - but i'm not sure I want that - because i made some other changes that i don't want to lose!
printing
Is it possible to print out an embeded view in a web page so that only the table would be printed
User defined Function messes up Argument names starting with Replace !!!
I just wasted 2 hours because the User Defined Function facility messes up when you specify an argument name that begins with Replace e.g ReplaceText or ReplaceString. a) the Save Script Button would report this error ... Encountered "input .Replace" at line 5, column 13. Was expecting one of: "Workflow" ... "output" ... "bool" ... ... "float" ... "list" ... "map" ... "var" ... "htmlpage" ... "string" ... "date" ... "void" ... "this" ... "criteria" ... "given" ... "declare" ... "fetch" ... "ensure"
I cannot duplicate a HTML View
Whenever I try to More Actions > Duplicate view is does not work and sends me to http://creator.zoho.com/tonythomas//htmlview/null/edit/ Looks like it might be a bug, but I would assume this was tested. So what might I be doing wrong? tt
Inconsistent hyperlink behavior: multi-line and single-line inputs
In an application I have "Allow HTML Tags: Yes". On a form, I have a multi-lined text field and a single-line text field for users to type in. Some of them are typing in http and email addresses in these fields. When I view the user inputs in ZC: Neither the http or email text is click-able in the multi-line data Only the http is click-able in the single-line dataThis is clearly inconsistent behavior. ZC should be smart enough to see a valid http://google.com type links an render it as a working
Image Display Seems to be Broken
I have created an application that displays a few images that are uploaded. This was working fine, but for some reason it is not working any more, I just end up with broken images. I notice the same problem with the Zoho written sample application - http://www.creator.zoho.com/sampleapps/image-link/# Is there something going on from Zoho Creator end that is causing this? Glenn.
Min function
How can the Min function on a data range on Numeric values be done ?
zoho sheet graph API
I started using Zoho creator not long ago and was surprised by the ease at which it can be mastered. However, I find the documentation a bit lacking. For instance, to create a graph using zoho sheet API, you give an abbreviated list of chart types (BAR,PIE,LINE,....etc), but nowhere can I find the complete list! What is the code for line+markers, or scatter+line? Thanks Menachem Sklarz
Can not copy File Upload Field
Hi ZOHO Creator Team: I have a Stateless Form from which I popup a (new) Form ... in the on Add on Load section of this popped up Form, I have code like ... //fetch Client Profile record for this Client thisClientProfile = Client_Profile [Client_ID == input.Client_ID]; input.Business_Name = thisClientProfile.Business_Name; input.Menu_File = thisClientProfile.Business_Menu; alert(input.Menu_File + "..." + thisClientProfile.Business_Menu); Business_Name is a Single Line Text field ... Menu_File
Shared
Zoho team, I have been invited to an app, twice, but still get the message : You are not authorised to access this application in Zoho Creator. Go to Home Maybe you guys can take a look at this?? Regards, Danny Sterke
script source for img
i tryed to show image with link like <img src="http://something.com/someimage.jpg"> and it worked perfectly. but i need: in form "FormBoxer" i have column "photo_link" , and in that column i have links. and in new form i need to show photo depends to filter. and my code is <img src="<%=thisman.photo_link%>"></img> and it doesn't show the image in the html-view, only like this http://farm4.static.flickr.com/3443/3845114100_2f52a7b431_o.jpg"> i can't take away last 2 symbols ...why?
Running the right version of Firefox.....
So I know it's already been discussed but I just wanted to say that Zoho Creator and Zoho CRM work horribly in Firefox 3.5.2 As a Web Developer wanting to play around with the new features of 3.5.2, it was getting very annoying not being able to use the newest version. IT'S NOT LIKE I COULD JUST USE SAFARI OR CHROME FOR ZOHO CREATOR EITHER! So now I'm running 3.013 (downloadable on firefox.com) AND 3.5.2. Here's a great little tutorial on how to run multiple versions of Firefox. http://www.command-tab.com/2008/06/18/how-to-run-firefox-2-and-3-simultaneously/
Count time (hours and minutes)
Hi, I've got a form, New request where the staff can put in the time taken to complete the request. The time should be entered in hours and minutes. Is it possible to have a script or function that adds up the hours and minutes so that I can create a monthly report ? Hope it makes sense and thank you in advance for your help. Cheers, Kerry
please help me..need to disable "View Log Details" on my form
please help me..need to disable "View Log Details" on my form
Saving a stateless file
I have many question about stateless files and I am having a hard time answering the questions via online help. 1) How do I create a stateless file for each user so that they can update it like a profile page (as apposed to a record)? I added the custom button and looked through the script. Now I was wondering if there was a simple script that I needed to associate with "on click". 2) I would like to have values in this stateless form that get updated when the "updated" button is clicked. I see
User denied access
I have a user who has tried to get into a creator app from two different accounts. She gets into Zoho, but when she tries to access the app she gets a "denied" message. I've given her full access to everything in the app.
Updating Information through forms
Hi, I have set up a form and attempting to edit the information through the form. While I am able to access the data through the form I am unable to Update only Submit new data. How do I update the information. Thanks.
Dynamic HTML view
Im wanting to embed a view that displays a record based on a field value For example; <div elName='zc-component' viewLinkName='Class_Details' params=' " Where field 'teacher' = 'Mr Baldwin' " &zc_SecHeader=true'></div> This should be ver simple - although I cant seem to make it work - not sure of the sytax However I need to take it one step further... lets say instead of 'Mr Baldwin' being a record in the form the view is based on, lets assume its a related field in another form (related as he would
script in image source
i tryed to show image with link like <img src="http://something.com/someimage.jpg"> and it worked perfectly. but i need: in form "FormBoxer" i have column "photo_link" , and in that column i have links. and in new form i need to show photo depends to filter. and my code is <img src="<%=thisman.photo_link%>"></img> and it doesn't show the image in the html-view, only like this http://farm4.static.flickr.com/3443/3845114100_2f52a7b431_o.jpg"> i can't take away last 2 symbols ... why?
Please help me. Its been 3 weeks.
trying to find out how to disable the "View Log Details " message on a form. when i post my form and test submit with fields filled out, a white bar with "View Log Details " in white comes up. how do i disable that..it doesnt look good on my site ==(
how do you remove "Veiw Log Detais" from a form
how do you remove "Veiw Log Detais" from a form
newbie and reports
Really dumb question but I usually use ms access and thought that I would give creator a go as it gives me much better mobile access. I use reports inacccess how do I achieve that here. I probably need a book as i did in ms access. I looked at the videos but I think there very poor quality
Next Page