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."
Dashboard of Apps Very Slow
I have been reviewing Zoho creator for building a new app for myself. While viewing demos of various apps i notice the dashboard loads very slowly. Is this common ? What is the issue and is this expected ?
How to create a view for a form with multiple subforms
Hi, I have read through the few topics that cover this question and still haven't found what I need for help. I have form A, with subforms B,C,D, and E in it. I need the veiw of A to show information from the subforms. I've imported data and it come through w/o any errors and is showing in it's perspecitve forms but when looking at the view of from A, no informationa at all shows up in the columns for these forms. I'm getting a java error when I go into column properties (I am running the
return only one record for each match in dropdown
Hello, How can i return only one match for each different record found instead of all. I am sure it has something to do with the "getall()" function but I do not know how else to code it. if (count(Pulser_Serial_Numbers[Pulser_Size == input.Pulser_Size]) == 0) { clear Pulser_Serial_Number; } else { mpseriallist = Lifetime_Hours [(Description == input.Pulser_Size && Job_Number == input.Job_Number)] sort by Serial_Number ; Pulser_Serial_Number:ui.add(mpseriallist.Serial_Number.getall());
Google's verification email, to enable automatic email-forwarding, not received within Zoho Creator
Hi, I am working with a client to enable email-driven add/edit. The app works fine when emails are forwarded manually. Now, we want to enable automated email-forwarding from Gmail, but it seems the verification-email from Google does not reach the Zoho Creator form's records. I see that this is the expected behavior as is detailed in the following forum post.. You can use Gmail forward option if you are using Gmail / Google Apps, refer this help document to know about Gmail email forwarding. Note:
Hide Add button in Subform
Hi , Is there any option to hide the Add button in Sub form. Need to add only one information Sub form ,No need to add more than one information . Please help me out . Thank You
Can someone please help me or its all been for nothing
Hi, OK so here is what I want to do. I have been told that Zoho does not currently have the ability to trigger the add button of a sub form automatically from a script. This feature is vital to my project so I have been looking into this in an attempt to help you with the feature. If I could find a way of implementing the following Java code within a script, it should trigger the add button in the sub form. <script type="text/javascript"> $window.onload = function() { $eval(document.getElementsByClassName
Updating multiple records
I have a new script which calculates risk, which is drawing data from a risk matrix, which contains descriptions, and ratings for likelihood and result, I am using the following script on my two lookups: categoryresult = Risk_Matrix_Risk_Categories [(Min <= (input.Likelihood * input.Result) && Max >= (input.Likelihood * input.Result))]; Risk_Category.select(categoryresult.Risk_Category); It basically looks to see if the result of the two variables, Likelihood and Result lies in the ranges
Within a function send a user message best way
Hi, Inside a function i want to send the user a visual message No Alert in functions so cant use that Info is only seen if you are admin So .. what are my choices to inform the user of something occurring within a function ? Any ideas Thanks
Search Query
Hi, I have a database and one of my categories is what phones people have. So I have a list of loads of phone makes. I would like to pull out people on the database who don't have iPhones and Blackberry's just leaving everything else. Is there a way to put that into the search query with the 'Not contains' or 'Is not' section? I have tried it but it wont work. Is there a special way to separate them and make it work? Like........ Is not ---- "Blackberrry", "iPhone" Many thanks Gill
Existing Data Base access
Good morning, I'm a new user to this site, in the company I work for, there are many kind of existing data bases (such as SQL Server, Oracle, MS Access, Excel, ecct.), can I create a new zoho application (with zoho creator) for an existing db? Is there any type of DB Connectors (using ODBC, JDBC or others)? Thanks Leo
show all rows from xxxx [xxx == zoho.loginuserid] has stopped fetching results in a view
Hi we use 'show all rows from Submit_IP_Topic [IP_Approver == zoho.loginuserid]' to show only items that belong to the IP approver specified in that field. it used to return results and has failed again and will not display anything. am i doing something wrong here? i have learnt that i need to use 'advanced' when you wish to use zoho.loginuserid otherwise it is treated as a value. often if i clear out the filter then reapply it to the view it will start returning values again. cheers
Validation on Radio field contingent on entry on number field
Hi, Can anybody help advice how I can validate that a radion field is selected if a number field is entered. For example: - The form has two fields. One number field and another radio field - The number field is not a required field - The radio field is required only if a value is entered in the number field Please help. Thanks! regards, KM
How to calculate a price using a pricing table with multiple variables
I have an input form that allows users to select several criteria regarding the attributes of a product (size, gender, etc) from dropdown lists. I also have a pricing table which lists the combination of these attributes and has a column for price (ive attached a screenshot of the table). I wanted to know what the code would look like in order to have ZOHO return a page that has the price of the options selected (maybe using openURL function?). thank you
manage drop down box
I'm not a expierienced in script language, and what i want do requiers knowledge about script language. i want to make a form for my site where user can select a team from a drop-down box (eg i want to put 20 team or more) and after submit, the chosen team to be automatically deleted(disappear) from the drop-down box and can no longer be select by another user . The next user will see only 19 team, and so for the next and next....
Issues
Hi! I developed evaluther apps using the 15 days free trial with the end in mind that the client will upgrade this to a paid account. However, there were issues that they are still waiting for Zoho to respond to. 1. Inability of the system to create reports using data captured by multiselect forms. 2. Currency field configured with Philippine peso sign (Php). But when data is fetched by the report builder, the $ sign appears instead. 3. Printing report in PDF is not based on "What You See is
SPF record for outbound mail from ZOHO
In order to help keep 3rd party mail servers from marking messages from the application as spam I would like to update my SPF record to reflect that ZOHO can send email on my behalf. I added "include:zoho.com" to the record. Do you have a better recommendation for this? Thank you, Parker Byron Network Administrator Kansas City Regional Homes, Inc.
Select CRM Contact, then fetch to get email and address
Hi, Is there an easy way now in Creator to select a contact in CRM and get email and address ? I really need an easy way to do that. Thanks. Pascal Veilleux
Hide Field from main Form on Edit Record
Hi Zoho, i have question about sharing a view with user A. when user A view it and edit it, i only want him to see certain fields on my main form. how can i do that? b/c right now, he can see everything from my main form when he edit the record from the view. i cant hide the fields in the main form either, since i will be the only one sees it. i have some other people work on the main form as well. hope u understand my question. Thanks
Need help creating a simple database with search capability
Can someone point me to a tutorial how to create a simple database with search capability. I want to make a list of 100-200 home properties with different qualifying criteria and to be able to search for the right properties once I type a certain criteria in the search field (age for example)??
Dynamic list within subform again. still need help.
I know there is already a post solved this problem. itis still not clear for me. so please point me to the light. thank you so much. I have 2 forms: Region Entry->Region Name is field City Entry-->City Name is field I need to have these 2 form within a SUbform within my Order Form. input from Region will populate City Name accordingly. Please kindly help out. thank so much for ur time.
Delete a record stuck at loading screen
Hi, this is my second post for this problem. no answer back from Zoho yet. trying to delete a record, stuck at Loading Screen forever. is this a common issue or just me.
Calc / Functions
Good night, I'm building an app that requires some calculations, with four int variables that should return a int value that would fetch the field "Prioridade". I've tried to do this operation using the "Function" new option, and even calculating the variables directly into the events code; neither worked out, thought the script deluge didn't pointed any flaws at the syntax. I'd really appreciate if you could take a look at this functions, I've shared the form with support at zoho dot com - please,
Deleting Record stuck at loading
Hi, new database, only first 3 records. i cant delete them. please help. i have share access to application to support. please check your mail. thanks.
How to gather form data into the script of another form
I have created a fee schedule form where I store the values for fees we charge. I also have a form that is used to send a billing notification of fees owed. I am trying to include the fees from the fee schedule form for use in the form that sends the email - I have pasted the script below. The ExternalFormFullWebFee variable is supposed to be gathering the fee that I want from the external form data. The script does save but when I run the form I get a 'variable cannot be updated' error and the email
Minimum number of digits in number field
Hi, I need help with two questions that i have on the number field in the form. 1. In the number field of a form, we can validate the max. number of digits. Can someone tell me how we can validate that the field contains exactly (say) 5 digits? 2/ Similarly, how do we validate that the field contains both a minimum and maximum number of digits. cheers, KM
Confirmation email
I have created an application for jobs to our university. I have completed 2 scripts for email confirmations, one is "on load" the other is "on success". When I apply for a job using the application, I am not receiving a confirmation email back even though I have completed 2 scripts. Could you tell me: 1- How quickly is the confirmation email suppose to be generated 2- Am I doing something wrong? Is there another place in Zoho that I am supposed to complete to make sure that the person applying
Next Page