Lookup fields and report
Hi, I am developing an application with lookup fields and I would like to make reports with filters from anther form. https://creator.zoho.com/kevin.loussouarn/consoadapt/# I allow access to support. In form Production -> Usine de Reims, the user select the id channel thanks to a lookup field related to Standardization form. Each id channel have a zone area and a consumption type: Z0 total A1 - South Wing - Air conditioning A2 - South Wing - Lighting B1 - Amphi A - Lighting .... Now, in report, I
concatanated Fields
I am new to zoho Creator and I am trying to join two fileds to make one filed. Example: firstname, lastname= fullname.
Update one field from another Form.
I want to Update Form C using (Form A and B). I had tried stateless Form(Form B) which enable me to update Form C . But I want to update Form A also. I needed to keep the records or history of changes made. For example, an Item may be transfered from one to three sections in a year. From Add Item Form (Form A), I had added the current section the Item is used. When an Item is transfered to another section, I will need to Update Item Movement Form(Form B). Form B is to enable me to track the
What constitutes a 'user'?
I have the freebie account which allows 2 Users, but does this include a person who can only view the file, but not edit? Thank you.
Search Function in Form
Hi, I am new to Zoho Creator. I am creating a form, which need to search the invoice number. However, the invoice number is consist of 10 digit. Is there a way I can just type in a sequence of 3 digit of the invoice number + customer ID, and I can find the record? Thanks TM
Toggle radio button to show/hide responses
Hi, I'm trying to create a form that has a series of yes/no radio buttons in response to questions. I want to hide/show a specific response to each question based on which radio button is pressed. Getting the form with the questions and radio buttons to work is easy, but I can't work out how to set up the answers to the questions and then 'call' the correct answer to display. I'm thinking there are two ways to do it: 1. Have the answers hidden in the script of the form 2. Have the answers in a separate
Calculating Averages problem for use in Reports
I am hoping that someone can help me with a way to accurately display information I am capturing in Creator into Reports. The just of my form is that the user fills in the number of safe and unsafe observations of a given activity. The sample data would be as follows: 1. 3 safe, 2 unsafe 2. 90 safe, 10 unsafe 3. 1 safe, 1 unsafe I have built in formulas behind the scenes of the form to calculate the total number of observations and then also the % unsafe of each record. So for these records
Dynamic picklist in Stateless form
Hi, I use a stateless to add or edit existing records in a master form. In this stateless form, some fields have dynamic criteria (fieldB == input.fieldA). My problem is when I need to fetch records from Master Form. I open StatelessForm with : #Form:myStateless?myID=1234 Script in StatelessForm > OnLoad : myData = MasterForm [ID == input.myID]; input.fieldA = myData.Country; input.fieldB = myData.Town; As fieldB has a dynamic criteria, the value stays on "-Select-" instead of MyData.Town. Is it
Provide EDIT option for CRM integrated tasks in Deluge script builder
Hi, As of now, all CRM related tasks in ZC apps are performed by manually typing the code eg: <CRM Response> = zoho.crm.create(<CRM Module Name>, <Field values as map value>) <variable>= zoho.crm.searchRecords("<moduleName >", "<criteria>", fromIndex, toIndex); These are working just fine.. However, we dont see a EDIT option, for these lines of code in scripting mode. Not all are code-savy. Having this in script mode will make things easier for not-so-code-friendly-people as well What does the rest
Calculate Based on Field Entry
Hi, I have a formula I am working on to calculate a weight/score for a particular entry. Basically the part that is giving me trouble is that if there is an entry in the "Program_Manager_2 field, i need it to divide the weight/score by 2 and then multiply by .8, if there is NO entry in Program_Manager_2 then I just need it to multiply by .8... This is the formula i have been working on (I have highlighted the parts that I think are wrong): if((Program_Manager_2 != ""),(Staff_Requirement
Exporting of reports in spreadsheet format
Currently, reports cannot export in spreadsheet format, only PDF. This is not helpful. I can create a regular View with groupings, then export that to spreadsheet format, however, that doesn't give me the aggregated grouping I desire and get with Reports.
Get ZOHO Ticket using PHP (CURL)
PHP GET ZOHO TICKETS I had to search high and low to get this information. I was not easy and finally I managed to do it. Without a ZOHO cookie capability there has to be some way to track users who are logged on through ZOHO's own user management system. The following PHP program can be used on your own server. It requires the CURL module of PHP to be activated. CURL allows you to send POST and URL inquiries to other applications. In this case we request ZOHO to give us an API Ticket number
Amazon SES Now Offers SMTP
I'm using Amazon Simple Email Service as the backend part of my ZOHO Creator app to send thousands of emails per month (see buzzable.info) - way beyond the email allotment from a native Creator app. Just today Amazon announced SMTP support. So I'm wondering if ZOHO Creator's email service could be configured to use another SMTP service? I'm not familiar with how SMTP works, so also comment on the server resources. John M. Whitney
Bulk import in Grid view.
hi, Can i have a use of bulk import functionality using Grid View. Please help me out, im not able to get it. Thanks in advance.
Calendar view: if StartDate = EndDate, event not displayed ?
Hi, in the new calendars, we can choose StartDate and EndDate. But if we have an event on one day, means StartDate = EndDate, it's not displayed at all in the Calendar. It works with 2 days minimum. Any suggestions ? Thanks ! Cyril
how use together zoho creator and zoho calendar?
Hi i use for order entries a date field (date of order performing). how can i unite together creator application with zoho calendar? for viewing calendar view of orders thanx
Short circuit boolean evaluation
Good evening... I was wondering how creator handles boolean evaluations, does it use "short-circuit" evaluation? What I mean is if I have the following statement: if (a || b) { ... } Then if a is true it will NOT evaluate b and execute the if block (a or b could require counting records that meet certain criteria or other complex operations). Similarly, if I have: if (a && b) { ... } The if a is false it will not evaluate b and skip the if block. Thanks,
Lookup Function
Hi, I am using lookup function to pull a field from another table called "Info Part1". The field that I am pulling has many records in it. Some of the records are duplicate. Now the lookup function is listing all the duplicates on the drop-down list. Is there a way to just list unique records in the drop down. Please see the attachment for details. Thanks! Vishal
Employee management System
hey, There was an application called Employee Management systems. I am not able to find in the Market, can any one help me out. thanks in advance.
Cannot delete records from a view
Hi, I'm trying to delete all records from a view (we're developing and all data is wrong). I do from views, checking all records and clicking Delete option. But, the system keeps thinking all time, showing the "Loading" message, and nothing happens. I've tryied to remove all possible relations (has zoho creator something like "cascade delete"?) but, nothing. Please, are there something else that I have to keep in mind? Thank you.
Slow iframe
The iframe form loads very slow on our website (it's a non-US site), compared to the rest of the page. The script is very basic so that does not slow down the application. Is there any alternative to using an iframe? Some online database systems offer a javascript code to embed as opposed to an iframe which seems to be much faster. Is this possible?
no more email sends:
hi, i hv face a problem whwn i m using a email field in build custom field in app @ adds-on in zoho creator..after sending a one/two mail this field become unresponsive .no mail can send to any one what actually the problem it is pls short out this problem.. thanks
color text as a return value of an IF function?
Hi, Is it possible to have color text as a return value of an IF function? for example, i set up a priority level. "RUSH" should be red. makes sense thanks
Is multiple simultaneous login possible?
Can many users login and access the database at once?
upload data and radio button
I have a form with several text fields and a radio button. The radio button has two choices (Open & Closed) with a default of Open. I upload data from a spreadsheet for the text fields but dont have a column for the radio button. After uploading the data the view shows all the data accurately except the radio buttons field is blank. When I edit a record the radio button is marked Open as I would expect. Is there a way to force the radio button to use the default value specified on the form? The spreadsheet
Email Submission when email addressed to multiple users - no longer working
I have a form that allows email submission (Public). An email is sent to this form and the database is populated with the data. This has been working for about 2 years without fail. The email that comes in address to TWO email addresses. Suddenly on June 1, this stopped working. Was there a change to the email submission to not allow the system to process it if it has multiple recipient email addresses. I know that I used to have to ensure that the Zoho email address was the first address in
Create a search box on remote site
Hello all Is it possible to create a search box, where you can search on difference parameters of the database, and get results based on that. Eg. I have a database, which registers cars. Make, model, serial and location. I have a website, on which I want visitors to be able to search on these 4 parameters and then get the all the cars of the specific make they searched on, or the one car with that serial, if that was what they searched. When I embed the "view" on my site now, the whole database
Only submit form if expression is specific response
Hi, I have created a form and I have a field containing a formula whereby it compares another formula total (A) to another formula total (B). If formula total A is bigger than formula total B, the field shows a "NO" message. If formula total A is smaller or equal to forumla total B it shows a "YES" message in the field. I want users to only be able to submit the form it shows "YES" rather than "NO" (ie: if total A is small or equal to formula total B). The formula totals are simple number additions
Store Several Previous Record History
I want to store several recorded values in a field so I can register the historical values of a given field, Zoho support has given the answer for storing JUST ONE value with in the following thread https://help.creator.zoho.com/Store-Previous-Record-History.html, however I want to store every change.
Display Info from other forms
Hi, Is there a way to pull information from other forms based on user input and just display (read-only) on the main form? Thanks! V
Getting Google Apps to work with zoho creator any trick to it
Hi I have this with zoho support but it is the weekend i am stuck I have a personal creator account and a Google apps account, i have installed creator from the apps marketplace When i click the link in Google apps to go to creator I get a login screen which asks for a user name which then goes and creates a new creator account Ideally i want my personal account linked, cant seem to get this to happen .. Should i have a domain account ? whats the secret to this thanks
DEACTIVATE
How do i deactivate my account?
Creating subform entries for an existing form
I am trying to implement a comments system for the Bug Tracker template. The comments are implemented as a subform on the main form. This works fine from the Zoho UI. The next step is to integrate this into our existing customer support portal using the XML API. I have managed to create new Requests using the API, including with an initial comment, but I can not add new comments to an existing Request. I can not in fact even update a single field on the Form, even though I'm the application owner
Excellent application, a little buggy, but being improved!
Its an application that will push & encourage the average computer user to become a programmer and every programmer to make applications that help them do exactly that. I made a proper website with data entry forms and dynamic lists of books/movies for a library in just a few hours, without having to do any programming whatsover! Superb stuff! avibull
List of Creator objects
Is there a way to programmatically capture a list of names of the objects in my creator database?
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
One of my views is missing and replaced with: [ServletException in:/jsp/edit/view/viewedit.jsp] null' App https://creator.zoho.com/buzzap/ncsd/ shared to support Thanks, John Whitney
Email Scheduler Stopped Working!!!
I used the email scheduler successfully last week. This week the email scheduler failed to send scheduled emails yesterday and today (I confirmed they were scheduled via the "verify you schedule timings"). This has created many problems for our scheduled experiment tomorrow. THIS ZOHO PRODUCT IS EXTREMELY UNRELIABLE!!
email submission no longer works! as of june 29
Similar to: https://help.zoho.com/portal/en/community/topic/email-submission-when-email-addressed-to-multiple-users-no-longer-working But for me, on two separate accounts and three separate databases, email submission no longer works. The emails just go into the ether - they just disappear. No log entry, no nothing. Happened about June 29. This is very urgent and frustrating. Zoho - can you please confirm?
Generating email / view based on relationship between forms
I have two forms, the first contains customer information (customer ID, name, email, etc) and the second contains store information (store ID, address, email, etc). Each customer needs to be associated with a particular store. Both forms share the field 'store ID' for this purpose. I am trying to develop a way for a store owner to receive an email each time that store gets a new customer. So in other words a script should check at a regular interval (say once a day) the relationship between the
Problem displaying an image from a form in html view
I'm new to Zoho, new to deluge, and new to html...but muddling through. I'm playing around with a form ("Master Database Configuration") that contains several fields. The relevant fields are "Parameter_Name" (string field) and "Value_Image" (image field). In an html view, I am trying to display the image that matches the record that contains Parameter_Name = "Logo1". I've attached a snippet of code below. Near the end of the code, you can see where I'm specifically referencing the filename in the
Next Page