openURL - popup window works but same window and parent window do not
I have multiple stateless forms embedded in my website. When the first form is completed the user presses a button which is supposed to load the next form. I am using - openUrl("#Form:Client_Information_SL?Client=" + input.Client_search, "same window"); behind the button. When I click the button which runs the openURL command nothing happens. If I change "same window" to "popup window", the correct form is loaded as a popup and overlays the previous form. In other words, the "popup window" parameter
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
Criteria in a view of a form with a subform
Hi all I have a form (treatments) with a subform (payment cards). In the subform I store each card payment. One of the fields is the due date of this card payment. I want to show in a view treatments that have their overdue payment last letter (dated before today). The problem is that it shows all the treatments that have some payment card with the date before today, instead of displaying only those with the date of last treatment before today.
Bug: Red line covering on-click
This is under my other account: sigroup/si-ni-chemical-inventory using IE 9.0.8112.16421 The red line prevents me form editing the code. Also this form is not working. Shared with support.... Cheers, John Whitney
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
Any tips to show embedded slideshows?
I'm looking for a way to build a small knowledge base that will include Zoho Presentations. 1. User opens the KB view to see all the articles. 2. User clicks a custom action (button) on one of the rows to display the record. 3. The record pops up in VIEW mode and has some descriptive text along with an embeded Zoho Presentation. Is something like this possible? Thanks, Jeff
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,
Subform Edit Bug: Can't add a new record through subform link
Greetings! I have three forms: 1. Enter Class/Event/Task (parent form) 2. Attendance (subform) 3. Add Clients Attendance has a lookup field that pulls from Add Clients, and "show a link to add entries to Add Clients" is checked. For the parent form, everything works smoothly when adding new records. However, when I go to edit that parent form, and I click on the link in the subform that is supposed to let me "add entries to Add Clients", the LOADING indicator appears and never stops. It keeps spinning
send mail to all email address from a specific database
Hi , what i want is to automatically send an email after a specific field had been completed by 10 users ( a form that contain a email address ),after the after the tenth user has completed that specific field , to all 10 users email address that completed the form . something that collect all email addres that had been submited ( like a address book ).
Missing field names
I have a form that loads data using several lookup fields. This works fine until in another form I use a lookup field over the first table of data. When I go to the display options to choose the data the fields in the table that were lookup fields in the original form are not in the list even though they appear in the table view of the first form. Why can't I access these fields?
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?
blank edit page
Hi, I don't know what I have done but now when I click on the edit of a record the page appears blank Please help
Disappearing data
I have a form that has several lookup fields. When I enter data into the form and execute the dropdowns to choose the data for these fields all goes well until I look at the view for that table. In two of the lookup fields the data only appears in one record of the several records in the table. Then if I create a new record the data in the record that shows data in the two lookup fields actually moves to the new record and leaves the other record blank in those two fields. What is going on?
User Input wiht NULL
Hello, i have this script on Validate: if ((input.Office_ID).length() != 9) { alert ("Office ID Amadeus must be a length of 9!"); cancel submit;} how can i change the script, when the user dosen't input any value? this field has don't be a required field. thanks Carsten
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
Mission Critical - need to send a digital product on payment of invoice.
Hi Team My company sends out building inspection reports to clients. These reports are only released on payment of the invoice. Often the report is uploaded to the system before the invoice has been paid. In this case we desperately need to have an action triggered when payment is made in zoho invoice, so that our creator app knows to release the report. Ideally this should be instantaneous. At this stage the only way I can think of is to have a scheduled event within creator check the payment status
Send email from different user (not adminuserid or loginuserid)
Hi Team I have a scenario where I need emails to go out from a specific users email address on submission of a form that has been embedded on a website (to an email address entered on the form). This user is not an administrator, nor does the published form require anyone to be logged in. If I try to specify an email address in the "from" field it tells me that the "to" field can only be set to an adminuserid. Is there any way to have emails originating from regular users on submission of a form
History for an form?
Hello Guys, i'm very new to Zoho Creator it's an very useful Database Software. How can i add an History to my forms? that i can see which data has change? would it be possible to see all changes in an grid view? Thanks Carsten
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?
Calender help
Expert help please... Fields Name John Smith Place At the office Time and date 15/03/2013 14:25:00 How do I send this data to my zoho calender Thanks
Get Related Record Count and Display in Parent Table.
I have a table called "Contacts". I also have a table called "Pets". I want to display the "Contacts" table with a field called "Pet Count" which would display the number of related records in the pet table/form. I have an ID field linking the two tables. Contacts.ID = pets.Contact_ID. I would like my table to look like this: First Name | Last Name | Pet Count I know that I have to either use a formula field or a script that will set the Contacts.Pet_Count field with the related record count,
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
Creating multiple almost identical records in a form quickly.
Hi, First of all thanks for creating this user friendly and easy to database management tool. I am a pretty inexperienced user when it comes to databases, but the needs we have for our office is not that advanced. The problem i am currently facing is to reduce the time it takes to create some records. Our company are giving out small boxes to measure the radon levels in residential houses. Each box has an unique ID that needs to be searchable and indexable. The form is going to look something
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
[App_Table_Configuration] Duplicate Entry "xxxx" is not allowed as duplicate . . .
I went to switch a "Single Line" Text entry field to "Import Data" and configured all of the parameters including '"Show Link" and "Enable bidirectional relationship" and so forth. But now I'm totally hung up with an error being generated that says: [App_Table_Configuration] Duplicate entry '1262029000000082829' is not allowed as duplicate entries already exist. I cannot find any duplicate entries in any of my forms or in the Imported Data. Thanks to this interruption, I've lost my place in my scripting
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
Colorise Calendar view
Hi. Is it possible to colorise the items in a calendar view by certain parameter? Like conditional formatting in excel? I found an old post about this, but this was 4 years ago. mayyyybe there has been some change in 4 years regarding this topic? If not possible to colorise, can I somehow "export" the view in google calendar? I have a lot of information to visualise in a calendar but certainly the application looks odd when trying to show too much records:
Custom HTML form view url parameter passing
I have a Form with View "Tests". It contains a "Project" lookup field. The "Project" lookup field is set for dropdown as import from ID (I want to use ID's for unique values). The display type is set as the Project name in "advanced display". Now, when I want to display form view like this: <div elName='zc-component' viewLinkName='Tests' params='zc_Header=false&zc_Summary=false&zc_EditRec=false&zc_SecHeader=false&zc_RecSelect=false&zc_Footer=false&zc_ColMenu=false&Project=<%=Project_ID%>'>
Search for a customer in ZInvoice via API
Hi All, @moderators, If possible, please allow this to be posted across multiple forums - Zoho API - Zoho Invoice - Zoho Creator ( on using ZC-ZInv Integration) Recently, I have been working on the ZC ZInv integration for a client The idea was to generate an invoice (from ZInv ) and send it to the customer via ZC- Form submit. I understand that the pre-requesite for generating an Invoice via ZC (or any other app) is to have the customer info already present in the ZInv settings. So, it is only
Cannot save script
There seem to be some issues as I have searched throughout the forum for this topic, but I am still not sure what to do. I am trying to enter some very simple script for the 'on update' event of a form field. When I hit the 'save script' button at the right lower corner, I get a message in green that says 'script generated'. However, when I leave that page and come back to it immediately, I find that the script has not been changed. I have, at times, been able to save changes, but cannot figure
view custom action act on all currently selected view items via the checkbox
hi, i want to work on all the records that have been selected in a view using a custom action. how do i get to the selected items in my custom action function? thanks
Fetch and set variable. Please help
Here is my scenario, I have one form called Palo Alto Records and it consists of Phone number, business name, and address. The second form is called sheet1 and it has Phone number, Phone number status, New Phone, business name, business name status, and business name, address, address status, and new address. In the Palo Alto Records form I have imported many business phone numbers, names, and addresses. For the second form I want to be able to put in the phone number and have the records from
Day of week help
I need expert help please Take 2 Fields Date... Day... How do I tell my Day Field to put the day of week based on my Date field Thanks
relating a form to many forms
I'm working on a farming application. Lets say I want to store transaction details of an "Inventory" that might be a child of a multiple types of "Planting", or of "Receivings", and become the parent of more "Plantings", "Packaging Runs", or "Wastes", for example. Inventories must also be able to parent other inventories so that lots can be split and combined. But I don't know in advance if my Inventory is going to becomes seed, or be sold, so I can't have a different Inventory forms for each type,
New User - Database Novice
Hello, I'm new to Zoho and very, very limited Database experince. I want to create a Simple(?) database to manage Staff & Equipment, Possibly later a Help form based on the Staff & Equipment. I have a good idea on where to start.... But before I even start I'm confused? I have created an Account for me, I assume I'm the "Full Admin"?, But can I also Develop? I have read some posts about problems about people creating in the Personal Workspace vs Shared I think? How do I avoid this, I want
Execute deluge upon login?
Does anyone know if it's possible to execute one or more deluge scripts upon startup of login of an application? For example, some of us maintain a users table in which app users can update some basic profile information or application parameters. If their record is not yet in the table (i.e. Added_User==zoho.loginuser), I would like to insert a new row transparently upon login. Thanks, Jeff
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
Next Page