Zoho creator app ios camera
Hi guys, I'm trying to understand if zoho creator is a suitable option for us. I have a question regarding the use of an app on iOS, is it possible to access the iPhone's camera through the app? What I need to accomplish is that the app (created with zoho creator) user can take a picture using the iphone camera and store the image in the form. Thanks!
IF syntax - user guide example doesn't work
Sorry if this is very basic, but I'm stuck when setting this up (I'm a very new user). For debugging simplicity, there is no other custom deluge code on the form (just a decision box, and a submit button). I'm trying to set up a conditional IF statement for the "on click" action of the button, that evaluates whether a decision box is checked. Taken straight from the user's guide, I set it up like this (substituting the name of the decision box on my form): if ( (input.box== "false") ) { alert "Please
Back up restore failed
Hi, I try to restore drc-timex v3 backup but the restore failed and I see the following error message : om.adventnet.persistence.DataAccessException: [t_255467000006116494] The size of the value [Atelier DVs Critères 2010] of the column [Etape_Missi_255467000006116516] specified in the row [ Could you please investigate ?
Disabled field format
I am having instances where a disabled field does not appear like the other disabled fields. It is a dropdown field, but not a lookup field...the other fields are all lookup fields and they appar correctly when disabled. When it is enabled, it looks exactly the same as when it is disabled
Is it impossible to paste text into script builder?
I'm trying to paste some script from textedit into the script builder and keep getting an error when I try to save the script. Below is the script I'm trying to paste and it looks exactly like the script I built using the builder manually. input.Zip_Code == "27150” || input.Zip_Code == "27151” || input.Zip_Code == "27152” || input.Zip_Code == "27153” || input.Zip_Code == "27154” || input.Zip_Code == "27155” || input.Zip_Code == "27156” || input.Zip_Code == "27157” || input.Zip_Code == "27158” ||
Mobile Forms Date Edit Causes Crash on iOS 8
I am unable to edit the date on a shared application as tapping on the field causes a white box to appear at the bottom and application is non-responsive.
Zoho Creator Forced to Mobile Version on Mobile Form
Hi, It seems recently there was a change where the mobile version of zoho creator is forced onto the user if accessing form a mobile device. Unfortunately he mobile version does not work for our application for many reasons too many to number. How can I disable this or connect to a non-mobile version?
iOS 8 crash down
Help, zoho creation is crashing on iOS 8. I can't access shared database.
Refresh a Report with New Entry
Hi team, I've built a page that contains a form and a report of that form. I would like the report (or the entire page) to refresh when a new entry is submitted via the form. How do I do this? Danielle
data from a lookup field displaying incorrectly in email notification
I have a form (let's call it Form A) in which, among other things, a user selects a site name from a drop-down list. This list is generated using a look-up field to pull in the site names from another form (Form B). I also have an email that is sent when a user updates another field on Form A, and among other things, I want to pass the site name in the email. However, instead of showing the actual text of the site name, what gets passed is a string of numbers. I'm guessing this is some sort of key
SQL SYNTAX REFERENCE FOR ZOHO
I am trying to find a reference guide for Zoho SQL Syntax: for example this function does not work but I do not have an sQL syntax reference to correct it: void DEFAULT.DELACTS() { delete from acct [(CANADA_TRANSIT_BRANCH like "*editme" && flag_temp == "XIALEGOUYAN")]; }
Permalink using http
Hi there. I'm struggling with a website issue using Zoho embedded forms and to address it I need to turn the https links in my forms into http. Any idea how I can do this?
Keep getting knocked back to the homepage
I have just signed up, and am trying to upload a simple Excel table. I have tried uploading the files via Local file, and also via the Cloud Dropbox option. With both, without any explanation, I get kicked back to the home page. Why is this? The file I'm uploading is large (48MB, 48k records) & it only has 1 tab. What is going wrong?
How to enable registered visitors on membership site to automatically access embedded ZOHO Creator report
Hi, I have a Wordpress based membership site with restricted access to many pages. One of these pages accesses a ZOHO Creator report. When I set up a "published" report, the only options are to view and print a selected record. However, I wish to enable my registered users to access an "embedded" report where they also have the ability to edit and delete records. Is there a simple way to automate the process of logging in to the ZOHO Creator database so that my site visitors don't need to go through
Zoho Creator and Zoho Campaigns Integration
I would like to use the data from my Zoho Creator database as content in my emails that I use Zoho Campaigns to send. The database is an inventory type of database which I would like to send out to my customers via email using Zoho Campaigns.
Report refresh for multiple users
Hello . Is it possible ,in zoho creator application, to update data in a Report view without refreshing a webpage after one of the users edited - apdated -created - deleted a record in the under-laying database . Regard Sergey
error in field multi-line
Good evening, I have a problem with the tag <br> in Multi -Line. In the report view , an application executes the command <br> while in another no, visualizzandomi simple text <br> no newline . example Report in application1 Multiline = " 1 <br> " In report = 1 Report in application2 Multiline = " 1 <br> " in report = 1 <br> May depend on what ? David
Multi-value filter on a view
I want to filter the results of a view with multiple values passed to a column, say "1" or "2" or "3" or "4". I know how to do this by designing the view to have a custom filter; but can I do this "on the fly" when displaying the view, so the user can arbitrarily enter the values herself to filter the results? Kind of like Excel but more powerful as you can enter an unlimited # of filters.
Using ZC and Google Apps: Manage Groups not available?
The Manage Groups menu item as described in the ZC help pages is not functioning. Anyone else?
HTML page return null
Hi there, I'm creating an html page where I'd like show a column of a form (Commesse). I attach an image that explain what I'm doing, anyone could tell me why result is null? Thank you
Calculating between dates
Hi all New to Zoho Creator but have come from FileMaker/Access style things. I have an "expiry date" and I would like to show "number of days until". According to my logic "expiry_date - zoho.createdate". According to Zoho help it needs to be "(expiry_date - zoho.createdate) * 60 * 60 * 60 / 1000)" [something like that]. But... well the formula syntax is right but the result is weird. I either get "3" or "-345600000". (depending on the various calculations I am entering!) So given the "expiry_date"
On user-input Action for Subform Fields
I am having a strange issue where an On User-Input Action is not being executed when editing a subform fields after opening the Main form and attempting to edit a field in a row. However if you add a new Row, then add data to the field, the On User-input Action is executed. When you do the same action on a Row that was already in the record when it was opened for editing, the Action is not executed. I have screenshot but the system is not allowing me to upload them. The Application is ghsagjv/projects/
get current http - url as an initial value
Hi, I've been trying for over a year in Zoho to get the current browser address information (current url -http) to populate "on success". I have over 200 subdomains with 14 forms per, and want to know which "subdomain.domain" (browser address) the form was filled out from. In my case, I don't need to "get" the "/abc.html". Just [subdomain.domain]. As it stands, I'll need to build and track 2800 forms to accomplish this (or become a perl, java, php expert) I used to use Godaddy's "Easy Database".
Associating Subform Records with Main Form Record?
I am creating an application to schedule a person to go to different stores and perform inventory of items on the store shelf. I have created a Main Form and SubForm. The Main Form is for the Inventory Scheduled event. The Sub Form is the items that are to be inventoried at that Scheduled event. Thus when a new Main Form Record is created (Scheduled Event) I want to run a script which automatically add records to the SubForm and auto fill the fields (Items to be inventoried). I have written the
Push Data into Zoho Creator using a USSD Application
Hi, I'm new to API's and I need your help. I want to allow my prospective clients to be able to submit their data through USSD (Unstructured Supplementary Service Data) using their mobile phone. Here is an axample of the workflow: Client dials *123# on their phone. USSD is triggered and prompts the client for their Name and then Surname and Email Address and so forth. When the USSD session ends successfully, the data is pushed to a form in Zoho Creator, that contains the fields; Name, Surname, Email
Problem embedding form
Hi, I am trying to embed a form on my website and the bottom area of the form keeps getting cut off causing there to be a scroll bar. This issue persists no matter how big I make the form. Could there be an issue with the HTML code I am using? Please help it looks highly unprofessional
Similar way to PHP Sessions in Zoho Creator
A short tutorial in W3schools about PHP Sessions writes the following: When you work with an application, you open it, do some changes, and then you close it. This is much like a Session. The computer knows who you are. It knows when you start the application and when you end. But on the internet there is one problem: the web server does not know who you are or what you do, because the HTTP address doesn't maintain state. Session variables solve this problem by storing user information to be used
Is it possible to turn off Profiles and Roles?
I find the Profile and Role management extremely confusing. I prefer to use just the "Share" page under "Application Settings" and manage rights by user. Unfortunately, it looks like the Profile and Role settings are overwriting what is stated in the "Share" page. For instance, I set up a specific user so he can see just one specific report. The "Share" page is set up correctly, but because of the fact that his Profile is "user" and his Role is "Employee", he can still see other sections and
How do I restore a previous script version?
For some reason I can't update my script all of the sudden. It was working fine a few days ago but when I tried to edit the script today I keep getting a null message. I can't figure out why so I'm wanting to restore the script to a previous version that worked just a few days ago. I can't find how to do that anywhere in Zoho's help. Can someone tell me how to restore a previous version?
Fetch Data
Hi, I have created a form called Physician Demographics with an Auto Number field. Within the form, I created a sub-form called AZ Medical License which includes a date field called Expiration Date. I would like to set up a scheduled event based on this expiration date. I have created a schedule that runs on the date and would like to email a reminder to the Email1 on the record with an expired date. I have created a fetch data in order to have access to the fields in the Physician Demographic
Reserved seating
I'm developing a registration form for an event. Would like to allow for reserved seating. Actually reserved exhibitor tables, but seating seems to be more common use of such a widget. Any idea how to set this up on Zoho Creator?
Hide Search Functionality in Customer Portal
Hi, We have the customer portal. We are close to launching this however there is an issue. At the top of the page there is a search box. This search box seems to allow any user to search any records within the system when logged into the portal, regardless of if they are the owner of the record or not. Please can you advise to A - How to hide this search box as we don't really need it or B - How to remove/hide the data that seems to be able to be searched. Please can you advise on how to do either
compare with another form and delete the row if criteria Matched
Hi, I have two form FormA and FormB , There are two common fields between two forms. Below is the screenshot of the two Forms, FormA: Note: TV station : Look up field of station Name of Station Form Network -01 ; look up field of Network name of Network Form Network -02 ; look up field of Network name of Network Form Network -03 ; look up field of Network name of Network Form Network -04 ; look up field of Network name of Network Form FormB: Note: TV station : Look up field of station Name of Station Form
Lookup field to assciated ID field
I need a lookup field to associate the ID field of child form, but show value from another 2 to 3 columns; how can this be done?
Import an XML form
I have the XML code for a form that I'd like to have accessible to my users in Zoho to gather indepth information about one of their clients. How would I go about doing this?
Why does my app kick me out to my ipad when I try and access my form?
I downloaded the Zoho creator App to my ipad. I can sign in and my apps(Form) is present but when I try and access my form to fill out, it kicks me out of the App completely to my ipad home page. I am not sure that I published it correctly.
Zoho Creator running slow since early September
We have a Zoho Creator database of many thousands of items and as of the last three weeks the service has been running increasingly slowly. It has reached the stage where we click 'Add' to add a new project and have to wait about 30-60 seconds for the 'Add Record' panel to appear. Making other changes also takes a long time to update, and searching is equally slow. Is anyone else having this difficulty?
simple but possible?
I need to create a report/form/page (not sure what it is considered) where an employee enters a zip code, hits submit and it returns data with a hyperlink (from our excel spreadsheet/database) Can creator do this?
New user can't access app
I shared my app with a new user and an error message pops up saying that they are logged in but they can't access the app.
Validation function on Add and Update
Hi there, In my forms, I have a lot of controls with Alert messages that I have coded in the Validate functions on Add and on Edit. A lot of these validations are identical in the Add and Edit. How could I code once and use these validations in both Add and Edit ? I have tried to code a function "Validate_Form" but the Alert task cannot be called within a function. Any idea ? Many thanks !
Next Page