Detect Record Open for Editing
I'm working on a time input manager application. In order to limit a user entering more than 8 hours total for a few projects on a given date, I'm applying the aggregate function in form validation to sum the total number of hours for a given date+user. The problem I just found was in editing an entry for a given date. This may best be explained with a simple example: Let's say a user has two projects for some date. Project A has 6 hours and Project B has 2 hours (totaling 8). Now let's say his
Calculating a SUM and Show it
Hey Folks, i try to build up a Form for a Sales Funnel. For that i create a Form with several Fields, including my List Price and a Discount. I can calculate the discount and can calculate a new Sum. But i would like to see it on the Form too. So - Listprice: 100 $ (User Type in) Discount: 10 % (User Type in) Sum = 990 $ (Seen on Screen, Calculated) Anonye out there, who can help me?
Freeflow Script Issues in Chrome
When I'm at work, behind our corporate firewall and proxy server, I have issues with v16.x Chrome's freeflow script editor. Interestingly, this is not the case for IE. Part of the issue is rooted in the page css, where using Chrome's inspect element I found that by changing an opacity value to zero, the ghost text is removed. However, there is still an issue with using the mouse cursor to select lines - the cursor seems to still select ghost lines of text. It seems to be an issue with https://creator.zoho.com/appcreator/edit_area/edit_area.js
Issues in implementing email processing within Zoho Creator application.
Hi Zoho folks, I have a client who needs to automate his processes, which are primarily based on incoming emails. Each of these emails represent a Request which needs to be added to the Zoho Creator database and tracked to Completed status. These automated emails come from an external source, but are in some standard format. So the emails were added to an email-inbox and data processing was done in the On Add --> Validate, parsing out the data. This is okay until there are no issues in the email
Can't find 'Deploy in Google App Engine' link
Can't find the Deployment link to Google App Engine, Is this option still supported?
Form Schedule can the record be accessed
Hi I have a form schedule which looks at a record dates in my form and sends me an email 7 days before that date (this works) Now when this record is matched i want to also include some additional fields in the email and also do some updates to the record Question, is there a way to access the record which triggers the form schedule ? i..e does it exist in a collection variable somewhere ? Thanks
Help with Decision Box Display
I am not sure how Zoho Creator treats true and false. Are they 0 and -1 or 1 and 0, or what? I have several decision boxes which when displayed in Form View show either true or false. Is it possible to display either a box with a tick or (no tick or cross) or a Yes or No (true and false are too similar to be easily distinguished by eye).
HELP in access Data From another Application
Hello there, I need Help in order to retrieve data from one ZC App to another ZC App. Application A has a form called orden, here we track all the contracts belong to a Consultant, so for example I have the following fields: Name (Import file) from other form Contract Number (Single field) .....other fields... In this application one record is created every time the consultant has a new contract. Application B This application have the mission to store each payment for that consultant, so something
Format Pivot Columns
I have a pivot chart which includes a column generating an average. The default average value contains 4 decimal places, how can i remove the decimals or reduce to 2 decimals ?
Failure in emailing to add a new record - "Error occured while adding record"
Hello, When I send an email to add a record into a Form, I may receive an error email, subjected as "Error occured while adding record"; and the email content suggests "The Following error has occured while adding this record: 50". I created a new form to test this. The form has only one single-line field named "ZC_Subject" and one multi-line field named "ZC_Content", and no other deluge statements are involved. I noticed this may occur for long emails only. Please help! Thanks!
In View Sorting After Group is applied
Hi I have a view for which i have set up grouping in the view definition When i look at this view it is grouped as i expect. BUT I cant seem to apply any live sorting to this view , seems like any view sorting functions are now disabled Is this the way it is meant to be ? Thanks
How to send hyperlinks to Zoho CRM
Hi, I'd like to send hyperlinks from Creator to CRM (in a multiline text field). The result in CRM is : <a target="_blank" href="https://creator.zoho.com/account/app/view-perma/Actions_view/Zoho_ID=454220000000064827">Clic here</a> And when I clic on edit (in CRM), I get it : <a target="_blank" href="https://creator.zoho.com/account/app/view-perma/Actions_view/Zoho_ID=454220000000064827">Clic here</a> This is working well when I copy-paste this code directly in CRM, but it desappear when
Could you please add a COUNT function in the view?
Hi Latha Now the view already has sum functions, can increase the count function in the view? because in the group statistics, only to see the total sum, there is no way to see the total count. Thanks Stanley Guo
HTML Print question
Hi, I've to print an HTML page to print a table : the Table has a bold separation. But when I want to print it, bold disappears. I thought about the browser's option "print background and images" (essential to print colored background) but it's the same.Do you have an idea to print those bold line please ? The style of this border is : <style>tr.bordertop td {border-top:2 solid black} </style> Thanks !
error when entering Creator [ServletException in:/jsp/newhomepage/newhomepage.jsp] null'
We were using a very slow connection this weekend and all of a sudden we got the error above when entering into Creator. Any ideas what we can do about it?
Creator runs very slow
Creator runs very slow at me now. Does anybody have a similar problem with Creator?
Summary view labels
Hi, I am curious if there is any way to turn off the field labels that appear in a Summary View. It is the only View where field labels are used and I have tried using the zcLblWidth parameter set to 0 with no success (I know that zcLblWidth is a parameter for Forms but I was hoping that it might work for the Summary View). If I could just switch off the field labels I could achieve my design goal without creating a more complex HTML view. Thanks in advance for any tips. John
Some help with criteria in a view please
Hi, I have a field in a form that I am trying to use in the criteria on a view but zoho wont let me. Can someone please tell me what I am doing wrong. Field 1 Date_Completed where we enter the hate when a job is completed. Now in my view, I want the criteria to say, if (zoho.currentdate is > Date_Completed + 14 days) Can anyone please help. Thanks Nigel
How to send email from a view including record data....
Hello Zoho Team, I want to send an email from a view, in order to do that I have a Function & custom action (Show action for each record), I want to send email only to a selected record each time. Until now I test and it work for plain Text only. Problem that I have is I can´t see how to include the data from the record selected, i.e. the record has Customer field, Prime Contractor field and other fields and I want to inform those fields as part of the message. How can I add field record
No option for Gapp Advanced Field
getting kinda frustrated with this set up a creator account through google apps, would like to have access to gapp user field in creator but its not there. have added/removed gapps, deleted/recreated app, closed/opened new zoho account. followed same steps with different domain, it worked fine. please tell me what needs to be done to gain access to the google advanced field
cross reference values
I have created an app for inventory management for my online sales. I have created a drop down menu for shipping options. My goal is to select the ship type in field1 and automatically populate the cost for that type shipping in field2- rather than having to manually type it in each time. I would also like the option to choose "other" as shipping type and enter my own value if needed. And if shipping charges change, I can change it at the data source... How should I be doing this? As a form within
How do I update the HTML page holding the ifram everytime the iframe reloads?
I have an HTML page holding an iFrame with a form. When the form is submitted, the next form loads within the iframe (i used an openURL function), passing the necessary values with it. However, what i really want is to use a function to open a new HTML page with the successive form and necessary variables. So i guess i would need to pass the variables through the URL string, is that correct? The reason i want to do this is because I am using wordpress and dropping the form URLs in the body. However
Separating multiple items from a Lookup field in a view
My app uses a lookup field to a form with the paragraph text box (long text?). When a record is linked to multiple records in another form, the view shows the other records separated by commas. Is there anyway to separate them by new lines/carriage returns? For example: Col 1 Col 2 Record in form a This is a long sentence in form B, This is a long sentence in form C. want to change to: Record in form a * This is a long sentence in form B.
date criteria generating error
In a user defined function the following form criteria generates an error: apt_rec = Appointments [((((Client == inv.Client && Appointment_Type == "Assessment") && Cancelled == false) && Start_Date >= inv.InvoiceDate) && Start_Date <= inv.Closed_Date)]; However, the following version (without the end date specified) works fine: apt_rec = Appointments [(((Client == inv.Client && Appointment_Type == "Assessment") && Cancelled == false) && Start_Date >= inv.InvoiceDate)]; What is the correct syntax
How to connect form with database?
I have created a database with Zoho Creator in order to house pertinent information for our organization. This database includes basic contact information of members as well as fields that we will use internally for our own use. I have also created a stateless form that I would like to use for our members to submit their contact information. If the field names and designations are exactly the same, is there a way that the member who submits the contact information form (a new record completely)
Populate field with IDs of related records
Hi, I need to create a new field "related" which is automatically populated (comma separated) with the IDs of all the records which are related to that record. Records are related by having the same value in one or more fields. For instance, I need it to look for value "X" in field "A", and/or value "Y" in field "B". If "X" or "Y" are present in a record, then amend the ID of that record to the list of IDs in the "related" field. I'd be really grateful if anyone can help
Help with database
Hi Everyone, I am very new to this but I am hoping someone can help me. I am trying to create a database where people can select the items that a dog may be allergic to and it will spit out the brands. I have created the form but do not know how to reference the mutl-select to a databse. Basically the idea is say someones dog is allergic to chicken and beef as well as carrots and pea it will spit out say 10 brands and the model of the food they can try. I also need an easy way of importing this
Looking for Zoho Creator Developer
We subscribe to Zoho Mail, Docs and Creator. We wish to use Creator to improve efficiency of our services and be able to better communicate with our clients. The project consists of building views for us to enter data and then have clients be able to log into a web page where previously entered information is available to view. I have created a blueprint (mockup) in FrontPage with the basic concept. I do not know the full capabilities of Creator. Thus, do not know if all of the functions that
Unable to access Views or Reports...started this morning (US GMT -6)
We are UNABLE to access any views or reports within our application. We can only use the default form... Are there others having this same issue?
Overrideable Field with Default Value from Another Form
I'm building a commission calculation tool with some complexities that I'm having trouble implementing. I have a form for entering orders. This has information like order number, total amount, date, etc. along with a dropdown to select the manufacturer from another table. That table just stores manufacturer name and default commission rate for each. I need to be able to put the default commission rate for the manufacturer the user has selected into a field in the orders form so that I can perform
Can the More Actions button be made visible in the embedded view
Can the More Actions button be made visible in the embedded view ? Is there a alternative for printing the data in a embedded view ? Thanks, Ken
How to import Filemaker Pro database including photos?
Obviously, when exporting an Excel file from Filemaker Pro, the images are not carried across. Is there any workaround for this or do we have to go through and manually re-upload an image for every entry?
Cannot Delete Application
Hi, There seems to be a problem with one of my Creator applications. When I attempt to delete it, no action is delivered except the message box, and the application still remains confirming delete. Since I had the problem I removed all the content from the application, it's nothing but an empty shell. I'm thinking the application is deleted, but obviously the master database is dirty. Thank you, Mario Stevenson, P.D.L. & TTEE, EQEACT
I Cant ... Gues this? please Solve this problem
An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to Home
"More Actions" drop down menu not visible in List View embedded in HTML View
I do not see "More Actions" drop down menu in List Views when they are embedded in HTML Views Is this a bug or am I missing a configuration? Harpal
Where can find Detailed reference manual for class of ZC html table
Hi If use class of ZC html table in html view the table very beautiful,but hope get a complete detailed reference manual, such as： <table class=zc-viewtable> <caption class="zc-viewtitle"> <class="zc-viewtitle"viewrowheader"> <td class="zc-caption> etc... sample for class of ZC html table Thanks Stanley Guo 2011-11-11
How do I remove dropdown grouping
The dropdown grouping filtering on a view is very useful for my end users but once the view has been grouped, the grouped column disappears. How do I remove the grouping and go back to normal ungrouped view? Peter
Lookup between forms and alert when info found
I am so new to this, I'm a bit lost. I have an application with two forms accessed by two different groups of people. The first group will use the first form (form A) to enter a request for information related to a specific numbered asset (Asset_Name). The second group is logging row upon row of data related to various assets numbers in a second form (form B); they have two fields they use to capture the asset information. The first is a single line text field where the primary asset number
How to search (or make a report) that searches ALL views?
I see how to make a report / view based on a single form / view, but how can I easily search across ALL data in the application (i.e. just a simple, broad database search)? Thanks everyone.
Ideas for user handling
There has been a lot of discussion of the way users are handled in zoho and I think many developers are frustrated with it. Here is my two cents: 1. If I create an app for a client, I would like all of the interface to be through my URL. I think it looks a bit unprofessional when a user goes to my site, and is redirected to creator.zoho.com/.../.../.../.. to sign in and use the app. If they are a bit curious, they will go to the root site and be greeted with "Create your own database for free."
Next Page