Storing data for the long term
Dearr Zoho friends, I would like to have a suggestion from you as to how I can efficiently store data created in my zoho creator applications. I have been using creator for about two years and generally I have a very good impression of the service except for one point, I don't know how to store effectively information created in my applications for the long term. Considering the subscription limits the number of records, eventually these have to be exported and stored somewhere else for long term
How can I create views on my database?
I have imported tables, but I want some forms to access views instead of the tables directly, preferably via stored procedures. Is this possible? Also need to know how to create a picklist where the description is displayed to the user, but the ID field is returned to the underlying record.
Problems forwarding to aol email addresses
Has anyone else has any issues with forms not sending to aol.com email addresses? I have a series of applications and scripts that forward user submitted data to various email addresses, and recently the aol addresses seemed to have stopped getting their emails. Thanks so much for any help! -Courtney
Render images in form and list
Hi there, I need to upload or take a photo with smartphone by Zoho Creator app and see it in form and list view, but choosing dimensions for adapt it in form/view. With previous version I attach a file and this formula ("<img width='250' src='http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Carica_immagine + "&sharedBy=" + zoho.adminuser) + "'/>" but now I have professional and it don't works Thank you
User Input (for Mobile) Field Properties not working?
Hi, Under the "User Input (for Mobile)" section of the field properties on a Single Line field, Zoho Creator allows you to enable either "QR Code" or "Barcode" input as per the documentation here: https://www.zoho.com/creator/help/fields/qr-code-barcode.html However, this doesn't appear to be working for me in the "Zoho Creator" mobile app. Help appreciated. Thanks
Using a button to open a URL dynamically
I am trying to use a button that will invoke a URL that I have associated with a particular record in one of the other modules. This is different than just invoking a static URL that I specify in the button. I'm looking through the documentation and I am having trouble finding anything. Can anyone point me to how I may handle this?
Intergration of Zoho CRM information into Creator Application
I am creating an application that would allow us to have people check into a rock wall. I am happily using CRM to manage the people that are interactive with us. (For instance, if someone fills out a trip application, signs into the rock wall, applies for a project, ect. they are all recorded into our CRM database) What I would like to have happen is when someone clicks on there name in our application using the CRM field, information about that person would automatically be populated into the form.
null = zoho.creator added to my script on save
I have a deluge function that looks like this void AddToRecents(int EmployeeId, int CaseId) { [...snip...] // no hits, insert new record rvId = insert into Recently_Viewed [ Last_Accessed = now Employee = input.EmployeeId Case = input.CaseId ViewingUser = zoho.loginuser ]; } But every time I save it and go back, a line is inserted (line 11 below). That line, of course, is invalid and the function doesn't work. Does anyone know why and what to do about it? void AddToRecents(int
is it possible to show an image when you load to edit a form
is it possible to show an image when you load to edit a form
Login
Hello Everyone. I want to fetch data from another application to use it as a login information using call function but it's not working. Can any one suggest me idea or any other method.
Display Images from a Subform in a Record Report
I have a "products" form with part # and images. And I have an order form with a subform that has a lookup field referring to the part# in the products form. I would like to create a report from the order form that shows images of all of the products ordered. Is this possible? Thanks!
Adding a custom URL to Zoho app
Just wondering if its possible to access Zoho creator app via a custom URL (Like database.mydomain.com)? I understand this can be done when using a customer portal but I am not planning to have a customer portal, I just want a database that is accessible by internal staff but would prefer if it could be accessed via a company address. Is this possible? Thanks Dave
Add List:String in dropdown
Hello i want add this list of string during the loading of the form i go On Edit -> On Load -> list2 = List:String({"hockey", "cricket", "football", "tennis"}); for each e in MySubForm { e.Dropdown:ui.append(list2); } but after the downloading i have already just "Choice 1" in my dropdown. Do you know why ? thanks you
Bugs
Hi, I've been using Zoho Creator for a couple of weeks now, and i appear to be encountering a lot of bugs and i wondered if anyone else is experiencing similar problems?. Has Creator recently gone through a major update and they are working out the bugs? We are intending to use Creator for a large application, and these issues do raise concern. Off the top of my head, a few of the problems i've run into; * Conditional formatting on reports not working. (Resolved now im told, although i havent tested
Stop annoying unsolicited adverts
When I loaded Zoho creator today I got a bloody annoying advert pop up for workshops that I couldn't delete and when I thought I had done the sound still played on regardless. Get rid of this shit.
Customer Portal User Groups
We are just about to try out customer portal but immediately found that without user groups for permissions we either have to create multiple applications or customer portal does not work for us. Is there a way to set up group permissions in customer portal? We have many levels of people we work with and wanted to use portal for multiple groups of people. It seems this might not be possible with customer portal. The portal assumes your customers are all the same. We wanted to use portal for - New
How to get a space in my "Full_Name" formula field?
I used a formula field to combine First_Name and Last_Name fields into a field called "Full_Name", but the records come up looking like "EricaJones" when I want "Erica Jones". Help!
Update three forms through function
Hi, I have the following: Form A Form B Form C Form A -> Multiselect to form B (Lookup field) Form C = Subform to Form B On update of form C -> Fields update in form B -> Updates in form A Problem is that Form A only updates if I do an edit-> update on form B. Can I somehow "refresh" or simulate an "on edit" on form B through a function? Everything works, except that I have to update the form manually on Form B for it to show on form A (not even the values, just "update" and it works). Thx! /V
Automatically adding a new row on a form when a row is entered into.
I want to have a dynamically building list of fields for the database. Easiest way I can describe it is to show a picture of an example (I know it's uber simple and I'm just missing something obvious). This is just from google image search but it demonstrates basically what I want to do.
Moving data from one field type to another
I accidentally created a zip code field using number field. I'd like to move the data I've entered into a new single-line text field. How can I go about doing this? Thanks in advance.
HTML view form and link that gets data from form input
I want to build an html view with the following: 1. Embedded Form 2. An html link that opens a record to edit based on a select value in the embedded form. How do i pass a selected value in the embedded form to another part of my html view so i can open the correct record in the html link? Is there a way to get the value selected in an form that is embedded in an html view and use this value for other parts of you html view? ================= The reason i am trying to set this us is because i need
Setting a variable based on another form's field that was chosen previously in the current form
I'm creating an application form and I have a lookup field that accesses another form that holds the positions and whether or not a Drivers License is requiered. I later want to restrict the field that allows you to input an id type to only drivers license if the previous lookup field chose a job that required a license. Otherwise it would allow you to select Other types of ID. Once I am able to do this I will then be able to use this technique in other areas of my main form to get specific types
Deluge Script Editor Not Savings
I am designing a custom related list and have saved one before but now i cant edit it nor add a new one! it stay stuck on savings and never saves? It doesn't even give an error? void name() { crmResp = zoho.crm.searchRecords("CustomModule4","(Unique Address|=|" + input.uniqueaddr + ")"); allProductXmlData="<Products>"; rowVariable=1; for each product in crmResp { apn=product.get("APN"); county=product.get("County"); psize=product.get("Property Size"); totaltaxes=product.get("Total Taxes Owed");
Create a report and import it to Zoho CRM?
Hi, Just wondering if its possible to have a custom report and upload it to the correct user in Zoho CRM by using a function in Zoho Creator? How could one do this the best way? The emailadress required exists both in Creator and CRM so it shouldnt be a problem adding the information. Should I have a custom app, send as a email or by using the API? Suggestions? Thx for your time! /V
Get Record By ID
If trying to "Get Record By ID" from CRM module in Zoho Creator, where do I find the CRM ID record? Looking to find the record ID for "Products" "Unit Price" Cheers!
Fields are not adding to the form
Hi In my application one of the form contains 45 fields.Right now I want to add three single line field columns.But when I drag and drop single line field into myform it doesn't adding to form.Can you please let me know why it happening in this way. Thanks.
Embedded iFrame and Internet Explorer and Safari Not Working
When using embedded iFrame with Safari either on phone or Mac or Internet Explorer v. 9 or 11, the user experiences "please wait" and it does not submit or go to next URL. Here is a screencast: http://cl.ly/image/3K1Y0a373T33/Screen%20Recording%202014-12-28%20at%2008.31%20AM.gif The same embedded form is working fine in Chrome and FireFox. Also, when you login to Creator and submit using Safari it works. So it is the embedded iFrame code that is the issue with Safari.
Can you have more than one developer active per application?
Working on an app, but I can't give more than one person edit privileges. Even though both users are categorized as developers.
Zoho Creator access control by Report
I understand that for each form I can suppress certain fields to prevent editing. But is it possible to suppress specific fields on views, so users assigned the views can only edit certain fields I want them to? I believe this is extremely important because I can control access to views, and then further granularity down I can control the fields. I believe this is essential for Zoho Creator to become a mature on-demand business-application platform.
Sending email from button click event?
I tried setting up an on click event to send an email based on a form button click but got an error. Is it possible to send an email this way? I can post the code later when I'm on my laptop.
passing criteria to embedded form
Publishing a form so a login is not required results is a very long url. This is too long to include in a tweat. Is there a way to mark a form as public so it does not need the long security code? I can embed the form in a website and then use the webpage link. However I do need to pass some criteria to the form. Is there a method for a form to read the current url? If so I can then parse that string to get the passed vales.
Reporting record values that only appear once
Hi, I'm struggling a little..... I have a list of ticket sales & each sale has a customer number. Some customer numbers will appear more than once as they have bought multiple tickets. I'm using the GUI report generator in a Pivot Tableto display the customer numbers that only appear ONCE in the database or only ever purchased once. I've tried using distinct & distinct Count = 1 to filter the records but the data is not correct. Any help would be appreciated as this will help create lots of different
Invalid date not showing as error 08/25/0015
If a date is typed in with the century as 00 there is no error displayed. There are very few applications where 08/25/0015 is a valid date. Is this on the roadmap or should I handle this error using deluge code?
Global Search
I use Global Search quite often as it pulls results from all forms/reports as one. Is there a way to increase the number of rows to view. Currently it displays about a screens worth of data and makes you go to a new page for the remaining forms/reports. Thanks
Importing Access 2007 with auto number
Importing an Access 2007 database works without a problem using the Zoho migration tool. I have a number of Access 2007 databases that have Autonumber field and there is data already in the table. Q1) How is it possible to import data with autonumber in the access database? Q2) Is it possible to create a form with a Zoho Auto Number and import data directly? As aside I sometimes use in Access 2007 vba code Max([contact_ID])+1 to create an incremental numbering process. Q3) Is it possible to achieve
getting lookup value
when i am print the lookup value its printing ID, how i get ID related value ?
I'm Completely new, where to start
A few years ago I built an application for a business in Access that I now want to rewrite as an online app. I'm thinking of using ZOHO to do this, and have signed up for a free account. Where can I learn the basics, such as creating beginner apps so that I can begin to learn how to build my app here?
Upload CSV
Hello, Is it possible to load a CSV and work with DELUGE ? if no do you have this functionnality in your roadmap? thanks you
NEED HELP - NEW TO ZOHO
Hi, I'm trying to build a simple application with dynamic filtering on dropdowns with the following relations MAKE MODEL VARIANT AUDI A3 V1 AUDI A4 V2 AUDI A6 V3 HONDA CIVIC V1 HONDA CITY V2 HONDA CRETA V3 HYUNDAI VERNA V1 HYUNDAI ELANTRA V2 I need to create rules such that if a user selects "HONDA" in the MAKE field, only the corresponding MODEL & VARIANT should be visible. How do I do this ?
Validations not run on import? How can I have validation logic or other logic in import for form data?
I would like to have validation rules for when doing a bulk import (like importing via .csv file) and also, I want to have some other logic, like if a field has one value, then calculate a value in another field based on this. I have this all in place for my form for new submissions and edits and it works fine. When I run an import, however, none of this logic is triggered, I am confused as to whether there is a way to do this? This is a critical need for the app I'm building and I figure there must
Next Page