Two column layout
Hi All, I would like to have two dropdown lists on the same line, ie hours and minutes. I have never tried the two column layout before but if I select this option and add a field, the system places it right at the top of the form in the second column and not next to the field required. What am I not understanding here please? Many thanks
target="_blank" issue
Hi Folks, There appears to be a problem in Add Notes. To allow a user to get the geographical coordinates of a location, in my application I have a Note field that contains a Google Maps image and the following code: <a href="https://maps.google.co.nz/?ll=-41.343825,174.089355&spn=14.262413,33.815918&t=m&z=6" target="_blank"><img src="http://www.precisionhelicopters.com/images/site/googlemaps1.png"></a> Until recently, a click on the image nicely opened Google Maps in another browser tab, but now
Unable to Customize Embedded Forms
I have a set of forms which are colour coded for specific teams to complete. I have therefore been trying to format the Header & Footer BG colour setting. I have tried this several times with different forms, but the setting is not saving on the form. When I got back into the form, the settings have reset back to defaults. I cannot see any way of saving these changes.
does zoho creator compatible with visual basic?
because now i'm build a system that need to connect with online database...hope anyone can answer me :) Thank you
Summary View Save to Excel
Is it possible to save an individual summary view to excel file? We're expecting an individual output like this Thanks!
Is it possible to concatenate parameteres in iCal URL?
Hello, I have successfully made view data available with iCal. For example with these parameters: DTSTART=datumtijdaanvang&DESCRIPTION=Docent&SUMMARY=Cursustitel&LOCATION=Locatie&DTEND=datumtijdeinde What I would like to do is use two fields from my view to be combined as the iCal DESCRIPTION For example: DESCRIPTION=Docent+Cursustitel But unfortunately combining parameters with this syntax doesn't work. As a workaround I now have an extra field in my view that I automatically update when data is
How to copy data from text field to lookup field?
I built a new form in Creator with a State lookup field which relates to a State table that contains all the US state codes. My problem is that the contact data I need to import from Excel has the State data as a text field so when I went to import the data the records fails on a data mismatch regarding the state field. After reviewing other similar questions I created another field to store the text state code value but I can't figure out how I can bulk update the real state code field (that's
Help with Dynamic Picklists in Subforms
I have a form that are people that attend my class, for each person I have a first name and a last name field. On a seperate form I have a Class, each class I teach has a specific record. I am trying to create a roster for my classes. I have built a form for this and have a subform for adding the students. I would like to pick the last name first for a pick list, then have the options for first name filtered to show only records with that last name. I can get the last name populating correctly
Hiding the red asterisk in a mandatory field
Does anyone know how I can hide the red asterisk in a form field that has been made mandatory? All fields are mandatory in my forms. That's how I want them. I just don't want the red asterisk to appear. Thank you in advance to anyone who answers.
ZOHO Layout
Hey guys. Im new here. I was just wondering. Can the layout be change? I mean the interface layout.
Problem displaying images in a report on Firefox on Mac
Hi, as mentioned in the title images are not displayed in the report of a form under Mac OSX using firefox. It is working on Windows with Firefox, IE and Chrome and on OSX with Chrome but not with Firefox. I'll attach Screenshots for you. Can you help me with that? Thanks in advance!
Calendar embed view does not have forward and back or month name
I embedded a calendar view and allowed editing and adding events. In the embed view the top ribbon is blank, there is no arrows to go forward and back through months and the month name does not appear. I can't find any options to set this. How can I make the embed view look lthe same as the view within the app? Thank you
Filter Picklist by shared status
Does anyone know of a way to filter a name picklist to show only those people you have shared access to your application? To clarify, I have a form, emp_list, which contains all of the employees for our company with their correponding email address, which is their zoho.loginuserid. I would like to filter the employye list in the lookup field so that only users that are active in the application show up. Thanks
Clearing Picklist Record On Load
I would like to clear a static picklist record on load. I want the record to be lose whatever it had before and have no selections. This seems simple, but I have not come across a solution that works thus far.
Donation wish list
Amici, I'd like to create an online donation list in a sort of dynamic form. I"d like to create it somewhat like a wedding gift registry site: There is a whole list of objects needed by the organization, let's say Teddy Bear, Car, Lego... Then people start to register and choose one (or several) of these options. Now anytime someone ticks a checkbox of an in-kind donation (e.g. Teddy Bear) it should be hidden for the next person checking the form. So the next person could only select from the rest
Check box automatic populating issue
Hello I have a check box in the first and second view of my database. With existing records if I uncheck the box in the first view it does not reflect in the second view. Please can you advise what deluge script I should use? I’ve used a “ input.Commercial = main.Commercial; ” script which works with new records, but if I uncheck the box in the new record in the first view it still does not reflect in the second view. This is also the same with date fields. Thank you very much.
HELP Adding Delete button in a public FORM
Hello and thanks in advance if someone can help me. I work in a University and I often prepare public forms to permit students to book in activities. I need to add a delete button to allow students (If the student change idea) to delete from a subscription. Is it possible and could you explain me how to do it ? Thank you very much for an ipotetic solution. Diego
How can I add a DELETE Button in a public form ?
Hello and thanks in advance if someone can help me. I work in a University and I often prepare public forms to permit students to book in activities. I need to add a delete button to allow students (If the student change idea) to delete from a subscription. Is it possible ? Thank you very much for an ipotetic solution. Diego
Issues today
Is anyone else having issues with creator today? I have functions that were working this morning, that no longer work. I am having issues with reports pulling up and running after I have created them, and shared users can't pull up new reports. I have one user that can't access any pivot table reports, lists are okay (this is about two weeks old at this point).
Two small animated semi-circular arrows appear after updating a field by script. ??
If I check user input (On User input), format it, and then write the formatted data back to the same field, two small animated semi-circular arrows appear to the right of the field and the field contents persist into the next record. I can't find any reference to this in the documentation. Can anyone help/explain?
URL view criteria involving lookup fields
I have a view that contains a lookup. The lookup refers to an ID in another table(form). I'm trying to open the view with criteria which only displays records where the lookup has a certain value (an ID): E.g. openUrl("...#View:MyView?MyLookupField=1234567890); The functionality based url criteria seem to work fine for non-lookup fields. Can anyone confirm if this works at all with lookup fields? If so, what is the trick to work. Thank you
How to delete applications?
I've create two dummy apps in my account for evaluation purposes. Now I've got paid subscription and I'd like to delete those 2 apps and create a fresh customer facing app from scratch. How do I delete the exiting apps in my account? Thanks, Vijaya
Indentation
There has been some discussion in this forum about the editor/compiler and indentation. Some people don't like automatic indentation. My suggestion is this: whatever automatic or non-automatic indentation is provided, please at least leave my indentation alone! Yesterday I spent something over an hour going through a long script adding comments and indenting sections of it to make it more readable, just like any good code does. I saved it, but then when I came back to it all my careful indentation
Yet another question about dynamic lookups
I have two tables/forms: Franchises and MasterFranchises. Each has a field named Franchise_Name. The forms are identical except that the Franchise form also has a field for MasterFranchise. All franchises are "owned" by a master franchise. In some other forms, I have a Franchise field that looks up franchises in the Franchises table. So far so good. But in some forms, I would like to have a Franchise field whose picklist is a combination of both franchises and master franchises. Is there
Account address to post in contacts
Can you develop a quick and easy way for Account address info to copy or be posted to contacts, it is time consuming to have to enter that info more than once?
existing study id
So I have a form and have uploaded 160 study ids into this form. I want to be able to enter data only for these study ids and also have other people add data to these study ids. How do I show the study id? For example in an access db you would just go to the next id enter data then select the next id. But I am new to zoho and don't know how to select the study id. Currently it is a text box field. do I need to create a dropdown box with all the studyids? Then I can write a script to excluded the
Performance REALY SLOW!!!
We are using a html view that has been in place since Feb, but over the past two weeks the performance of the HTML view has gone from 3-7 secs to load upto anywhere near 3 minutes!! This is particularly evident around 3pm UK time. We checked the obvious things and broadband but need some answers pretty sharpish. I've included the customer on submission so they understand some of the frustrations being experience by your customers. Please advise.
What is a User?
Using Zoho Creator, we are starting a sports fantasy league. Individuals will sign-up to participate. Are each of those individuals considered a user?
Need help on sendmail
I am trying to use the sendmail function to send an email to the person that a task has just been assigned to. The form is New_Task. The table with the employee information is emp_list. I have a lookup field from the New_Task form to the emp_list that pulls up a function field concatname which combines the last and first name. Here is my code below, please let me know what is wrong with it, thanks. { assignedtaskemail ( type = string ) assignedtaskemail = emp_list[concatname = input.emp_list1];
Nested checkbox list
Hi, I am wondering if it might be possible to accomplish the following through deluge and a standard form (seems you can do it as a html page but I'd rather not go there). I have a set of checkbox lists that look like this Checkbox 1 Checkbox 2 Checkbox 3 Checkbox 4 These items are not hard coded but rather are dynamically added from a table in the application. What I need to be able to do is to nest some items under each checkbox. So for example, if you click on checkbox 1 you would see something
File Storage Options
Is it possible to use the file upload more like a virtual drive, where files can be easily aggregated through copy and paste function and then linked from fields in the form?
Create a relationship between two records?
Hi pals, I'm building a marketing content inventory application to keep track of all the content my marketing department produces. (Brochures, white papers, case studies, etc.) One way a content department makes itself more efficient is by deriving one piece of content from another. For example, if I write a 3-page white paper, I can derive a blog entry and a newsletter article from the white paper with very little effort. Each one of those items are a "content item" on their own. They're all entered
Pivot tables not showing correct field values
I have a magazine application with two basic forms: article and issue. The issue contains four fields: IssueID, Month, Year, and Issue. Issue is a formula that combines all three fields to display something like "302 May 2014" Article references the Issue field so that every article has a "302 May 2014" like field, depending on what issue it belongs in. When looking at a report of every field of my articles, they all show that format under the "issue" field. However, when I create a pivot table totaling
Loading image in HTML view.
When a user is looking at the view there is a custom action that loads an HTML view and loads all the info based on the value. Everything works fine except the image. For some reason the image is just a broken image and I cannot figure out why. Here is the image link I am using <img src='https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=job.Art%>&sharedBy=zoho.adminuser&appLinkName=XXXXXX&viewLinkName=XXXXXX'> What view do I need to put in the viewLinkName? I have been using the default
Column limit
Hello, How many columns can I have in a zoho creator database? Is there a page with all of the limitations and/or specifications? Thanks. Iram
Concatenate Issue
I am attempting to combine a fixed text string and two number fields into a formula field. The fields from the form are Number and joblist. Number is calculated as the greatest value of number +1, while joblist is a lookup field for job number. I used the following code: "H13" + Number + "-" + joblist The formula result is: H133614-1619928000000252808 Everything to the left of the dash is correct, the number to the right should be five digits and is nothing like what is represented. Thanks for
How do I display the sum of a column in a page?
Hi, I want to put a sentence in a page that says "Your balance is x dollars". x is the sum of a column named "budget" in a report. I'm sure its a simple thing for those who know how to use deluge. Thanks for any help you can give me. Caz
Question about error message I get when I use filters in "Create Dynamic Lookup"
Hi, I'm quite new at Zoho Creator, I like it so far. I have a certain knowledge in mySQL and PHP but not enough to develop my own CMS. ZOHO is perfect in my case. I'm building a simple data structure for a project I have with 3-5 forms to organize my data. In one of them I need to create a drop down that contains only the results associated with the previous drop down. In my example, I have 3 applications: - Clients ( simple name of the customers ) - Filiales ( french name for branch ) - Panneaux
RELATION OF FORMS
HELLO PEOPLE. I AM NEW HERE. Zoho Creator is one of the coolest things I've seen in the last 10 years. I saw how that funicona, but I'm doing something wrong. See with is simple. I have a table 1 (Form 1) - Registration of equipment MODEL EQUIPMENT INVOICE SERIAL NUMBER (SINGLE) START DATE OF OPERATION I have another table 2 (Form 2) - Registration Problems DATE OF ISSUE SERIAL NUMBER OF EQUIPMENT I need data from one table to appear on this form when I enter the serial number of the equipment ....
dropdown data creating merged categories
I'm creating an app to inventory my marketing content. A piece of content can only be one KIND (e.g. datasheet, brochure, white paper), but it can have many audiences (e.g. CIOs, CEOs, CFOs). The form that I've created uses dropdowns to select the audience, and the user can select more than one. However, in the reports, the system is creating merged categories, instead of listing the assets twice in each category. Here's what I'd like to see: AUDIENCE = CFO Assets A, B, D AUDIENCE = CEO Assets A,
Next Page