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
Sorting based on a specific record in subform.
Hi Zoho, I am in my trial period atm for Enterprise Edition. i am about to upgrade to regular soon and upgrade even more in couple weeks. this is my water testing period with Zoho database. so, please if you can, provide me with support as fastest if im about to bring my company onto zoho. i am still trying so hard to find a solution to set up criteria/ or sorting for view based on any single record at all in my subform. I have granted edit permission to support. please check it out. thank you kindly,
Express Plans - Users Create Accounts
Hello There are a few old topics on this subject but I can't find an answer. Using Zoho Creator with a Express Plan allows for unlimited users. Is there anyway to allow users to create their own users account either directly into the application, via the API or using a workflow. I'd like to provide a service where the user will provide their email address, password and other details and then be able to sign into my Zoho application. Thanks for your help. Ben
Alert Loses Focus
I use an Alert from the on Actions on User Action. After clicking OK to close the alert the original field does not have focus. In fact none of the fields on the form have focus. This is with Firefox. I have not tested other browsers. Herb Wexler
API issue, using REST to delete
Dear all, under Known Issues and Limitations for API's there is The user cannot delete/update the records for a shared application. What does that mean exactly, so any application I share I can not use APIs to delete or edit records from it. If so how come under REST API, Under Deleting records there is: When accessed by the application owner: https://creator.zoho.com/api/<format>/<applicationName>/<formName>/delete/ When accessed by a shared user: https://creator.zoho.com/api/<format>/<applicationName>/view/<viewName>/delete/
Critera using an "or" statement
Currently my criteria is saying "if field 'XYZ' is blank", like this: (XYZ is null) But now I want to say "IF field 'XYZ' is blank OR if field 'XYZ' equals 'Yes'" How do I write this? Thanks in advance. Jon
Parent fields empty On Add Row Subform in Edit mode
In my Invoice application I have parent form Invoice and a subform Invoice Lines. When a new line is added in the subform a script copies the unique id form the parent (Invoice) to the child (Invoice Line). This works fine when I create a new Invoice. However when I edit the invoice and then add a line in the subform the reference is not copied. The script is triggered but it seems that the parent field (input.INVOICE_ID) is empty in edit mode. Ivan
For Each statement creates duplicate emails
I have a function that is supposed to collect records of our agents who have not paid a certain bill. For some reason when I invoke the 'sendmail' routine using a for each statement it will send 2 notification emails to each address. I have only 2 records that match the criteria for testing purposes right now and the view I created to match shows just those 2 using the same criteria. Here is the function I call from that view to send the emails: void agent_management.getunpaidfullwebsite (string toaddress )
Zoho Creator (URL Request Structure)
Hello, I know I should really use the API forum area but it doesn't seem to receive as much attention as this one. I'm currently building an application which interfaces with Zoho Creator. I am trying to add records using the REST API. However, it does not seem to be working. My URL takes the form of: My application is definetly called 'Messages' and my Form is definetly called 'MessageForm'. Within this form is a field called 'User' that I wish to populate. https://creator.zoho.com/api/xml/Messages/MessageForm/add/apikey=<api
Help!: Can't view pictures...
Hi! When a user uploads a picture into the form, and you go into the view to download it, the following message appears: ""An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused." Why is this? Thanks!
How can I have 1 form or field update 2 fields in 2 separate forms.
My ultimate goal is to have 2 form field put data into 2 fields in 2 separate forms. Here is current code: if (input.Completed == TRUE) { lastWorked = Checkout [Checkin_Date]; } I get the following error: "Error in statement at line number 3A Boolean expression is expected in the where clause. and but an expression of type TIMESTAMP is specified here" I want to fetch the Checkin Date and input it into a different table. This could happen when someone clicks the "Completed" checkbox. What
Is this even possible?
is it possible to have subform within another subform? Company A : + Store 1: (Product; Quantity; Shipdates) + Store 2: (Product; Quantity; Shipdates) + Store 3: (Product; Quantity; Shipdates) so, a record of Company A should show 3 stores. for each store, there can be a list of products, quantities for each, dates. can anyone try this out? thx
Attach a created file
Our application creates pdf files based on information in the database. Is there a way to attach this file to the database via script or email after it is created or when it's being created?
Limit Submit per User [field] per a sepecific Date [field]
Dear all , i have a form containing 10 fields , i need to restrict the submition to only once per day , the rule should check the following fields to see if they are already submitted. e.g.. Name: (drop downList) containing names. Date: (Date of submition) thank you :)
Force a Save in Script for Grid View
Is there a way to force the save action for the grid view from a script? I have an html view that has 2 grid views and form embedded in it. When someone clicks submit in the form? I would like to force a save action for all changes made in the other 2 grids.
Next Page