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
Apps & Adds-ons zoho app build custom apps
I have a Zoho Crm user.we use built custom field to make a new tab and new form but face a problem in send email field. after send a one or two mail its fields dont get response.please tell me the solution of this why its not responding after send a one/two mail?
Conditional field problem with Excel import
Hi Everyone, I have got a problem developing my application... In a form I have a first field to fill in : "ID appareil de mesure". If the value filled in is 0, some others fields take automatic values (Script in the first screen shot) : Bâtiments/Pièces, Surface en m2, Nombre d'employés, Données mesurées (In french, sorry but whatever) It works properly when I fill in the form manually but when I want to import data from excel, fields with automatic value remain empty (Second screen shot)... Is
Multiplication Problem??
Hello, I am working on a formula that is giving me trouble. I have been successful until I ask it to multiply based on a condition (highlighted)... any ideas?? (Staff_Requirement / 2 + if((Living_Situation == "Community"),1,0) + if((Intensive_Family_Involvement == "Yes"),2,0) + if((Split_Shifts == "Yes"),2,0) + if((Payee == "Yes"),1,0) + if((BSP == "Yes"),1,0) + if((Monthly_Medical == "2 or Less"),1,0) + if((Monthly_Medical == "3 to 4"),2,0) + if((Monthly_Medical
Help
I am new to Zoho Creator and I am having problems learning the scripting, is there any help with actually building the database.
Callback URL for Clickatell SMS API - Please Help
Zoho Staff/Developers, I have a few questions regarding the Clickatell SMS API the Zoho Blog were pushing a few years back. I have a two-way HTTP API set up (not the SMTP API as was detailed in that post, which doesn't allow for two-way as far as I know) with them and am I little disappointed at the ultra-lame incoming SMS reports that they have as the basic option and would like the SMS responses to be delivered into a form in Zoho Creator. I'll start with a few screenshots detailing where I'm
Why Import Data link is hide to shared users?
I would like to give permission to shared user to import data into one specific view. What I have done are: 1. In share Tab, the specific view (and form) are shared to one user. 2. In the view configuration, the permission to the specific view has been set to "create,edit,delete allowed". But still the user could not see the "import data" link under his "more actions". Is this functionality supported? If yes, how to set the permission properly. Thanks, Gino
Attachment not sent with Schedule for email
I have "email attachment" enabled in a schedule... but the attachment files are not sent. I have opened access to Support for this form: https://creator.zoho.com/lifengwu/moviesvillecom/#View:documents_View
reporting limitation with multi select lookups
Hello Is there a way that someone has sensibly worked around the above limitation an can offer some advice. I can't see I can avoid the lookup requirement and so that really needs to stay. At the moment I'm exporting out to excel but I'd rather just keep it in the app. Cheers Simon
Passing a set of values to a Parameter E.g. #View:SomeView?ParamID IN {1, 2, 3, 4}
In my application, I need to show a view of records which are determined at run time i.e. my logic identifies a variable number of records (code in an HTML View) and I need to display an embedded list view where I want to be able say that ParamID can have any one values from a set i.e. {1, 2, 3, 4} as an example. I have gone through https://help.creator.zoho.com/Functionality-based-URLs.html and I am unable to find any set operator like "IN" when passing parameter values. The functionality that
Exception reports for Zoho Creator
I'd like to receive a daily exceptions report for Zoho Creator. For example, I have a custom schedule executing every a few times a day. Once the monthly quota was exceeded, and only a few days later did I discover that the schedule had been stopped because the monthly quota had been exceeded. So I had to pay extra to upgrade the # of schedule executions per month, to fix the problem. I would like timely notifications by email of such incidences.
Change column/label width into Zoho Creator
Hi everyone, I attach a screen shot that explains clearly what I want. I want to resize the column of form's label into Zoho Creator. I looked for how to do but I found nothing. How is it possible ? Thanks ! Regards,
Can a field auto populate in a secondary form from a primary form?
I have form1 (aka: proposals) which collects... project number customer name sales rep & more... form2 (aka: orders) needs to have some of the same fields auto-populate when an existing project number is selected from a look-up... customer name sales rep IN SHORT: What script or how else can a field auto-populate the 'customer name field' of form2 with the existing data in the 'customer name field' of form1? Nathan
How do I validate an entry on my form?
I am fairly ignorant at deluge scripting or any coding for that matter; however, if someone would help me get the correct syntax for my field, I would be very grateful. The field is called Your_Company_Code. I want to be able to limit the entries in this field to values that I specify in the formula. In the formula below, these values are "OK0609" and "AU1325". Unfortunately, when I tried out my form, it did not allow any value at all. What should my formula look like? ((input.Your_Company_Code
Search across multiple forms?
I have 4 forms, in one application. Theses 4 forms all have records in them. I want to be able to search (say by last name) across all the forms, and for the results to pull up that record and tell me what form they are from. any ideas/
Next Page