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
Formula Fields Not Updating
I use a lot of formula fields for simple things like displaying full names of a contact or creating a URL link to a details HTML page. Quite often the formula result does not update or gets somehow corrupted... This has been happening for a long time but I'm only now getting around to reporting the issue... Simple example. 'Admin' Application, 'Contact' Form, 'NameEmail' field has formula = First_Name + " " + Last_Name + " - " + Email Right now, the majority of my contacts are displaying first and
Populating fields with data from related different forms
OK Here is an issue that I have tried to simplify: My application has 2 forms MAIN DATA MAIN which has 2 fields MainSalesPerson - LOOKUP (linked to DataSalesPerson). MainEmail - Fetch data from the DATA FORM DATA which has 2 fields DataSalesPerson - TEXT INPUT DataEmail - TEXT INPUT In MAIN, on user selection of MainSalesPerson, I want to fetch the corresponding email from the DATA form field DataEmail and display it in the MAIN Form field - "MainEmail". I cannot seem to understand how to get this
Update a field in one form when field is changed in another form
I have two forms one called application the other enrollment Both forms have a field labeled status I want the status field in the application form updated when the status field in the enrollment from changes I do not to open the application record in order to have the field update Any ideas
Posting data from Zoho to REST Api
I am trying to post data from a Zoho form to an API through XML so that I can push a list of updated records upon each add or edit to the Canvas API. This should be really easy, but I am not grasping the concepts of the built in function for HTTP requests. Could someone help with some sample code? Look at the reference data API starting on page 12 of this document: http://www.gocanvas.com/content/images/file-uploads/Canvas_Webservices_-_version_1-3-0.pdf Trying to do something like this in deluge
How to get the current date
How to get the current date
Merchant Services
We are looking to Zoho as a possible solution for the database needs of a small cell phone repair company. One of our needs is Merchant Services. We understand that Zoho added a Paypal option a year ago. Does the customer have to have a Paypal account? Or will he or she be able to pay using an American Express? Please let us know. Thank you, Tom
Can you have creator return on the first character in a field
I send out emails from zoho on record updates The form includes a students first and last name I need the subject line of the email to only include first and last initial Ideas
How to enable and disbale the tabs based on some condition
How to enable and disbale the tabs based on some condition? For example iam having 4 tabs. If iam loading second tab i dont want to show the 1st,3rd & 4th tabs to the user.
problem with condition evaluation
After the last update, some of my html views generated errors. The problem is that it is a very used piece of code which was correct until last update. An example: if(recid != null && Contacts[ID == recid.tolong()].count() > 0) { // some piece of code } Iff recid is null, the code Contacts[ID == recid.tolong()].count() was no more executed . This was the behavior before the last update and it was convenient. The condition checks if the record is null and ONLY if it is not null it checks if there
Please tell me if this is possible in ZOHO.
I am going to build an audit form that will submit a bunch of building data into a database. Example data: Building Name Building Address Owner Name Existing Measure A - Potential Measure A Existing Measure B - Potential Measure B I'm then going to submit this data into a database. Here's where it gets tricky: A) I want to be able to pull this information back out of the database into the exact same form (so I can pull up any given site and see the full details again and be able to modify it (possible?)).
Error Occurred While on Success Script
Users are reporting this error on one of our embedded forms [Note to support: it's the "Hell's Kitchen" form]. The rest of the error message isn't very helpful: "We are working on giving more meaningful error messages on script failures". What are we supposed to do with that..? The user in question received this error 4 separate times, waiting 2 hours between each submission. I have enabled support edit access. We need to address this issue very urgently.
Next Page