Send mail with "if" command in body copy
Hi, Is there a way to send mail with an "if" command in the body copy? I have two kinds of contact fields and I'd like the email to say: Hi <contact> But if the <contact> field is empty I'd like it to say: Hi <contact_NEW> How can I do that without ending up with Hi null <contact_NEW>? Thank you for any help! -silver
Iterate Values in Subform
In regard to post https://help.zoho.com/portal/en/community/topic/displaying-subform-records-in-html-view marked as Answered, I attempted to understand how to reiterate thru vales in a subform to display on an HTML view. The sample application has a number of strange issues that are easily diagnosed by attempting to edit the HTML view. Please explain how to do this rec = Main_form [ID == input.id.toLong()]; for each i in rec.SubForm_1 { //some code } Cheers, John Whitney ZOHO Creator Developer
How To Pass ID From One Form To Another Form With Out Using The Querystring Functionality?
Hi, I am using a single "Stateful Form" and "Three Stateless Forms". I am passing the ID Created in the Stateful form to other stateless forms. So that i use the ID passed using query string to stateless forms for updating data to the record in the stateful form. Suppose say this application is used by many suers,The problem is as the ID is passed as query string, it is stored in browser history. So when anyone logs in they can view the records using those url's since i have written some logic to
View Enhancements
We are pleased to inform you that we have done few enhancements in view and is available at https://precreator.zoho.com . We invite you to check out these features. These are done mainly to increase the productivity. [Update on Jan 11th] : It is now available at https://creator.zoho.com Auto filters can now be selected multiple times across various fields All the selected options will be shown with a tick mark Selected items can be deselected by selecting them again Custom filters are now listed
Public form need log in?
Hi Support, I insert a form in webpage, and set it public without need of log in. But 2 days ago, it became need log in suddenly. Why? Luke
How to show the application menus and messages in other language different than English
I am developing an application for a Spanish-speaker country. I want to customize the actions such as edit, export, etc to appears in Spanish instead of English. How can I configure that?. Thanks in advance.
Invited users report
We should be able to have a view of the entries in the database by invited user
Creating a conditional formula for a required field
I have a field that requires the user to use the multi select field type to select 5 choices. If the user selects "Other" from the string list I want the next field to become a required field, where the user is required to specify what "Other" is. Can someone please help?
Why is form text so big now?
Hello, One of the things I don't like about the new UI is that fields on forms use such large text (unless it's a notes field where I've adjusted the size). However, recently I noticed that even in the old UI the text is all really big. Under settings, there are only two choices "Medium" and "Big" and they're both too huge. Can we please revert to the previous, normal font sizing? Or at least give us better control over this? Space is already a premium on a two-column layout, and this new size and
Conditional formula
Hi there, I wonder if someone could help me create a conditional formula for a formula field. I have a field called "Signup Value" where we enter a numeric amount, then we have a "Frequency" radio field where either "Monthly" or "Annually" can be selected to say how often the Signup Value paid. In the formula field we need the total annual amount, so it if "Annually" is checked then that should be the just the Signup Value in the formula field, but if "Monthly" is checked it should show the Signup
Please downgrade my account/subscription
Dear Zoho, I've been in touch with support to please stop my subscription. They keep telling me to downgrade but downgrading appears to be a hoax or some webpage that doesn't have any functionality. Please manually downgrade me and send me some confirmation that I will not longer be billed. Thanks - maggros@gmail.com
Form or View - Generate a List by Date Range
I have been tinkering with many formats of things with Zoho Creator to learn it. In my creation, I've made a form that key field is a date (no dups) that pulls up a Look Up listing of people. Basicly, enter the date and then check box off each person attending. Submitting saves it with the date as the key field and then a comma delimited listing of everyone that was checked off. What I would like to do is have a Form or some kind of view that would look up all the records within a Date Range selected
Do public registrants count as 'Users' on the account
Hi, this may seem dumb to ask but, whilst at max our organisation will require 5 users to administer the apps and databse, we wish members of the public to be able to register, log in, add and edit their information on our database via a web form. Will those people count as users on our user count, or simply as public data access through our web form? We are hoping for thousands of registrations but if they count as 'Users' it would be financially unviable.
New windows when click on a link in note field
I have this note field with a link which I want to make it as a popup or a new windows. When I tried to do this in the source mode for the note field and click save: <a href="some_link_here" onClick="MyWindow=window.open('','MyWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=720,height=480'); return false;">PLACE_YOUR_LINKTEXT_HERE</a>everything from the onClick is removed and become like this <a href="some_link_here">PLACE_YOUR_LINKTEXT_HERE</a>Is
Group access to my shared app
Hello, I have problem. I wanted to add many users to share my app (sample database) Zoho asked me to create group as I cannot added too many users at once I created a group Seems nobody can access my sample database unless I add them as users also to share my app... They are redirected to the page where they can create their own app (from scratch, from template,....) Pls help Thank you Julien
How to Hide Field in view if data is not entered
Hello, i would like to know how to make it so a row does not appear in a view when the user does not enter data in a field. for example: if I have an employment application form, and have 3 sections for information pertaining to the applicants previous employers, and the applicant only enters data for 1 of his previous employers, I want the fields that the applicant did not enter any data NOT to display on in the view. How do i do this? Thank you in adnvanced, all the help i have gotten from this forum has
Number Calculation
Hello - I have a calculation that I am trying to do and I am trying to figure the best way to write the formula. I have the following fields/information: Funding: I/O, Level 1 Staff to Consumer Ratio: 1:1, 2:1, 3:1 Est. Awake Hrs.: (number) Est. OSOC Hrs.: (number) Est. Weekly Revenue: (formula) The goal is to calculate the “Est. Weekly Revenue” based on the selections that the user makes. There are different rates for each “Funding Type”, each “Staff Ratio”, “Awake Hrs.”, and “OSOC
setting user permissions for data access
Hello I'm currently building my application and populating it with data which currently stands at a few thousand rows and will eventually grow by a few thousand more. My question is that eventually I'm going to move this into a sustaining phase and will be trying to engage with external users to update data based on the company they work for. My goal is to limit view access based on organisation(s) or maybe an organisation and country. These are all currently captured in the database.
Creator Free/Trial
We're on a Z-CRM Professional account & have upgraded to a Z-CRM Enterprise 15 day trial to test-drive Creator. However, when adding the ZohoCRM field to our test-app, we get prompted to upgrade Creator to a paid version. How are we meant to properly test drive Creator if there's restrictions like this in place. Particularly coming from Z-CRM to Creator on a trial then finding out you can't hook the two together is, well, somwhat pointless, to put it nicely :) Thanks, Raoul
please add individual days of week to schedule frequency options
Please consider adding the days of the week as options for scheduling so that scripts can be set to only run on specified days - for example only on business days or only on weekends. Checkbox inputs would make this more flexible: [] Monday [] Tuesday [] Wednesday [] Thursday [] Friday [] Saturday [] Sunday
Default Values not working on Excel Import
HI There - It's Day 1 of Zoho for me and so far it's making sense. One issue that I need help on... My form has about 30 fields in it. Four of them have default values set up. When I start adding records I will always be importing an Excel file. The excel file only has 10 fields in it -- none of which are the ones that are supposed to have default values. After the import, the ten fields are populated, but the default value fields are not. What am I missing? The default fields do work if I enter
Script of Subform
hello, I have a problem with the subform, if i insert a subform in new form, it will be inserting without his script. Please help me.
Public form for data entry by staff
I have a public form that uses captcha and sends two emails. One email is established under Set Email Notification, is sent to staff, and includes user submitted data. The second email triggers on Success and goes to the email account entered in the form. Because the form has hidden fields, I do not want to sent user submitted data back to the public website visitor. My challenge is this: Sometimes staff need to add data from hard copy, i.e. printed forms that clients have filled out. When staff
Displaying Subform records in HTML View
I am trying to display all the subform records that are submitted on the within a single entry of the parent form in a HTML view. My code is below, I cannot seem to get the loop right. It is only showing a single entry on the HTML page. htmlpage Call_in_Report_HTML(ID, Id1) displayname = "Call_In_Report_HTML" print = true pdf = true content <%{%> <div style="width:95%; margin:0 auto;"> <%a = Call_in_report_new [ID == input.Id1.toLong()]; for each a in Call_in_report_new [ID == input.Id1.toLong()]
Problem in migration tool from ms acess to zoho
when i am trying to upload to zoho server by migration tool , i am getting this error : "Problem encountered while creating the application , lexical error at line 465 column 35 , Encountered :&it ;EOF> aftre:" reffering" ;"
Embedded Google Calendar Permission Error - ICAL feed
I made a change to one of the ICAL feeds on my Google calendar that is embedded in an Zoho Creator HTML view and now I am getting a permissions error ("Events from one or more calendars could not be shown here because you do not have the permission to view them.") when I try to view the calendar in Zoho Creator (without being logged into the Google account that owns the calendar) I have re-added the calendar feed MULTIPLE times with the Public setting (altough I think that the first time I added
Linking requests
Hi. Is there a way to easily link requests which are related? I'd like to be able to create a new requests when a new piece of work is generated from the original, but link it back. Is this possible? Thanks.
moving entire records across applications
I'm trying to push entire records from one application over to another and can't seem to get the scripting right. There's several forum posts that talk about how to move specific fields (but the getAll() function doesn't appear to work when dealing with the entire record), and there's descriptions of how to use lookup to pull one record (which requires dealing with each record individually). What I'm trying to do is move batches of entire records. Take our call centre activity for the day and assign
Help with scripting function
Please can someone assist me with this. I've created a simple app which consists only of 2 forms to simplify the problem. The forms are Quote and Items. Items is a subform of the quote form. I'm trying to script a custom function which will add a new record in the Quote View which has the same data as the original record INCLUDING the data from the subform. Here is what I've done: void revise(int ID) { dat = Quote [ID == input.ID.toLong()]; subform = dat.Items; name = dat.Customer;
I need to update a sub-form with information already preloaded - how can I do that.
Hello everybody, I am trying to create a form of sales order but that contains all the products listed in the products database to enter quantities and calculate the sales order amount. I am trying to use sub-forms to do it, but I don´t know how to display (one per row) all the products available in my catalogue. Anny suggestion?
How do I get rid of these items on my application?
Hi there - just wondering how I change my application HomeScreen - see attached picture I have decided just for ease of use to use a stateless form instead of an HTML generated view Thank you Jonathan
form embed in website
Dear Team Zoho creator is first full feature web form builder available i m not sure how many free users you have , recently you have changed the option of embedding the form with login details . I would like to suggest to please allow us to embed form without login details if you like you can reduce the no of application to 2 or even 1 for the free users thanks
Allowing Users to Edit their profiles WITHOUT registering for Zoho
I am creating a Teacher Directory for our non-profit organization's website that will allow the students & families to search our directory for a teacher that meets their child's needs. But before I take the directory public online, I have discovered that there are several teachers who filled out our original form but left out several key fields (i.e. Address, etc...) I have developed an App that will (in theory) allow each teacher to view & update their own profile by way of creating one view
iFrame Video within a Form Notes Field
In a form notes field you can format text and insert images - I would like to embed a video - the reason is that I am creating a "Frontpage" for the application in a stateless form as its much easier that fiddling with HTML for me anyway! When I open the notes field to edit and switch to source, I can paste Vimeo iframe code into the field. Then, when I switch from source to a real view then the video still appears. I then save the notes field and it seems as though the iFrame tags are then stripped
basics offline options
would be possible to imagine a very basic offline version of zoho creator? in my opinion very basic means possibility to store locally added or modified data and upload them asap. conflicts can be solved manually one by one. working on windows at the very beginning also on bb iphone android in a short period. inm ready for a small mounthly investmnt for development nt in this direction assuming the option can be ready in aprox 6 mouths. thank you
comparing fields with nulls and spaces
I have a multiline field on a stateless form and on a corresponding master form. In the on load section of the stateless form I set the value of the stateless form field to the value from the master form field. On submit I send an email if the information was changed. The problem is the email is triggered because the master field has a value of null and the stateless field has a value of blank. Is there a better way to compare the two fields so that nulls and spaces\blanks are treated the same?
Links on Sections
I have rearranged links in the sections i want, the question is how can I hide some sections from some users when they log in?can I do that dynamically or there is another workaround?
Change or Allow Customization of HTML header Information
This may appear overly critical, but I'd like to know if the header info can be changed or enabled for customization. Example, in my app when viewing a page, the browser tab shows this because the html for the page has this Additionally, I'm using a web-service to post to Facebook as a linked post. Here's how it looks: Request: I'd like the "Zoho Creator" text removed from the header on all pages, or changed to the application name, or enabled for customization per application. Cheers, John Whitney
Email validation
I want to create a script on user inpit for email field to check if the user entered email id belongs to particular domain e.g. i only want to accept user having gmail id , i.e anyone other than user with gmail id should get error message if ( imput.email_id ! = "what shall i put here @gmail.com { alert( " Please enter your gmail id") } thank you for your help
Cannot Create Reports
As per other users, I am using a free account as a proof of concept for my organisation, but when I try to create a report I get the message that my account type is limited to 2 reports and I have 0. The fix has been to update the reports count for other users. Please fix my account as well. Thanks in advance
Next Page