How can I monitor my users?
Hi, I've just built a new application and want to make sure my remote users are using it correctly. How can I monitor their activity and undo errors as necessary? Thanks
what, really, is an application?
Hi, I am using Zoho Creator, new to it but I do have an MSC in I.T., I totally get Zoho Creator, no problem, even with limited experience on it. What I cannot seem to wrap my mind around and cannot see from the knowledgebase is the answer to this question: what exactly is a zoho creator application? Of what consequence is it? I mean, say i have 30 forms i plan on building, why should i not dump them into one application, even though they may not be related, as opposed to create a separate application
Multiple attachments of xls sheets in scheduler
Can i have 1 schedule command that has more that 1 attachment in it? It seems silly to have multiple schedules for multiple docs at once.
data entry focus
While entering data in to the application, pressing enter takes you to the next data record..this is good. ... but... the focus remains on the last used control...which is not what most people would expect i guess tommyjonas
Links stopped working in zoho creator from 2010 how to I update the links so my website updates correctly??
A former coworker set up the zoho database in 2007 & 2008 with various views that would automatically show up on our website, and the links used to work correctly.. now the website will not update with the zoho creator data. HELP!!! here is one source page of the website. where the heck do I find the new or updated link for zoho creator? it's supposed to automatically populate the following website: http://www.hchlibrary.org/gala/sponsors2013.php <title>The Henry Carter Hull Library | Gala
Creating a Function - variable not decleared
Hello, I have a script to calculate prices in a subform. This script is duplicated in three fields price, quantity and discount. I want to create a custom function called 'Price calc' so that I can alter the script in one place. To create the function I'm simply copying and pasting the script from one of the fields, into the Function script area. However I get several variable undeclared error when I try to save the function. What am I doing wrong. Thanks Stephen
using business name in application URLs instead of personal user name
The Zoho Creator URL structure is: creator.zoho.com/[user.name]/[app.name]...etc. I would prefer not to have my account's personal user name form part of the URLs of my apps in Zoho Creator. My account is for business use and I would like the URLs to reflect the company name (or an abbreviation) instead. I understand it is not currently possible to change this without going through the hassle of creating a new account. This seems very inflexible and counterintuitive for business users where the account
Form update button at the top
I would like to suggestion adding a form update button at the top of the form. A few of my users have requested this feature as I have some very long forms and when they want to edit records, they have to keep scrolling down to find the update button. Can you please add an update button to forms at the top of the form?
linking two forms
if i have two foms 'a' and 'b' . while validation form b i want to check whether it is already in form a and if it is there then the form can be submitetd.how can it be done.?
Differential User Permissions
Just occurred to me that there's no simple way to have differential user permissions for a view. For example user john can delete while user jack can add and edit. I know I can edit the forms tied to the views to allow this but it seems to me this type of segmentation of user permissions should also be available in the view context. For example, in the image below, it would make sense to have a drop-down list of all users with the ability to customize permissions. Maybe this is the group-sharing
Simple filter
Working on my first app, I'm just trying to put a date filter on a report to show records for the current year. I created a custom filter and chose date field After 1/1/13. I get an error message saying to please specify proper criteria. I've confirmed that the field in question is indeed a date type field. I don't know what I'm doing wrong - it seems pretty straightforward.
Open a Record View Without "Edit"
Hi I have a very simple question: How can I open an entry in my creator database (in the records tab) by simply clicking on it. Much like in Zoho crm all I have to do is click on a contact, for instance, and it opens up a view of the record. How can I do this in creator without needing to go to "edit"? Thanks,
Viewing multiple records in multiple forms?
I have a clients form that serves as a lookup field for multiple other forms -- for example, a documents form, a phone calls form, a meetings form, a notes form. So, each document, phone call, etc. is tied to a particular client. What I want to do is create a view or views that allows me to select a particular client and then view that client's information alongside each record from the other forms that are linked to that client. In other words, if I select John Jones as a client, I would then see
SUM Function
How do I add a SUM function into my script? jsoto
Error duplicating view
I get the following error when I attempt to duplicate a view from my application. Original view: https://creator.zoho.com/essistmgmt/assets/#View:CONTRACTED_ASSET_View Note, the application is shared for support editing. Can you please investigate?
Form stopped working overnight
I haven't changed anything about this form, which we use every day and have been using for over a year now without issue. All of a sudden this morning the "on success" script is not running completely. I get a "Data submitted successfully" message *and* and an error message. Is this some temporary technical issue or did Zoho implement back-end changes that I should know about?
Error on success Edit record
I have this Error. It show after edit any records, after press Update button. If delete all code in On Success block in On Edit scripts - no this error. But if add any code, like sample "x=123" or just comment "//test comment" - always have this error. How to solve this?
Formula between multiple forms
I'm unfamiliar with the scripting language and I'm creating a database for a non profit managing the inventory we maintain. I created a form for the individual Inventory items. I'm on a second form an Order form where I added a lookup field linking to the Inventory item. Another field on the Inventory form is Cost. I'm trying to create a formula field on the Order form that will add together the cost field from the inventory page for each Inventory item selected. Making sense? Thank you!
adding a value to a longlist field type in DS
Hi, FormA has a lookup field of IDs from FormB called formb_ids. I would like to update formb_ids (add an ID to the longlist type) with a variable v. How is this written in DS please?
Message field in "Scheduler" not accessible
I am trying to create a schedule for one of my forms; specifically, trying to program the app to send out an email alert one week before the driver's license of the company vehicles' drivers expires. I run through the "When to do" but when I get to the "what to do" I can only get as far as inserting the message subject. The field for the actual message is visible but not accessible. I cannot type on it and it does not show the tabs shown in the "Message Subject" field (Insert Expression, Switch to...).
Paypal Integration question
Hello, I have a quick question on how paypal integration works. When the customer is making the payment from a payment form setup through creator, during that process do they have to create a paypal account or can they just pay with their credit card? As a note I do not want that to be the case as it makes the payment not very business friendly. I want a customer to be able to just pay with their credit card. Thanks David
Import from Google Spreadsheet with Merge
Is it possible to import data from a Goole Spreadsheet using merge data so that records are edited not just added again? Just like in the migration tool?
Has Zoho changed the login process for new accounts?
It appears that Zoho has changed the login process for new accounts. Previously when a new account was created Zoho asked for a username and email address. Once the account was created the username was required for login. Now when a new account is created Zoho does not ask for a username, but ONLY an email address. The email address must be used to login. I have 75 users who were set up with usernames. Can users still log in with the username? Or do they have to use the "email address" associated
Delete a View
How to delete a newly created VIEW. Made a duplicate View by mistake and want to delete one of them.
HTML views
Hi Zoho, I was wondering if you have some information on how to create html views. I have read this article: https://www.zoho.com/creator/help/views/create-html-views.html I don't find it that useful. I am looking for some more detailed information about how to insert deluge queries into the html code. For example i would like to create a table. In that table I would like to get values from one of my forms. At the top of the table I would like to have a user defined field where the user can choose
Views: Is it possible pull a value two tables away?
I've searched as best I can, but I'm falling short on terminology. Forgive me if this sort of thing should be easily answered. Here's a description of my project: We are using our Zoho Creator database to record interactions with school groups who visit our institution. Each Interaction is tied to a School. Each School is tied to a School District. Interaction --> School --> School District Our institution receives tax support from a given region, and schools belonging to districts within that
No <return> allowed in message body of scheduled report
When you create or edit a report schedule (under workflows), and would like to modify the message body of the email message such that something meaningful is added to the report attachment, then you cannot use a <return> to start a new line. If you do, you will get the error message "Error in scheduling parameters: null", which is not telling you what's wrong...
Auto fill a field
Hi! Here is my situation: 1.) I have a Dropdown field called Property Sub Type & Description with several choices (e.g. 105 Commercial Real Estate - Retail, 107 Commercial Real Estate - Lodging/Resorts, etc.). Next to this field is a field called Property Sub Type. What I want to happen is have the field Property Sub Type field auto filled with the data being put in Property Sub Type & Description field but with a bit of modification. E.g. If user chooses "105 Commercial Real Estate - Retail" for
Adding a additional field in subform
Hi All, I am developing Tour Plan application for a Pharma company for MR. I have 2 forms: Employee: Employee ID, First Name, Last Name, Location etc... Leads: Company Name, Contact Person, Lead Type, Phone, Address, City Now i am creating a form called Tour Plan The First column will have drop down menu to select the Employee First and Last Name. Once selected, it will fill all other information from the Employee table. The second part is to add Leads. I am using subform. The first column in subform,
How about a India phone number for Zoho creator support?
Or do you just not care anymore? Varun.
Support page not opening!
I've been facing this problem since two days. Any one has an idea? Varun. Note: I cannot locate the link to the support page on the new builder. But a search threw up the support page and THIS page seems to load alright.
What's going on with the login? Where are usernames?
I have 75 users created with username and password. Suddenly I am unable to create an account with a username, apparently I MUST use the email address. This has created TREMENDOUS confusion. What happened to all the accounts created with usernames? How do they log in? Do I have to tell everyone to use the email address to login? Also when I try logging in with the email address, Zoho creates its own username which has nothing to do with the email address. What in the world is going on?????????
How could you change Font Name and Font Size in ZOHO Creator Embeded View?
How could you change Font Name and Font Size in ZOHO Creator Embeded View? Thanks.
Formula field on form not working
I have a form where users enter the amount of work they have completed. Each type of work has an RE. E.g. An 'Enquiry' has an RE of 0.5 and should take 30 minutes to complete. I need the formula field to calculate the users output based on the RE, based on the number of 'Enquiries' they have actioned. i.e. 2 'Enquiries' should return "1". My formula field (I've tried differences in the formula, but I'm more used to Excel): (input.Enquiries * input.RE_Enquiry) Error: com.adventnet.ds.query.QueryConstructionException:
I want to duplicate an App but its not working
Hello Friends I have been trying to duplicate an app but it loads then returns back with nothing, i tried creating a fresh form and duplicated it, it worked, but each time i try to duplicate my already Coded form it won't what could be the cause?? Thanks Presoft
Creating a Group is Broken
I have started to create groups under my other account "sigroup", and when I select to add members, it's not showing any. I have almost 50 users under this account. When will this be fixed? Cheers, John Whitney
Sorting within report
Hi, Been trying to sort by the Make in ascending order. doesn't seem to be working
WordPress plug-in
If you guys would write a WordPress plug-in to allow me to embed these forms into a WordPress blog, all my worries would be over. Are you working on a WordPress plug-in? If not, why not?? mmcadams
Sum Enabled Formula Column
Our company manufactures a product that is measured by pounds. In my form, a user can insert the total pounds of an order and the price per pound. Then there is a formula field that calculates the total value of the order. What I want is for that formula column to display the value of each order (which it does) but also the sum of all the orders at the bottom of the view, so that we can see the total value of multiple orders. However, the "formula" field doesn't currently support the "Sum" function
Decisiion Box Values
Hi all, Am a complete beginner to Zoho Creator. I would like to make a form that has a persons name and then a list of Decision Boxes: Item1 Item2 Item3 Item4 Item5 Each Itemx has a value. Depending on what boxes have been checked a total should be displayed I can set the form up with no problems but I cannot figure out how to display the total How can I go about doing this? Cheers Rich
Next Page