Cannot add fields to a form
I have been trying to add new fields to an exiting form. I can drag and drop the fields into the form where I want them, edit the field names, etc. but when I access the application, they are not there. I have tried this with a variety of field types and none get saved to the form. I am able to changing the titles of existing fields. I thought it might be a temporary problem, but it has persisted for nearly a week. I wrote to the support email address, but have not received a reply. The application
How to Hide a Sub-Form
How do I hide an entire Sub Form based on a conditional statement?... Not just a couple of Fields on a Sub Form?
zoho creator data to google calendar?
zoho creator data to google calendar?
how to avoid overwriting
Hi there, I have a form „Leads” with one of the fields „Comment”. When I make a new comment I don't want Zoho to overwrite it, but to add this comment as a new record. How can I do it ?
Create Form with N-field (arbitrary numbers of instances of a field)
I want to give users the ability to list an arbitrary number of fields of a particular type on a form -- e.g., I have a URL field called "Specs" and I don't want to limit the number of "Specs" links that can be attached to a particular instance. How can I accomplish this?
Auto fill based on 2 sets of criteria
I have a database started and have made some headway in Auto-fill. My question is I want to create a form that will auto fill based on two sets of criteria. Currently I have a script written that will will auto fill based on one criteria. I want to be able to be able to auto fill based on the a Client ID and also the Product number (there might be the same product number for multiple clients, this is why I need the script to look at both criteria. this is the script I currently have: if (count(Extinguisher_Locator[Number
the warning for field type changing on new formula field addition
When I add a formula field the warning for changing a field type appears - see the screenshot below Regards, George Baltatescu Zoho Creator Developer
Sorting Pick List generated from Related Data
Hi: I have a Creator Application with several forms. Most of the form need a field that I am using as a relationship. To make things easier for the users I have a Pick List of imported data from the Personal Information Form. Here is the script code that generates the list: ust have Contractor_ID ( displayname = "Contractor" type = picklist values = Contractor_Information.Contractor_ID displayformat = [ " " + Last_Name + ", " + First_Name + " - " +
Ho do i Delete tabs on my App view?
I have 4 tabs that I made while learning how to do reports, Now how can i delete them? Help!!!!
HTML view + css: Chrome [blocked] The page at ... ran insecure content from
Hi everyone, I'm using a couple HTML views to display some contents on my website. The css formatting for the view is processed through a link to a css stylesheet on my server. Everything works fine on Firefox (see for ex. http://www.meridian-online.com/about-us/ -- scroll down), but I discovered Chrome blocks the loading of the CSS stylesheet... According to the developer tools, Chrome detects that this is 'insecure content.' Any way to circumvent this issue? Without the CSS, these views are rather
Focus Traversal in forms seems to be vertical only
I've created a simple two column form like this: But I find that when I use / preview the form, the "focus traversal" is not horizontal but vertical. When using the form, after I fill the value for the left field of the first row, and I hit the tab key, the focus goes to the left field on the second row, instead of the right field of the first row. I think this is not intuitive, and I can't seem to find a way to make focus traversal be horizontal rather than vertica. ¿What can I do about this?
JSON feed does not display all fields in combined view
If we have a combined view and it happens that a field from the related form has the same script name with another field displayed in the view, the JSON feed does not display both fields, but only one. For example, let's say that we have a view based on Kids form The form contains the fields Name , FatherID (lookup field to Fathers form, which also contains Name field) , MotherID (lookup field to Mothers form, which also contains Name field). If in the view I display Name, Father Name (FatherID.Name),
Connect to an existing SQL database/server
Hello Guys, Apologies if the same question has already been asked, but i am having trouble understanding how to connect an existing SQL database to Zoho applications or if it's even possible to do that? Our current system is currently using an SQL database, so we would like to use the existing SQL database with Zoho creator applications. Any advice would be truly appreciated.
Edit data directly
In addition clicking on the 'Edit' icon to edit existing data, I would like an additional quicker way of editing data. Specifically, I would like the ability to double-click directly on any of the data fields of a 'View' which would open the field up for editing. Thanks.
forms and permissions - is it possible
Hi all, I have a question regarding forms and permissions. I have two forms:- People - Project The User inputs data in the form Project. Fields also include fields from the form “People”. When User inputs data in the Field “Name” in Project, he firstly is able to check whether certain person is already present in the database, if yes he can simply add this person to the project. If no he inputs new record, which is automatically copied to the Form “People” User does not have access to People View:
Internationalizing an application
Hi, I am building an app for a recruiting company that takes applications in four different languages (English, Spanish, Tagalog and Hungarian). Is there an easy way to 'internationalize' the app? By this I mean I want to be able to re-label all of the text fields in the appropriate language. My initial thought was to use stateless forms to populate the main form. However, this won't work because I am using sub-forms. The only other option I can think of is to just duplicate the form and change the
sharing form with public
I cannot seem to understand how to allow the public to access an online form I create ... I simply want to create a registration form, then send out a link to the form ... how can I do this ? I am a free member -- does this functionality require upgrade ? I am missing something here, I think :) Thank You Bill Clark kappclark@yahoo.com
Can't edit our apps - Enterprise user - Urgent!
The Zoho Creator app editor appears to be broken for our main enterprise account. The main account holder is Danny Quarrell, dannyquarrell@altaplanning.com. Neither Quarrell or any of our assigned developers can access the app editor for any of our shared apps. URLs such as https://creator.zoho.com/dannyquarrell/form/286/edit/ load blank screens. The editor appears to work fine for personal apps in other accounts (e.g. https://creator.zoho.com/dmoskovitz/form/14/edit/). I tried different browsers
Need to Setup Schedule for Jobs 2 Months Out
I'm trying to use the Zoho scheduler to remind employees of jobs that are 2 months out (from current date). I'm using the custom schedule option. So, I'm trying to first fetch records with the following criteria (in the fetch records GUI): zoho.currentdate.addMonth(2) >= Job_Date1 Job_Date1 is the date field in my Jobs form. It's listed as a "Criteria Fields" in the fetch record GUI, but its not in the "Variables" area of the GUI. I assume that it needs to be in the Variables area which is why
Remove "null" values from email
Hi Is it possible to remove the fields with the value "null" on the email notification that Zoho sent out? BR Dennis
How do I split up applications?
I was just wondering how specific I make an application. For example let's say I have 3 clients. Do I make a single application for each of them them put their appropriate forms in that application? Right now I have different applications for each appropriate "table" and then for each client. So I have applications for "Company 1 Clients" , "Company 1 Staff" and "Company 1 Jobs". Then "Company 2 Clients" etc. Should I just make 1 application called Company 1, then make a form called clients, staff,
How do I enable the 'Import' functionality on a View for a non-developer/admin user?
I can't seem to figure out how to enable the 'Import' functionality on a View for a non-developer/administration user. Is it possible to allow regular users to do this?
Medical Encounter Form
I apologize if this is a repeat, but this is my first time using the forum.I need to create a form to document patient data,but one patient at a time. I do not need to create a database. I need to view the form in an easily readable document, like Word or PDF. I then need to email the document to be included in an Electronic Medical Record. I also want to export it to be included in Zoho Creator or Projects. Thank you
Evaluation: If I can't do this, Need go no Further....
We are still evaluation Creator and have begun to make some basic forms and views and reports. I have been very impressed with the power of the app and very excited to move forward. But the following is the main requirement, and if we can't do this I cant see any need for going further. We create a recipe and add ingredients. we know the percentage that ingredient represents. We know the cost per lb of the ingredient. We know how much the total recipe represents and therefore we can calculate the
Medical Report
I need to create a one monthly report for each patient, then email it (or print it) to a referring doctor. The report has multiple fields, which I created. How do I create a full 1 or 2 page, easily read report for EACH form submission, and export it?
Updating lookup
Can someone help with a bit of coding please? I have two forms - 'Postcode Lookup' and 'Job Booking'. The 'Postcode Lookup' form has just two fields, Company and Postcode. There are approximately 100 companies in the data, but only 10 or so postcodes. On the 'Job Booking' Form I have a lookup field which searches the Company data and if it exists, populates a Postcode field on the 'Job Booking' form along with the Company. There is also an option to add a new company if it doesn't exist. As many
Email by changing the content dynmically each time by Using Custom Actions of another form or view
Hi, I have a question related to Email by changing the content dynmically each time. I need to send Email to the selected email id's in a field of a view, As if a select the option to send email that shoul be routed to a sub form(which has all the options a email page does have) where the... To: will be all the email id's selected(email id's should be copied from the master view) Sub: which i can dynamically write each time i sent the mail Attchments: If required. Body: body of the mail(can
Link Apps each other-Zoho Creator CRM
Hello I created 2 apps forms wich works extremeley well, but later i found out in the Market place app a zoho creator CRM, Now i want o include this 2 apps and connected to thiz ZOHO creator CRm app, Anybody has a sugestion how to connect Apps or Forms ? Thank you
Product Order Entry Sheet
Hi all... first off, Creator has a lot of potential! Please continue with your efforts! My question -- I'm looking to create a simple product order entry sheet which lists the products available, then has a text field next to each product line for the user to enter a quantity. When complete, the database will be updated with the products and quantities of each line where the user entered a quantity. Any product line where the order quantity is blank or zero will not be added to the database. Any
Populating data from another field
Hi All I'm trying to populate a simple new form with just three fields with data from another. I've have followed this thread: https://kbase.creator.zoho.com/records/populate-one-form-with-data-from-another-form but I just get errors along the lines of - { expected where temp - The first Field in the new form is a lookup field which relates to a 'Job Number'. When the user chooses one, I'd like the Client and Contact information to be displayed. What is the best way to achieve this? Thanks Nick
Referencing different table field from lookup field
Hi there. I am loving zoho creator but have a question. I have a simple form called 'task' used to input some data. One field called 'employee_name' is used as a 'lookup' field to select an employee from another 'form' containing employees and some of their info (phone number and email). Within the 'task' form I would then like to store the employee's email address in order to send him a message 'on add' or 'on update'. I would reference the 'employee_email' field using the same primary key that
Can i use an multi-form report
for example. I have restaurant winth dishes of two foods each. Therefore i have to create three forms: 1. "foods" Contains fields "name"-txt and "price"-currency 2. "dishes" Contains a field "name"-txt, fields "food1" and "food2" which are lookup links on the foods.name 3. "sales" Contains a field "dish" which is lookup link on the dishes.name and a field "number" is integer. i want a report which can show me a total data where number of sales is multiplicated with price of foods smthng like (sorry
Max file size for "file" field
I tried to add a file to a form. The file size was 7M... it failed to upload? I read somewhere that the file size limit is 10MB each?
Medical Encounter Form
I need to create a form to document patient data,but one patient at a time. I do not need to create a database. I need to view the form in an easily readable document, like Word or PDF. I then need to email the document to be included in an Electronic Medical Record. I also want to export it to be included in Zoho Creator or Projects. Thank you
using the Adminuser varible
I have an application that I have set up a form to view only the loginuserid as a variable. When I set this criteria in the form field, it also locks me out of editing anything in that form base on the zoho.loginuserid variable. Since I am the admin, shouldn't I be able to edit and view all records in the application? Is there a way to tell the application that I am the admin? The form has an Employee ID field that the loginuser can only fill in their ID. Since I am also an employee, my own ID appears
Custom domain for zoho creator app
I am creating an app for the workplace of a large company. Unfortunately, it is like working for the government and I cannot convince the enterprise security folks that zoho does not pose a threat to their security and they have banned the zoho.com URL via their firewall. So I am considering whether or not I can use a private domain access to zoho in order to access a creator.zoho app. I believe that if the app were accessed through my_domain.com in some way that things would work. Am I understanding
Criteria Help
Hi All Fairly simple one I think... I have created a lookup field on a new form. I want to set a criteria so it only shows values from records that are invoiced. i.e. I have a form with lots of field, one of which is 'Invoiced?' - simple Yes/No. On the new form I want to look up the those records, but only show records which have the Invoiced value of 'No'. The lookup is a different field by the way, not the 'Invoiced' one. Hopefully that makes sense? I'm not familiar with Deluge, so what do I put
Can I do a lookup on a lookup?
I have a database of client names. From that I have a lookup field on another form, with the ability to add new clients. I would like a third form with a lookup field from the lookup field of the second one so that I can populate the data from the other fields from the second form. Is this possible? Thanks Nick
Archiving Projects
Hi I have a Form which is my 'Projects List' I can create and Manage my projects but once the project has completed its lifecycle I would like to 'Archive' that project(Record), I have seen posts on how to move the record from one view and add it to another but if i do that would'nt my lookup fields in my forms still see the record as its still using the underlying Data? Should I just create a separate form with all the same tabs and then create a task that would move from one to the other? is this
subforms view only one linked field can be displayed
Seems that you can only show one field of a subform in a view is this correct ?
Next Page