Creating a relationship
I am trying to do this by following your Help at Creating-relationship. When I insert the lookup field in one form and open the "select field" box for the other form, there are no user-defined fields available to choose from. Can you provide any suggestions or more detailed help on this?
Importing from Google Doc Spreadsheet
Can anyone give me some hints as to how I can import data from a Google Doc Spreadsheet into Zoho Creator? -I have tried copy/paste -I have tried downloading as csv and importing that file -I have tried downloading as excel and importing that file None will import the data. (Incase it matters, I'm on a Mac) Thanks much.
Display all columns in form view
In form view I am showing 12 columns. I have more columns. In edit mode I went to COLUMN PROPERTIES, edit NO OF COLUMNS DISPLAYED but the changes to not show. I looked in List, Summary and Grid views but no difference.
Can't create view with restricted records where date field equals null
I am trying to create a list view that only shows records where the date field is null. But whenever I check "Restricted records" and set Datefield equals null and click DONE, the criteria is not saved. How can I do this?
Sorting of foreign names of forms and views
Hi colleges, I've notices that a list of forms and views is not correct sorted. It's can be because of the russian names of it. Is it possible to solve this problem. It's quit complicete to find a form (I have two pages of them). Do you plane to translate your application on russian? Without of russian menu and so on for me is hard to present your application to other users. Thanks, Alex
How do I automatically fill the Link URL for an image field?
Hi I have an image field in a form, and I want the URL link (not the source) to be automatically updated by the input into a separate URL field on the same form. How can I do this with Deluge? I can't see a way of referencing the link box as a variable except for enabling or disabling the checkbox requiring the link. Many thanks for any help. Martin
My form view is blank
When I click on my form link, the form appears to load but the application window is blank - no form loads. The Zoho applicaiton window just displays an empty screen with only the "Insert fields" box on view. After the page tries to load, the IE 'Done' message (lower left-hand corner) shows an error which when clicked says "Grid customised is undefined" I have tried all I can think of with no success, on the other hand, this is my first day on ZOHO. The form must be there somewhere, because when
Make Help link in form
Hi everybody! Is it possible to make a button in form (or some kinde of link) to organize help window. It's quit important for complicate DB (I have already 26 forms and for is already too complicate to remember what each of it for) Thanks Alex
Auto fill from database
I am trying to create an application, I would like it to auto fill in the text boxes if I have information in the database for that category. So if I select X from the drop down list and there is information on about height, weight I would like that to be filed in, but if its missing length I would like the left blank so someone could add that information. How do I do that?
Change text color based on criteria
Is it possible to change the color of the text displayed on a view based on certain criteria? Say, if the importance level is less than 11 could I show that as red text in a view?
Back-up Application
I'm trying to back up one of my applications, everytime i try it doesn't back-up and the description say's null. However, I'm able to back-up other applications with no problems.
Getting an error "Invalid entries found. Please correct and submit again." and now changes were made.
The problem looks like this one: https://help.zoho.com/portal/en/community/topic/getting-an-error-invalid-entries-found-please-correct-and-submit-again I spent the whole day trying to solve the problem. I was creating a new form and I was getting the problem and didnt know why. When I tested over other forms, that used to work normally, and stopped to work for some reason. I need help urgently. I sent a support request already. if possible I would like to have a private support response. The problem
Adding Form Data View email with attachments/images
Hi, I am trying to add form data via e-mail with Images. Each email I will be receiving will have eight images and data about a certain product, I can organize the data to be in any specified format for the email template to work. Using the directions at https://help.creator.zoho.com/Email-Data.html#Overview I can only get the data in the email to be entered into the database. Using this feature, how can I import/add the image attachments automatically from the email into the database? Also,
Filling a dropdown list that has an "On User Input" assigned...
Hi, I'm dynamically filling a drop down list with data from records. But this dropdown list also has the "On User Input" action assigned to it. It seems like each time an item is programatically added to create the drop down list, the "On User Input" action is triggered. Is there a better way to dynamically fill in a drop down list? I am filling the drop down list with data depending on what is selected in another drop down list. Also, when this 2nd drop down list populates, it complains that
How to access specific ID
Hi, I want to select a record with the ID and update the record. Lets say the ID is 12345. MyID = MyForm[ID == 12345].ID; MyID.Status = "OK"; This doesn't work for me. It says NULL. Thanks. Markus
Using custom functions on Calendar Views
Dear all, I am trying to do the following: after you select on item from the calendar view, the pop up (built in the zoho) shows information retrieved by a custom function. Is that possible? Could work similar to this ( here) where the user needs to click on the button to call the function but should work on a calendar view.
Getting an error "Invalid entries found. Please correct and submit again."
Hello I haven't done any change to the script recently, but started getting this error when adding or editing End Of Month Commission Report. I think that On Success has a problem, but not even my info messages show before I get this error. Please help urgently, Thanks
My Zoho Creator Contact Form Won't Show in WordPress
The contact form in my Wordpress website quit working so I tried making a new one with Zoho Creator using this guy's tutorial: http://www.youtube.com/watch?v=BPB-kmXoZuo The process went exactly as described, the database was populated and emails received. But when I inserted the HTML code it doesn't appear. However gray link boxes appear next to it with Text, HTML, MS Word, PDF, XML and Print. When those buttons are clicked, a form appears. But I want the form to be embedded in the website.
Blocking new records that have a duplicate entry
Hi, Is there a way to block a new record from being created, if one of the fields is a duplicate entry in another record? In my case I have an application which is focused around collecting information on websites. I wish to prevent new records from being posted if the data entered into the website field is found in another record--same field. Thanks
Broken Hyperlink in Zoho Creator Help Page
Dear Zoho Creator Team, I would like to draw your attention to the page http://www.zoho.com/creator/overview/deluge-script.html which sends a link to 'Perform Form Actions' (http://creator.zoho.com/help/index.html?url=deluge_ref.html&sub_url=deluge/fieldactions.html) but the latter does not work. I have attached a video of my screen in your Facebook page (https://www.facebook.com/video/video.php?v=10150225993716506&oid=171434754759&saved) because Zoho Discussions does not allow me to upload FLV
Share - Sign In
Hi I installed the Zoho Creator from Google Marketplace and now I can not share outside my domain. Already uninstall the service from my google apps but reading the forum, it seems that you need to delink my google apps domain from my Zoho Creator account. Please do so immediately because none of my users can log into my apps!!! Thanks
Is it possible for a user to apply multiple filters at once?
I'd like to allow users to apply multiple filters at a time, without having to create a custom filter for every possible iteration. For example, while working in a given view, the user would apply varying combinations of filters: Combo 1: Status == Incomplete Year == 2009 Cost (>$1000, <$5000) Combo 2: Status == Complete Year == 2007 Cost > $10000 Etc. After this is achieved, I'd like to enable users to save their custom views to their profile and with other users. Is any of this possible?
Custom Languages in Scripts
Dear zCreator Team, In Zoho Creator forms currently I think only rudimentary scripts are allowed right? Can you also consider supporting extended scripting like those MSIL compliant ones? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Data goes blank after changing options
Hi, I created a single-choice question using a bunch of radio buttons to select a bunch of names, e.g. Dave, Edwin, Evelyn, and so on. Data entry had gone on for a while, and I subsequently edited the list to add two more names, and I also re-arranged the existing names so that the choices appeared in alphabetical order. What happened is that the existing data was changed without warning. The assignment of some names suddenly shifted, i.e. all the data values which were Dave were suddenly a different
Consistency in Navigation
Consistency in navigation for both the application and its edit mode would be appreciated. At the very least, the "Home" link should be there in both views. Application View Application Edit Mode John M. Whitney
All applications missing
On signing in this morning to Creator all my applications have disappeared! (About 40+ in total) I am missing My Workplace Apps and Shared Apps options in the user gui: This is the same for another colleague of mine in the same domain. Creator is added to our Google Apps domain but I get this result logging in directly with my Zoho ID as well. Obviously this is pretty urgent! Help appreciated. Kind regards, Mark
upload image
how do i upload a image on my form?
custom report/web page
My customers require information from jobsites to be collected on their own paper forms then scanned in and e-mailed individually and/or posted on the jobsite. All of our customers want the same information collected but all of their paper forms look different. I want to use creator to enable employees to collect data from the field and then generate a page (report, web page, write document...) that can be printed and submitted to the customer. The data collection part through Creator is easy
User setup!
Hi I am trying to learn more about user and the setup of them. I have created a new user for zoho, and shared my appl. with this new user. My problem is that the access, I have given to the user, only shows the header and not the content of the forms. Do I also need to give the user, access to the respectable tables that is used in the dropdowns? BR Skouboe
The Rich Text field component is disabled in the form.
The Rich Text field component is disabled in the form application. Why is this happening?This Seems a bug. I need urgent help! Thank you very much!! Marco Sulzbacher
How to update a field of a parent window from a pop-up window?
Hi, I don't know how to do it the following. I have a form ("main" form) with several fields, one of them called Total_Invoiced. Then I call another form through a Pop-Up window (I would say that is a "child" window) to insert all invoice details and to calculate the Total_amount, once I have done this I would like to return this value to the Total Invoices field of the "main" form. How can I do that? I remember that in javascript you could do this using something like parent.Total_Invoiced
Adding List Elements
I'm attempting to use a stateless form to add new elements to a list in my database. It seems the list in my database cannot accept new elements. Is this a known limitation? PS: In doing this, no errors are reported and the list is not updated. John M. Whitney
Form not loading
My application https://creator.zoho.com/sancher/vouchers contains a form called Voucher. (See attached image of what is seen.) This used to load perfectly well, till last week. But suddenly today the form is not loading. The application contains some reports, which are loading without any issue. Please correct this issue as soon as possible. I've allowed edit access to the application to the support team.
Unable to update data base.
I am having proglems with my account. It appears I get the following problem with all applications in my account. When I go to update any entry in any application I get the following error: invalid entries found. Please correct and submit again. This is a serious problem for me - as we use this data base to manage daily work in my organization. Please Advise.
lookup field with duplicate entries then select one or another to obtain corresponding record information
Hi hope someone can help I have a form (CONTACT INFO) which has first name, last name, email, country Duplicates are allowed for last name (example entries would be) Jon Smith jon@test.com India Jon Smith (no email) USA Jon Smith jon@abc.com USA fred Smith fred@abc.com USA I have another form (book_contact) which looks up surname, I get 4 occurrences of "Smith" which is ok Problem I want to be able to select each smith in turn and fetch the related info to make sure i have the correct smith. I tried
Clicking on a record field to pull up a separate record?
I am not sure if this is possible currently in Zoho. I've been searching the forums but haven't found this particular issue. I am creating an equipment database. So I have my equipment form that has the item, manufacturer, invoice number, etc. I also have a form that has our purchases on it. What I would like to be able to do is to be in the equipment view looking at an item and click on the invoice number to pull up that purchase. So let's say I have an HP computer and I'm looking at that record
Forms in zCreator
Dear zCreator Team, Does Zoho Creator forms allow only a simple flow layout? Can you try incorporating support for custom stylesheets and my own precision positioning the elements? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
User
I have created a user but cannot login as that user because there is no password.... how do I create a password for a user I have created so I can login?
Can not rename List Views or Summary Views...
When I try to rename a List View or a Summary View ... Edit this Application >>> More Actions ... >>> View Properties >>> {change one/both of View Name and View Link Name} >>> Done ... the View Name and View Link Name do not get changed !!! Forms and HTML Views can be renamed. Gaev
Export View data feed in Spreadsheet
Hi, I have a problem with my View CMC RSS Cardstudio, because when I capture the data with Excel (spreadsheet feed) a column called "Pacom válido até" still no importing data and display a blank column. Thanks Mic
Next Page