Poor Support
I'm extremely surprised and disappointed in Zoho's support for a critical incident reported last Friday morning - a form's data not able to be fetched. I understand that no support is provided on weekends, but here it is late Monday night and the only contact I received was this morning asking me to share the app with support (which I did right away). I have no desire to be put at the head of the line, but being unable to access my data for so long is unacceptable.
Running multiple "IF" statements in Free Flow
I have a form that will require me to run multiple "If" statements. 1. When I run a "single" If statement, everything works fine. 2. As soon as I add a "second, third, fourth etc." If statement, I get no output. a. Note, I will not be using functions since no two If statements will be the same. 3. Any ideas on what I should do to run multiple if statements in one form? Should I be putting something between the statements so that each one runs automatically? I have copied and
System Error thrown when Radio Button values are duplicating
In Zoho Creator form when I use radio button but ran into a state of having the same values for the radio buttons instead of showing a friendly message I get a system error message as in the attachment. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
How to luanch a form from a comined view??
I am using Creator to handle a property bidding/auction project. I've created 3 forms... 1. People, 2. Addresses, and 3. Bids. For the BIDS form, I created relationships with PEOPLE and ADDRESSES to access pick lists on the BIDS form and that works great. I then created a list using the BIDS form, and used the combined view feature to add other fields to the list from the PEOPLE and ADDRESSES form. This all works great. But when I click "EDIT' in the BIDS View List, I can only edit the BID form.
Date Functions
I maintain a membership list for a club of sorts and need to keep track of when members fees are due. Is there a way to have their listing show up in a separate list after their payment date is over 365 days old? This refers to my MN application under my list of applications. Thanks for your help.
When I share my view with oher users, I just want that each user can ONLY edit their own records that they have captured by the form before.
When I share my view with other users, I just want that each user can ONLY edit their own records that they have captured by the form before. When I set the permission, it allows me to give the permission to every user with who I share the view. So they can edit any records that they want....and I don't want lol! I want that when a user captures his information by the form, he can only edit his own records! How can I proceed? Thank you
Fields required. I want to give two solutions to the user for giving a required information
I want to give two types of solution to user for submitting a required information. Like he can upload a file or write an URL where we can find the information. At least one of both information has to be filled in to allow information submitting. Example (pseudo code) : if URL_field/=null or upload_field/=null then submit=active.... I don't know how to program it...Someone can help me please??? Maybe I don't have to program it... Thank you!
How can I display an image in my form (not in the view)
I have left zoho one year ago with this problem and it is still here. Any solution? For example, i want to show a diferent image for each of the option in a drop list; when someone change the select product from the list, i want to show the picture of the product.
Email Address instead of verification code
Hi, I have an application in which one can enter his contact details. I would like to have him/her re-enter their email address instead of the verification code. Any chance I can do this? Thanks!
TXT FILE
Hello, I am developing an application that must generate a txt file and the user must download. How can generate a txt in zoho creator and user can download it? Thanks
populate one form with information from another form
Hi, can soneone describe in simple terms how to populate one form with information from another form Thanks Nigel
Funny look to disabled fields
With Firefox 3.5.10 I get this look to the disabled fields: Not very attractive. Not true in IE8. Thanks, Bruce
Unable to delete application from homepage
This is the error i received, Error Occured. We are sorry for the inconvenience. Please try after some time or refresh the page and try again. I tried deleting all forms and views inside but still didn't work. This really is a serious bug. I wish to delete the following applications, 1. inventoryt 2.copy of exam registration 3.copy of exam registration. Thanks
DECIMAL TO BIGINT
It's possible to transform a decimal variable into a big int variable into a script??? Thank you Sergio Galiano
If field disabled, remove from Views
Hello, If there is a field on the form that is currently disabled (through a decision box for example), can it be automatically removed from the View? thanks,
Can application use Facebook login instead of Zoho Login for user?
Requirement #1: I would like to create a membership application where user can login create account using their facebook ID and password. Requirement #2: I would like to create a membership application that has User create their own login data User fill out and modify basic info using their own created credential Simple search result by company, industry, age without need to log-in (not using Zoho account) Detail search result with need to log-in Hope that someone can help on this one! Thank you
Birthday Emails
Hi All, im using the Schedules section to create a script that will automatically email clients on their birthdays with a short message. ive set it up as per the instructions in the help section but it isnt working. heres what my script looks like: When to do: Birthday Notification { Execute on Contact.Birthday at 18:30:00 yearly } What to do: sendmail ( To : input.Email_Id From : zoho.adminuserid Subject : "Happy Birthday" Message : "Dear " + input.First_Name
Fetch specific characters in a data string
Is there a way to fetch a specific character in a data from a form field? This is my situation: I have created a database of car plate numbers (i.e. ABC123, ARX899, etc) which we are managing. Now I wish to be able to fetch the last digit of the plate number and create an automatic email notification based on the last digit of the plate number: If the ending plate number is "1", then we shall receive an email on January 1 to alert that the car needs to be registered on January. If the ending plate
is zoho appropriate for my application?
Members of my org need to view one table of contact data on the web. No adding, deleting, editing, just viewing. I would refresh the data weekly. they will select records based on values they enter for any of 5 fields. once the recordset is retrieved, they need to view it on a nicely formatted form that they can move through easily to see one record after another. They would not be happy with a gridlike view analogous to a datasheet view in Access. Is Zoho appropriate for this application?
database in creator
ive just tried for the first time the DB and everything was fine until i decide to add a multi-choice to contry and county, but even i select, the creator add all fields less this ones. also, is there a open source DB with UK all conties? thanks, Carla,
If statement
I need to write the following: If(25 =>24,25-24) I will be creating many if statements and want to use the "easiest" script. Suggestions?
Duplicate entry
I'm a newbie of zoho. I don't know how to delete duplicate in my entry in my look up field. Here is the sample: wood wood apple apple apple My look up field is connected to the my table "Products Sold". What I want is to delete the duplicate in my look up field. Another is in the view of my multi-select look up field. In the table connected to multi-select look-up field here is the sample: Nelson --- barangay A barangay B barangay C The above sample is correct
edit issue with users
I have added multiple users on my data base. My problem is that the way I set it up requires that my users are allowed to go back into each record and record information. This is considered editing in this app and only I am allowed to do this. How can I allow them to "edit" records? This is for a probation company and we see clients every month. We need to document each and every time that we speak to our clients. I do not want to be the only one that can do the data entry. The only solution that
Update record from Checkbox
I have written some script that dynamically populates a checkbox with records from another form (this works OK). The user then selects the checkbox options of their choice and the following "on user update" script updates the corresponding records back in the other form. This code also works OK but only if the user only selects 1 checkbox option. If 2 or more options are selected then I get the error message "Unable to update data on the form variable". I should add that the checkbox is dynamically
Future emailing functions for service of cars
Hi, I am making a preventive maintenance schedule for our motorpool. Is there a way that I can make zoho creator send me an email when my car is due for repairs. I would like to do this via inputting a future date (i.e. if today is jan 1, i will input June 1 as the next schedule for repairs), and then creator would have a function to send me a notification email on June 1. I have been trying to do this in forms (Action on update, action on new), but it seems the action is only on the forms and not
Importing Data
Hi can anyone help please Ok so here is the setup Lets say I have a form callen "customer" with fields called "name", "age" and "telephone number". Now, I want to create a second form where I insert a lookup field from "customer" using the field "name" Here is my problem, how can I make the second form automatically show the "age" based on the "customer" I choose? What I am trying to do is create a database where on the repair ticket, I only have to choose the customer name and other selected
How to make a report that shows a "y" value when an "x" value is input.
So basically i want to be able to have a list of "height" values that the application user can choose from (from a drop down menu or something similar) and a corresponding "flow" value that will result from each individual height value that is input into the application. Any help would be greatly appreciated!! Thanks!
Edit a single field of a record
Hello!, I´m trying to create a form of 3 columns ("name", "age", "address") and 2 types of users. User 1: (full access) User 2: will be able to modify only the fields of the "address" column of the record only. No editing access to "name" and "age". How can I achieve this?. Regards,
Need help with action button
I can’t get a custom action button to work. I have two tables: Events (parent table) Fields: Event, Event_Date RSVP (child table): Fields: RSVP Date, Name, Email, EventID (lookup ) and its related fields – Event, Event_Date, ID I set up a relationship between the two tables with a lookup field in RSVP called EventID that relates to the Events’ ID field. I created the following function for the button in Events (to show on all records): void rsvp.makersvp (int ID)
Embedding a form question
I would like to embed a form on our website, but require a login to access the form (it is for our internal usage, not our customers). Is there a simple way to do this? - Thanks, Brian http://www.redpelicanmusic.com
How do I change my form to public view?
Adding users and getting them logged in????????
I have added users and made them active. My question is how do they log into our account? Is there something else that I need to do? I can not find a place where I assign passwords. Please fill me in. I am very new to ZOHO.
Application not duplicating
I tried the solutions proposed to another with a similar posting in this forum, but none work. The last option was to export the script and import it. After exporting my application script, then trying to import it again, the process halts with numerous problems. I edited the application as best I could, but it still complained about one function missing, even though I'd cut out the form that asks for it. That particular function working fine in the original application. Help! I'll open the application
How to use a "lookup" to populate a field thats in the same record (Using a lookup to add more that one field to a record)
I am new to Zoho, however I have used another system similar to "Creator" this Caspio. I must say I love your system, very well designed and thought out. Bravo!! I have one last issue I need to solve before my web application is finished. Here is my problem: I have a form that uses a lookup to find another database table and use it for a drop down. What I want to do I pull two more values into this so that both are displayed when I submit. I am creating another form database so that I can find a
New url pattern for permalinks?
ZC Team, I saw that a new url pattern for permalinks can be used (and I suppose that it was made in order to fit better with Custom Domain, an important feature that will be available in the future). So, instead of http://creator.zoho.com/<zoho user name>/<application name>/form-perma/<form link name>/<private code> you can use https://creator.zoho.com/showPermaFormHeader.do?sharedBy=<zoho user name>&appLinkName=<application name>&formLinkName=<form link name>&privatelink=<private code> The same
Auto increment in 2 lines of self supporting code.
As long as you have 1 record with a number field that has a number in it, then these 2 lines of code will work: LastRecord = Magnet_Board_Form [ID != 0] sort by OrderID desc range from 1 to 1; input.OrderID = (LastRecord.OrderID + 1); So how does it work? The first line is a "fetch" it sorts all records in form "Magnet_Board_Form" by the field "OrderID" in descending order, then grabs just the top record and calls it "LastRecord" The second line then increments the "OrderID" field of the "LastRecord"
How do I use the fetch records variable in zoho creator?
Hi im working on the app zoho application builder and am wondering how to fetch records in a html view in which all zoho users can see. Is there a way to find the amount of employees then make it so when I fetch a record it will show how much employees and volunteers I have in the view. E Industries Inc. www.eifis.webs.com
An Email Form With Email Verification
Hi, Here's my basic form: I want users to be able to write a message & send it to a recipient email of their choosing. I want to collect the senders email address, but don't want their email address to be kept on record in a database with the rest of the fields data. Instead the email will be sent from a singular address such as test@abc.com. So to clarify, from the above form the following will be produced: Email Recipients Address - [recipients email field] Email Message - [message to recipient
Logarithmic axes on graphs in Reports
The title pretty much says it all. Is there a way to make the y-axis logarithmic in Zoho Creator reports? I have looked for options, but couldn't find any, and I am surprised noone has posted this question on the forum before? Thanks, Milen
Can Zoho solve my problem?
Hi, I am NOT a coder and have never created a database before. I'm hoping Zoho can do what I need it to do. I have a client who does weekly CD Reviews. To date I have about 500. I need a database to include and be searchable by date of review, artist, CD Title, Label & Star Rating. Each review will also include the album cover picture and, of course, the review itself. I have been able to create the data entry form for this, but I can't create the display page for the website. I need to make
Next Page