"Not Duplicate" for Email Field is NOT WORKING
We would check "not duplicate" under options in the edit option for the email field of our form. We tested it by adding a duplicate email and the duplicate was successfully saved. We went back to the edit field and the "not duplicate" box was not checked. We redid this several times. The "not duplicate" status does not save. sheryl
No duplicates
I created a database that has some blank items for future entry. I am trying to make this field - NO DUPLICATES. However it considers the blank field as a duplicate and will not let me force no duplicates. Please advise
Form entry tab order in Firefox
Using the tab key to move between mixed field types works properly in Safari (latest) However in latest Firefox, when tabbing between fields, it skips over any "dropdown" fields and goes right to the text entry (single line) fields. This is a problem because the user needs to be able to use the tab key to move through fields in form entry. Due to it skipping any non-text fields, they have to use the mouse to manually select the drop down field. Hope this is clear, and there is a quick/easy fix.
How can I upadate a decimal/numeric field with null?
When I edit a view, i want that a custom actions upadate a decimal field of the form. I tried that but it doesn't work. I want to make this field "Result" empty. void status.Rerun(int recID) { thisRec = Sample_Receiving [ID == input.recID]; thisRec.Result = null; info thisRec.Status; Thank you
use of Replace functions with special characters
Dear all, I would like to create a script which would identify specific text strings within a field and replace them with XML formatting tags. Say I this specific string is "XML", the tag is "<XML>" I guess a correct use of the Replace function would look like this : replaceAll("XML","<XML>",true) I tried is but the "<"">" characters would not be output. I also tried to use backslash characters in the replace function like this: replaceAll("XML","\<XML\>",true) But then the backslash characters would
Marking Email field as "No duplicate entries" gives false error message
As the subject line says, in a form I have an Email field. When I've gone back into it to set it as "No duplicate entries", an error pops up when I click "Done" which says this: What's curious is that there are not only no duplicate email addresses in the form's data table, but there are no email addresses at all, none. There may have been email addresses in some records at an earlier time in development of this form, which I've since deleted the records containing them. Troubleshooting this,
embeding a PDF in a form
I have a form which has an upload control that accepts PDF documents into my Zoho app. On a separate form I would like to enter information relating to that PDF, but at the same time I'd like to be able to view the contents of the PDF in the same window. Is that possible? Zack
Check the page scroll region
Dear Team, Find the attached file Forms are not fit in browser. Page should show like a dialog and check the page scroll region. Thanks Elango
Bulk-edit limit of 200 records...
Now I can only update 200 records in bulk max. How can I select all records in a view, say 2,000 records, and mass update them?
faxing capabilities
Is there any way to fax files uploaded to creator to our customers directly from the internet?
links between different database
i've a problem with che zoho databases. I would like to create links (relations) between different reports database tables. how you doing? thanks
Change from Chart to Grid doesnt work
Hello, i changed the View from Grid to Chart and cannot change it back, i always get an error from the Zoho Page that it is not possible currently and i shall try later again :(
Cross connect Help Desk to Invoice / CRM
I'm trying to us Help Desk as my point of contact for IT helpdesk related tasks, and I'd like to be able to track customers and bill them based on the work I'm doing in HelpDesk. (i.e. I need to connect requesters to the CRM an bill those requestors) Is this possible? If so, how do I do it? Rich
Once a user makes a melection, how can you display info from another form based on the selection?
Hey -- I have two forms -- one with names, phone numbers, and address. On the other form, I want to have it so that when a user selects a name from a drop down menu, the phone number is displayed for that person (from the first form). I know that it probably has something to do with using "Actions on User Input", but I can seem to get it to work. Also, is it possible for the phone number not to show up once the survey is submitted? Thanks so much -- I'm still learning.
Email > Help Desk?? confused.
Can I have a client email a group email such as "support@" and have Help Desk create a Request automatically?
how to set public access to form
Please, could u help : i can't set public access to my form and private to data. (i've tried everything !) thank u.
Custom Action not responding
I'm having a problem with one of my view's Custom Actions options because it's no longer responding when clicked. All other views are fine. Any ideas?
Permissions Technicians
Hi, I'm testing Zoho Help Desk on a Google apps account, but I don't want to be the Technician, I created another technician, but I didn't see the same menus, is there any section to give permissions? and also I don't want to use my email account as a technician, can it be possible to change technicians? If this is not possible, I was thinking in create another account, but I don't know how to uninstall this one. I hope you can help me.
Problem when trying to Edit Application with Internet Explorer v7
Today, I needed to have simultaneous Access to ZOHO Accounts owned by me and my Client ... so I signed on to one of the Accounts using Internet Explorer v7 ... found out that it has a defect ... when trying to view/edit Custom Actions for a List View ... a) it did not list the existing ones b) when attempting to create a Custom Action, Internet Explorer reported that the connection with the website was no longer available. Gaev
How can I limit the number of characters shown for a column in list view?
I'm just starting with Zoho Creator, and I created a simple form to hold info. Basically, a custom list of contacts. I have one multiline field for misc. info, and this can get very long. I'd like to show the first X characters of this field in list view, with the option to click "Show more" to read the rest. Is there a way to do this with Zoho Creator? Thanks!
Build custom action HTML view with selected records only
I am able to build my Custom Action HTML View with all records, but I only want to build the View with the few records I've selected. I have a line of code in my view to fetch the records that looks like this: <% test123 = info[ID != 0] sort by Release_Date; Obviously my code is acting on ALL of the record sets, but I only want it to act on the ones I've checked in my view. I cannot figure out how to filter based on being checked in a view. Please help.
how can I can launch the "edit record" window ( on a view) with a custom actions?
Hi, I would like to launch the "edit record" window ( the window who appears when we click on "edit" on a view) by click on custom actions. How can write the functions to launch this windows? Thank you Regards.
Editing Views --record specific link from HTML view
Hi Team, I am using a stateless form to generate a dynamic report and HTML view to present the data Data from 3 diff forms are consolidated into this report. I understand that each view has a permalink. But i would like to know if it is possible to locate record specific link. This is what i have in mind. Dynamic Report for STudent ABC (HTML VIEW) ..... data from Form 1 ---- <edit > ..... data from Form 2 ---- <edit > ..... data from Form 3 ---- <edit > <edit>...this link should open the specif
URL syntax
Can you help with the required syntax for the following: I want to create a function that is linked to a view that when clicked opens a new form and passes a value from the view to a field in the form: The view is called 'support_view' and has a field called 'ticket' - the form I want to open is called 'support_note' which also has a field called 'ticket' - it's the ticket value I want to pass to the form. Thanks, Martyn
Drawing numeric value from another table
Hi - I've consulted the Forums on this topic but can't seem to make this work. I have a numeric value in one form - form is Product Information, field "Number" - and I want to import this value into a second form- Product Cost - so that I can use the "Number" value as part of a formula. In the second, "Product Cost," form, I set up a field and tried to import the "Number" value from the "Product Information" form, but I can't seem to make "Fetch" work. In the first form, the "Number" corresponds
Need Help: Creator "Reports" are displaying decimal values as integers and not summing correctly! Help please
I spent the last weekend setting up Creator reports for my organization only to discover that when the reports are generated they have a MAJOR problem that renders the entire Report function UNUSABLE. The problem is that any decimal values being displayed in a Creator Report (e.g. 0.50, 3.5, etc) are rounded down to an integer, resulting in INACCURATE DATA being displayed and summed in the report. Example below.... note: all values shown as integers though many had decimal data, no decimal values
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.
Next Page