Editing Excel documents that have been uploaded.
I need to be able to edit an Excell document that has been uploaded. Is this possible? I keep getting a permission error and haven't found a way around it. Thanks for the help.
Edit uploaded Excel 2007 spreadsheet from a view
Is there a way to edit an uploaded excel spreadsheet fro a view? I get a permission error when I try to save it. I just want to update the uploaded spreadsheet from time to time. Thanks for the help
Public Forms - Still not working
I did send teh request from the form and received confirmation went back in and copied and pasted the code and that is when the problem began that when I logged off of zoho the form was no longer publicly accessible online. The answer below does not help me because I already followed every step your website provided. Is the problem because I have a free account or because I toggled between two accounts on one computer? I cannot see the form on another computer either. The form is here: http://www.stormhavendesigns.com/MBN/edit/groups_form.htm
Internet Explorer open URL in new Window issue Fixed
Thank you for your prompt response and fixing of the Internet Explorer open URL in new Window issue yesterday. Keep up the good work.
How to populate a combo box from database table on Edit/Add?
I have a simple application that has 3 fields: 1-Task Name 2-Person Name 3-Cost When I go to add or update a task, I want the data for the Person Name to come from the Person Names already added in the application (better yet from a separate person table)... So on Add/Update Load event of a form, do this: A-Have the Person Name as a drop down B-populate the drop down list from the result of a "Select Distinct [Person Name] * from the entire data table" I can do A, but B does not work since I can't
How can I do to make appear a value of a chosen record from another form (lookup field, single select) in a field of the current form?
In my form ("sample_receiving"), I have a lookup displaying every sample types from the "sample_types" form. I can choose one. In the record of a sample type, there is two values (float) that i would to make appears in the "sample_receiving" form, after have chosen the sample type by the look up field. How can I do? Thank you.
Omitting pictures in the view that have not been uploaded.
I have built an upload form that will upload pictures to a specific size using the formula field. This is the formula that I'm using: "<img src='http://creator.zoho.com/DownloadFile.do?filepath=/" + Picture_1_Upload + "&sharedBy=" +zoho.adminuser+"' alt='Display Uploaded Images in Zoho Creator' width='320' height='240'/>" With this everything works as it should except when a picture is not uploaded there is a 320x240 blank square in the view of the form. I have 4 fields for pictures but at times
How to send an application to another user so that he could maintain it.
Hi I have a question. I have developed a simple application composed of 1 form and 1 list view. I want to send this application (as-is) to another Zoho user so that he becomes the owner of it (he can change it or even delete it) How do I do that? Thanks. Emmad
adding new field
Have been using a new app and want to add a new field. Dragged it in, named it, and click "DONE". But field is not appearing in the new app form. Have tried numerous times. CREATOR seems to not want to add any new fields.
Making a new printable list from spreadsheet view
I'm betting what I want is simpler than I know--however, I have been searching for weeks now. I do not understand scripts or functions, so most of what I'm reading is going over my head. None of it seems to apply. If there is a thread that already discusses this, please post the link for me! :) Okay, here's what I want to do: weekly I enter store sales data into my Form. I then go into the Views, create a new one and filter out just the specific content (Store name, week, sale) that I want
help
hello. my name is ben and my research group is aiming to deveop a website that will manage records that will be submitted by multiple users. and im wondering if i can use zoho to store the records in the database at the same time manipulate it on offline mode. there is also a prcoess wherein the the input that will be sent by the users will be stored on a temporary storage and will be filtered by the administrator of the application. can zoho do that?
Feature: Browser tabs should display VIEW NAME (useful!), not "Zoho Creator <Your Org Name>" (useless)
I, like most developers while working w/ Creator, keep several browser tabs open at a time, each w/ different Zoho views, forms and editors displayed. But, when you look up at your row of browser tabs and all you see is "Zoho Creator <Your Org Name>" repeated several times... it's useless. BUT, if the tabs were to display the NAME OF THE FORM, VIEW, or EDITOR displayed instead, then that would be really useful (and easy to implement on Zoho's end). Otherwise, I'm constantly clicking nameless tabs
Run a Excel calculation using input value upon action then output the result.
Here's what I am looking for. user fills out a form. then we have a blank box and on the right hand side we have a "calculate" button. as soon as the calculate button is pressed it will bring the user input values to an Excel sheet Excel sheet will look up on MS ACCESS file to translate the user input values into a number then do calculation then the calculated value in "certain" cell will be outputted into the black box. would it be possible to do it with ZOHO creator? because from the maintenance
Creator App using Project API
I am using the Project API from Creator. I am trying to get all time logs (timesheets) for all users, but I am only getting the logs for myself. The "ticket" that I have created for the api is using my userID/password. Please help - this is a critical requirement for my application.
Is it possible to have a realtime updation of graphics.
I have a question regarding real time updation of colour of certain graphics. For example, suppose that I own a lodge having number of rooms. Customer 'ABC' is booking a room(i.e.room no. 10) from Delhi at the same time another customer 'XYZ' is booking the same room(i.e.room no. 10) from Chennai. Now the problem is that if customer 'ABC' booked the room(i.e.room no. 10) one second before 'XYZ'. How can a booking agent at Chennai come to know that the room is booked, so that he can tell customer
I would like to give a initial value to a Lookup (multiselect field) dynamically from a user input.
In my samples form, I have a look up field sample type, from a sample_type form, which displays the name of all sample type in a single select drop down. In the same form (samples), there is a look up field parameters, from a parameters form, which displays all parameters, in multiselect list. But, in the the sample_types form, there is already a look-up parameters field from the parameters form, which displays all parameters, in multiselect list. A sample type has already the the parameters chosen.
If selected a value, a field must appear
The case is this.. I have Field 1, Field 2, and Field 3. Field 2 and Field 3 are hidden... Field 1 is a dropdown box and has values of: Name 1, Name 2, Name 3 Now, what I wanted to do is... When a user selects Name 1 in Field 1, Field 2 will appear.. And when Name 2 is selected, Field 2 will appear.. I can't seem to do it with this code.. if (input.Field1 == "Name1") { show Field2; enable Field2; }
How to get submitted application data to another application?
I have two applications and I need to take a list from the first application to insert into the second. How can I do?
How to login from my domain to Google Apps mail using zoho creator ?
hello, I want to setup a login form in my website where people will enter their google apps login to access their google apps mail. How to do this with Zoho creator forms.
How to only display a URL link to an uploaded file if only one of the four is actually uploaded in the form?
I have a form with 4 optional image uploaders. When the form is submitted it emails the input of the form fields and 4 links to the uploaded files. What is the script to only display the link in the sent email if for instance only 2 images were uploaded instead of 4?
Custom action on view
I want give the option to users to edit a field (radion button, with two choice : "Approved", "Not approved") by a custom action on a view. I want to change the Status "Not approved" by "Approved". I wrote this function : void status.Approval(string TheStatus) { if (input.TheStatus == "Not Approved") { input.TheStatus = "Approved"; } info input.TheStatus; } I added this function to my view : custom actions ( "Approve" ( function = status.Approval(Status)
How can I transfer data to another database upon user action?
Hello, I have two request form databases managed by separate administrators. If a user fills out a request on one form that does not belong in this database can I have a funtion that will auto send this specific request form to the other database? For example, if the two forms are managed by separate administrators and there is a field in the form that administrators can sign-off that they are handling that request -- can i create an action on that field so that whenever another administrator
Spacing between Questions and answers
HI, Recently, a large horizontal gap or space started appearing between the questions and answers in my form. It makes it extremely awkward to use. Is this changeable? Does anyone know why?Any suggestions? http://creator.zoho.com/jmarzluft/owhl-statistics# Thanks, Jeffrey
Automated application documentation
I've created an application in Zoho Creator - a whole lot of forms, views, custom actions, functions etc. While the application is shaping up quite well, I've begun to realize that I have not created any documentation on the application software. Without documentation to fall-back on, I can imagine life getting quite messy down the line. I believe the Zoho team can come up with a simple solution for this. The fields, forms, views along with their actions (on load, on submit, on user input etc) are
Internet Explorer 7 open URL script commands failing
As at this morning Australia time, all of the open URL in window functions using Ineternet Explorer no longer work. Why is this? My customers can no longer get all of the features from our site. I am loosing business. Should I put this on the forum and let everybody know not to spend $ 10,000 developing a Zoho program because it may work just fine to begin with and you will wake up one day and for no reason it will not work anymore. It still works perfectly in Firefox but because around 60% iof people
Open Duplicated Records in Edit Mode
I'm tracking certain items where new records often are the same as old with the exception of a change of date or other minor difference. It would be useful for the duplicate function to open the new (duplicate) record in edit mode so that I don't have to scroll around looking for it after it's created. Thanks.
Help.....!!!!
I don't know if this is possible but in my database i want to show a spilt between two employees like if they worked on a project together and recieved money they would spilt it. So what i want to do is have a button or a check box that when i click it..it will spilt that cash and is shown for each individual on there own seperate record. Is that possible or is there something close to that. If so can somebody show me how.
Cannot use passed parameter while setting new variable in HTML view
Although it seems to be this is one of the most basic things one might need to do, when I try to use a passed parameter in an HTML view to set a new variable, it says the the parameter is no declared. Am I doing something obviously wrong? If I want to declare a variable, I use "set variable", right? Then if I click on the parameter under "variables" in the script builder window that pops up, it says it's not declared. Please, I need help on this asap.
Page Error from Private to Public
I wouuld like to change from Private to Public, but when I try it there is a page error, so I can't. Could you please help me? Thanks in advance!!
on update ....can not make it work....About to dump zoho.
Hi, I am almost giving up witht he On Update command. I am trying to update fields that I called out and following the example and I can not make it work. I want to query using the serial number and puplate the rest of the fields (that pieces is working) but then I want to be able to modify such fields and update them back ino the DB,......... that piece is not working. here is my complete code in case soemone can guide me.... form Actualizacion_De_Players { displayname = "Actualizacion
CANNOT IMPORT DATA
For some reason, every time I try to import data (either CSV, XLS, or even pasting it into the form), when I hit 'OK' the page just does not post correctly. I tried the same file on multiple PC's and get the exact same result. This problem seems to be new, since I was able to import data 1 day ago. Did something change with the 'import' function? Any help would be greatly appreciated. The 'page' erros are below: Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT
I would like to give an initial value to a lookup field (multiselect) dynamically.
In my samples form, I have a look up field "sample type", from a sample_type form, which displays the name of all sample type in a single select drop down. In the same form (samples), there is a lookup field "parameters", from a parameters form, which displays all parameters, in multiselect list. But, in the the sample_type form, there is already a look-up parameters field from the parameters form, which displays all parameters, in multiselect list. A sample type has already the parameters chosen.
Why doesn't the Help topic for open Url tell me how to open a view while passing more than one parameter.
I need to open an html view, and pass 4 parameters. I see that I can pass one using the example: searchUrl = "#View:Employee_Search?searchParam=" + input.searchEmployee; openUrl(searchUrl, "same window"); But what about when there is more than one?
Remove the logo zoho creator applications using iframe
It is possible to remove the logo zoho creator applications using iframe. See attached http://img64.imageshack.us/img64/6827/reqw.jpg
Can a numeric field generate a number by itself?
I want that a numeric field generates a number, and iterates it. Also I would like to give a special number format, like : YYYYMMDDiteratednumber. Is it possible? I went through ZOHO creator tutorial, but i didn't find it. Thanks
Auto numbering
Hi, can soneone describe in simple terms how to auto number a field. Thanks
Create a View/Report?
Hello - I just switched to the paid version of Zoho Creator and am trying to figure this out. can someone help? I have a form that contains a drop down field with 4 options: AAA BBB CCC DDD I am attempting to create 4 individual reports or views that are password protected and based on the selection of either AAA, BBB, CCC, or DDD. (So you can view all the records that include one of the above selections) This is simply a commissions report Can anyone assist?
All forms form one application migrated to another application
Can I easily migrate all the forms/views from one application to another? I am trying to consolidate several applications into one......
Doc in PDF?
Is it possible to get a PDF version of the userguide, developer guide, and other documentation?
Hiding records from users when searching and viewing
Hello, I've done several searches on this but have not found an answer. I currently have a database into which the public can add records. I want a public view where only certain fields will be searchable and viewable, and I know how to set that up. However, when a user does a search I want only the records with a certain value set to "yes" to be shown to those users. Let me explain why. The database will allow users to add their own entries, but I want to verify each entry before it is
Next Page