problems editing in grid form
When editing in "grid" view I make all the changes I want however when i hit the save button it brings up an error message telling me that the records i tried to edit could not be saved. When editing in regular list view i can edit each record but once again grid form which would save me a lot of time is not working at all. PLEASE HELP!
"More actions" in embedded page
Hello everybody, I need to create a customized web & DB for a client and this obliges me to use the embed function, as my client needs a personalised URL, a header with his logo, contact info, etc. on top of the DB Everything seems perfect, but now I found out that the "More actions" menu is not option in Permalink/Embedded and I really need it so my client can export his DB, print it, etc. How can I sort this out?. Best regards and congrats for offering such an excellent product.
Cannot sennd email with attachment
Hi, I cannot use schedule to send an attachment with an email. Attachment is a view. https://creator.zoho.com/pranavdalal/findata/schedule/edit/ If I remove the attachment the mail goes through. Please let me know if there is something wrong with Attachment syntax. Thanks -Pranav
Tracking League Tables
Can somebody tell me if it would be possible in theory to create an App to monitor and track league tables using Creator and have these link with a players CRM profile? I'm running an Enterprise trial at the moment, and was just hoping to get a steer before I start the steep learning curve! Thanks M
Multi Select addition
I was wondering if there was say a formula or something that would add up each time an option in my multi select gets selected, and maybe total each option?
Functional URLs
I have a very simple search (Find nearest instructor). I want it to take the first half of a postcode (HU3, HU6 etc etc) and display records that match. Honestly thought I had it, but seem to be stuck! Any ideas (edit access given in hope....or maybe desperation!!)
Add or append values to a multiselect list from within a function
Hi, Am trying to do this Form A has a multiselect list could be (list or lookup) with say A, B, C From within a function i want to write "D" to the list, it does not get updated as D is not part of the list defined in Form A uu.Multi_Select_1 = thelist; (where the thelist contains D) Basically i am trying to emulate ui.add or ui.append from within a function Is this possible, i can live with a blank multiselect in Form A to which i can write any type of list also thanks
Update Multi Select lookup via scritp not following list order
Hi, I have a form with a multi select lookup field no alphabetical sorting set on the lookup field My other form which has the lookup values has lets say rows A , Z 1, Hello From a script i update the lookup field and my List:String({"A", "1", "hello", "Z"}); Problem, the updated lookup is not following the order of the elements of the List:String which i used Actually not sure what order it is following, maybe that of the form lookup, all i know is that it does not seem to follow the order i want
Lookup Criteria
On a form I have a lookup to another table. I want to omit records where a string field is longer than 5 characters. When I add this code to the criteria section of the lookup field Str_Field.length() > 5 I get this error Either the left or the right expression in a boolean expression in the criteria has to be a Form/Table Variable What steps do I need to omit these records? Herb Wexler
Tier 3 menu creation
Hi .. In my application The Top Menu is my Main menu and the Left menu is the Sub menus of main menu . Now i need a Popup menus for sub menus of Sub menu . Is there any possibilities to create popup menus or sub menus of sub menu Ex: Tier1 - Money Fact ---- > Main menu (top menu) Tier2 - Real Estate ----> Sub menu of Money Fact (Left menu ) | | Tier3 - Getting started Ownership These are my Sub menus of Real estate
How to? publishing app to marketplace that requires certain views to be set as public, views within HTML views to display without login.
If you publish an app to the marketplace without code, do the public/private settings for views and forms install with the application? Or would the client need to be instructed to set certain views/forms to public if the app requires it to function as intended? What is the best way to code a printable HTML with an embedded view, so that the user can then embed this HTML view into their website and display it without login? So far I see only two ways, make the form view public and use the "embed
A Behind the Scenes Look at Zoho Creator
In this post, I want to provide a behind-the-scenes look at Zoho Creator, a sense of what all of our engineers are doing. First, to step back, Zoho Creator was born of an idea I had way back in 2002. I sketched out the underpinning of a programming language, with some strongly held convictions born of my own experience. In the beginning, that language had no syntax at all - it was living purely as a set of database tables. In programming language parlance, I had defined the "abstract syntax" of the
How to add data to Zoho table from HTML view?
I have an HTML view that displays data from a ZOHO table called "Options". The HTML view also displays a radio button in the first column in each row of data in my view. Up to this point everything works fine. From here, what I would like to do is to allow the user to use the radio button to select an item in the HTML view and then save the selected item to a different table called "Selections". There must be a relatively easy way to do this but I am just not sure how to pass the user's selection
New User instruction
I am a new user, are there any instructional videos taking you through the basics, I will predominently be using the SFA features and so am interested in creating call backs, reminders and possible mass emails
Create records in one form from a multiselect lookup field from antother
Wonder if someone can help; I am trying to find a way to select some records from one form and then use these to create new records in another form. At this point I have created a stateless form with a multiselect lookup for my unit "serial number"s and an action button. I have then tried to create a script for the button; 1 for each key in input.Serial_Number 2 { 3 insert into test 4 [ 5 Added_User = zoho.loginuser 6 Serial_Number = input.Serial_Number 7
Making a field required - code not working
I'm trying to make a field required if the check box above it is checked. This is the code I've input, but it comes back with an error. ((input.VAT_registered == "yes") && (input.VAT_number == "")) { alert "Please enter VAT number"; cancel submit; } Please help! Thanks J
next url doesn't redirect
"next url" doesn't redirect but attempts to open the url within the iframe.
Any way to sort forms listing when adding a Lookup drop-down menu?
As the image below illustrates, there seems to be no clear order or logic to the listing of forms and their fields that is displayed when inserting a Lookup drop-down menu into a form. My application has many forms, including many that are not in use, so the listing of forms is long. So, when inserting a Lookup menu into a form and needing to identify the field of a particular form to import from, the long list is unsorted... clearly it would be better if it were alphabetical by form name. Is
Recommendation: allow some simple layout control in live Form views
I'm sure most of us have at one time or another wished we weren't constrained entirely to only one way to have our forms laid out. Currently, like it or not, we must all live with two vertical columns for fields that stack vertically into those columns -- one way. Well, it could be worse, but it sure would be nice to be able to have greater control of that layout with more variety of options. One simple option that would make a world of difference in some forms would be to control the width of
sendmail with for each function
Hi, I have a form in my application https://creator.zoho.com/username/consulado-app/#Form:Arquivo_Cform in which I have a sendmail function for each email in a field. This is a multiselect field and the first data inserted was correctly sended to the emails selected in the multiselect field. But when I try to insert others data with differents email seletect (field Funcionário) zoho sendmail at all email selected in the data inserted before and also at the email selected in the new record. There's
Inconsistent behavior in list view with search and page size
Hi List view , i do a search get some results, change page size at the top (see red circle on attached screen shot) Select 10 , 20, 30 40 all good Select 50 and the "Page Size" Option vanishes go to the bottom and select 75, 100, 200 it comes back .. Just the option 50 has the issue Must be it is i hate "50" at Zoho day
Non documeted limitation - maximum number of Expressions in HTML view in Edit Mode
Dear Zoho Creator Team, What is maximum number of Expressions in HTML view? According to my testings more than 200 and less than 400. And limitation is that HTML view with such number of expressions is loading FOREVER in the browser. Limitation is presented in IE, Firefox, Chrome. Below are described steps to reproduce this behavior. Step 1. Create HTML view: htmlpage Expressions_400_Bug() displayname = "Expressions 400 Bug" content <%{ a = "b";%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%>
Zoho xml rpc request returns success but no record in database
I have problem with my application, when i try to insert record from custom html form from localhost i get success response. But when i try to view records in the database view the record is not there. And if i delete record from my view and then i try to insert new record i get success result and the record is there i can see it in the view. By the way i am sending the post request with php curl and it is working ok Any help with this will be appreciated. Here is the code: $apikey = "xxxxxxxxxxxxxxxxxxxxxx";
Share Bug
I made my application public then reverted to private. Then I attempted to share with a user and got: buzzap/abis is shared with ZC support Cheers, John Whitney
Set subform field only to Display
Hi ZC Team I have a Form with a subform, when I click on Add I have a field on the subform that is completed with a value existing on the parents form. What I want is to show as today but disable the possibility that the user update that Field (is a dropdown field) I was trying at subform level on Load Add disable but it doesn't work, is any way to only display a field in subform and avoid alter it?, please let me know. Thanks a lot. Victor Miranda
"Other Postal Code" Field Error
Hi I have written a form here: http://www.rentlondonflat.com/rent It works fine in Zoho Creator. All the data is recorded. Everything we put in the form is recorded into Zoho Creator and we can access data there. There is also a script which passes the data to Zoho CRM. All this also works fine as well apart from one field. The field to which we are trying to pass the post code across from Zoho Creator to a "Standard Zoho CRM Field" called "Other Postal Code". This is name when set to UK English.
Form relationships
It all starts with the need for a calculated field on a report. I need to multply a price from an inventory form by qty from an activity form. I have related the forms by lookup in the activity form. My thought is to create a calculated field in the activity form but I don't have access to the price field from the inventory form despite the lookup and relationship. What is the best solution? Thanks
Given several applications and many users, how can I associate applications to users?
I have 3 applications and 5 users (u1,..., u5). I want application 1 to be used by users U1, U2 and application 2 to be used by users U4, U5 and application 3 to be used by user U3 only. I will be the admin for them all. Is that possible in ZOHO Creator? Thanks.
form asking for login details
Hi, The form I created for our website is now asking people to enter login details. We're on a free account but don't appear to have exceeded any of the imposed limits. Any help would be really appreciated. Thanks, Joe
Backup limitations?
Hello, I wanted to ask about the limitations of a Zoho Creator Application Backup. Does the backup contain uploaded files? Does the backup contain application permissions? Thanks
Can I see an example of a application that manages relationships?
I run education programmes for schools and need a decent database. I need to be able to look up what instructors have delivered what programmes, what sudents have been on what programmes and create relationships between instructors and programmes, clients and programmes and students and programmes. I have hada look at Zoho but I cant see anything that will provide an example of what an end product might look like. Do you have any examples of how clever Zoho Creator might be?
Using zoho.adminuser variable instead of static "ownername" in urls
I want to publish an app to the market place without code, ie client can't have edit mode. I have certain html views that happen to have url links that include my app_owner_name. The variable zoho.adminuser returns the username of the application owner. Is there any way to construct an url to a view/form with the variable instead of the static <ownername>? Example: http://creatorexport.zoho.com/myname/app_name/print/printable_HTML_view Where zoho.adminuser replaces "myname" so that anyone who downloads
How do you update a CRM record from a Creator form when you don't know the CRM ID?
Hi I have a script which simply adds a record via a form to Zoho CRM. tenantinfo = { "Salutation" : input.Salutation, "First Name" : input.First_Name, "Last Name" : input.Last_Name, "Mobile" : input.Mobile_Number, "Email" : input.Email_Id, "Date of Birth" : input.Date_of_Birth, "Employment Status" : input.Employment_Status, "Organisation" : input.Organisation, "Monthly Income" : input.Monthly_Income, "National Insurance No." : input.National_Insurance, "Other Street" : input.Current_Address, "Other
Preserve Multi-column Layout for Dynamically Created Radio Buttons
This may have already been mentioned, but I just noticed that setting a 3-column layout is ignored when the radio buttons are dynamically added upon form loading. Thanks, John Whitney
Google Apps UrlFetchApp.fetch to zoho creator session does not close
Hi , Am calling the Zoho Creator get ticket API call using UrlFetchApp.fetch After the call the session remains active on my Zoho Account and as is the case if too many sessions remain open to Zoho the API will stop responding. Anyone know of this issue or knows of a way around it. thanks
Special View Criteria
Sharing a view with a user gives that use full rights to see all the data. What if we only want him to see a sub-set of data? I'm guessing view criteria is not sophisticated enough to handle this. The only way I can figure out how to enable this would be to have a new column in the data with the user's zoho ligin ID and set-up criteria to filter on that. Comments? Cheers, John Whitney
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
On this page: https://creator.zoho.com/webmagnets/view/17/edit/ I am getting this error: [ServletException in:/jsp/edit/view/viewedit.jsp] null'
The Speed vs Quality Tradeoff in Software Development
There are two broad categories of criticism we get in Zoho Creator (and Zoho in general): 1. I asked for this simple thing months, years ago, it is still not done. Is your development team sleeping? 2. How can you put this bug? Is your QA team sleeping? In fact, sometimes the same person would offer both of these criticisms, at once. Let me first say that we have shipped over 20 services in Zoho and we are now on our 7th year. The broader Zoho Corp itself has over 60 products, and has been in business
Help needed- need to total hours worked per person in understandable format
Help needed- need to total hours worked per person in understandable format Anyone know how to do this? I have a formula box that totals the time, but it comes out in seconds, and it would be great to somehow look up each person and get a total in readable hour/minute format. Any ideas? formula zoho end time date-zoho end time date = total time person worked (I have this already) BUT WHAT I really need is a sum of all of the hours that person has put into a work month... Any ideas please help,
In-place editing of a lookup field for multiple records
I have an application for organizing people into focus groups. When a Study is created, the user names 1-n possible focus groups (e.g., "group 1" "group 2"). People are recruited to a study and must be assigned to focus groups. To assign a Person to a focus group, the user needs to look at a variety of background information on each person. Thus, I'd like the interface to look like: (for a given Study) Person 1's name Gender Experience etc... <lookup drop down with possible focus
Next Page