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
Error on creating new application
I am getting an error when trying to create a new application. I name it and click Create then "An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused." Any ideas?
Tooltip not working?
Hi, The tooltips to my form fields have stopped working. I can't see any of the instructions I've put in for these fields. Has anyone else got the same problem? I'm using IE6. Cheers, Kerry
View does not sort properly
Several views over same data no longer sort properly after addition of only one record. The record appears in the first position but shd be near the bottom. This feature had worked well before latest attempt to add data. Zoho newbie ps: Only after the newly added record was deleted and re-entered the sort appears to be working properly once again. This is a STRANGE bug since everything else was tried prior to delete & re-enter.
Is it possible to order custom filters?
Hi I have a list of custom filters however they appear in a random order and I would like to order them somehow, perhaps alphabetically- is it possible to do this? thanks
HTTP API access through Flash
Hi, I was trying to build a cockpit with some Flash goodies. However it doesn't work. I found that on the Zoho Reports forum this matter was discussed in topic http://help.zoho.com/portal/en/community?ftid=2266000000029762. Due to some security concerns, HTTP API access through the Flash is not possible right now. We will keep the community posted once we take this feature. Sorry for the inconvenience caused. Any change we can have this soon? Ivan
Saving new views is very buggy
Any tips for getting them to save? I get an error every time I try to save a new view or save changes to a view.
Maximum of MB in attachment!
Hi I would like to know if there is a maximum of 5 MB on attachment in ZC? Is it possible to expand this to 10 MB. We attach a lot of e-mails that is between 5-10 MB? BR Skouboe
how do you remove "Veiw Log Detais" from a form
how do you remove "Veiw Log Detais" from a form
Empty Dates
Dear Sirs, I wish to do a picklist of all the values I have in a field where the date has not been filled yet. However I'm not able to search for null or "" or Empty dates. The Script I'm using without success is: AWB ( type = list values = Control_Valijas[(Fecha_Arribo is null)].AWB ) Do you have any solutions to this issue? Thanks for your help...
Sorting a picklist via code
Hi, I am populating a picklist via code, and am wondering if it can be sorted via code to? Thanks, Leo
Nested
Hi again, I have a table "Tasks". I'd like to be able to make tasks nested. I'd like to have a field that is a lookup on the Tasks form itself. Eg. I'd like the Tasks form to look like this: Task ParentTask Wash all dishes Wash cups Wash all dishes Wash plates Wash all dishes Wash bowls Wash all dishes Rinse cups Wash cups But as far as I can tell, this doesn't seem to be currently possible? When I try to
System Variable to Identify Parent URL of Forms and Views
Hi: I have a Project where the requirement is to ensure that an HTML View be embedded within a web page of a website ... but should only be rendered if embedded in a webpage of a specified website. In other words, if the iframe snippet was copied (pirated) by another website, the content should not be rendered. There does not appear to be any control mechanism built into ZOHO Creator to do this. But it could be accomplished if Deluge Script had access to a System Variable (e.g. zoho.parentURL) which
"Copy" an application - data too ?
A copy was made of an application under development. The purpose of the copy was to preserve existing data while allowing testing & modifications. Apparently the data from the original app is NOT copied into the new app. Is this true? If so what is correct procedure to populate the new (copied) app with data from original while preserving original data ? Thanx. Zoho newbie
File Upload Field does not behave as expected ...
Hi: I setup a Form with two fields ... File Upload field called Upload_This Single Line Text field called Field_Content In the on User Input section of the Upload_This field, I have ... input.Field_Content = input.Upload_This;It appears that while the widget display gets updated properly when a file is selected by a user, the content of the field input.Upload_This does not ... it is very erratic but mostly it appears to be a step behind i.e. the previous value of the widget display ends up in the
Next Page