Creator - issue with importing linefeeds
My Excel do contains with linefeeds in them. This is used when creating multiline data cells. When importing this data in to Creator, it incorrectly interprets then as end of lines. The end of lines are actually marked with CR/LF. Anyone any suggestions as to how I can fix this?
possible bug in search box at zohocreator.wiki.zoho.com
Hi nice zoho people, clicking in the search box now seems to refresh the page if you are using firefox 3.5. It works fine with IE. seems to be a new problem since yesterday. have fun! Dax (Devorah) from Stress Recess
How do I keep names in a Single Line form in alphabetical order?
I have created a form called "Add Name" using a "Single Line" box. With this form I have also have a view which can be configured to display in alphabetical order. I have created forms which have a dropdown box with the "Field Type" set at Import Data from the Add Name form. All names where first added in alphabetical order so these are good but when I add an addtional name it goes to the bottom of the dropdown. Is there a way to keep these newly added names in order? Thanks for any help
problem with calculations and the enter key
Hi folks, I have a routine the calclates a total dynamically from user data in 5 fields. The total field recalculates whenever the user enters or changes data in the field. As long as the press the tab key, (or click to the next field), they can see the total recalc as they are working with it. but if they press enter....[scary music]. The enter key automatically presses the submit button before the user is finished. They get red errors all over the page during validation for the fields they
Zoho Creator Enterprise Design Question
Hello. I'd like to ask the user community for some ideas/assistance on a design that I'm working on for an Enterprise client (200 + users) whose functional design specification using Zoho Creator (and yes - they want to use Zoho Creator) is to: 1. Track & Report on National Data - a compilation of each State's Data. 2. Track & Report on State Data - a compilation of each City, County, and Region that utilizes the software for their own respective Entity. The National data will need to be kept in
Creating several entries with one form?
HI, I was wondering if I could create a form that would make several entries to the table? For example, if I am trying to keep a record of my spending transactions. Say I have a Walmart receipt and I want to split it up into 3 different categories with respective dollar amounts. But, I want to keep track of the this particular Walmart receipt. So hear is what I would like to see in the table: Walmart 1 - food - $10 Walmart 1 - household - $5 Walmart 1 - household
question about building combined views,
Hello, Here is my case: I have tables "Officer", "University", and "Country". Officer is one-to-many to University, and University is one-to-many Country. And, Country has a column "Region" I am creating a view of the Officer table. I would like each row to include the Region it's in. (Essentially, I want to display the 'related field' of an already 'related field'... So, when I write the form definition for the View1_Officer, I am having trouble referencing the Region column. For example (this
The irony of "info" feature on Zoho Functions
To Support : Please taken lesson from debuggers like Firebug.. The point of a debugger is to figure out WHY YOUR SCRIPT IS BREAKING! Which brings me to the "info" feature while building functions. Wouldn't it make more sense to SHOW US OUR INFO/ MESSAGE LOGS even when the function does not execute successfully? I think it's sort of odd that the only time you can see a message log is when the function works.. Which in many cases means the I'm constantly commenting out blocks of code to get to a place
Customizing alerts & warnings
Is there a way to customize "Failed to add data" or "Enter a valid email address for.." for forms. with on validate we can write our own alerts but still messages above appears. I would prefer these messages in my native language. I think you can rearrange form bulider to customize these alerts.
Why does modifying a referenced dropdown picklist value generate Creator error in Safari?
When, in Safari browser, a dropdown picklist from another form is modified remotely (as shown below), a ZC error gets thrown (see below).... but not in Firefox, Chrome, or Opera. (Don't have IE to check) The offending (to Safari) statement is highlighted here: r = People [ID == input.Picked_ID]; if (r.State != input.Verify_State) // "State" is a dropdown list { r.State = input.Verify_State; // this statement throws a ZC error when executed in Safari } ... where the record in the
Creating multiple records from a single entry...
I have a database for tracking tutoring referrals at a school. Teachers currently select a student name from a dropdown menu, which is a lookup field from another form. They also enter a written description of the assignment in a text field. I would like to be able to choose multiple students from a mult-select field and enter the description for the assignment in the text field -- and have the database create a record for each student selected in the multi-select field. Or... could it be possible
Test data / test application -- how do you do it?
Aside from copying applications to do test, how do the ZC creators structure test scenarios? Is there a way to two applications act on the same dataset? Curious about test/production setups... Ian
if condition then OpenURLl else if condition OpenUrl
erros on the Elfse if, why if(input.I_want.contains "demo" && input.I_want.contains "supportcenter" ) { openUrl("http://www.manageengine.com/supportcenter","same window"); else if(input.Sexe == "M") { openUrl("http://www.manageengine.com/supportcenter","same window"); } }
Auto populate fields (or pass data) between a form and a view via an Action Button
Greetings - I have a question on passing data between a view and a form. Currently, I have a Member view that lists all Members with their first/last name, address, etc. For each record, I have created a custom Action Button of "Add Donation". When the user selects the "Add Donation" button, a popup form displays, allowing the user to enter donation information. On this Donation form, I would like to auto-populate the Members First and Last Name, carried over from whichever record they chose
How to populate an add-notes field with data?
Hey Guys, I use the following code to create an address variable that I wish to display in an Add Notes field, so that when an organization is selected in a drop-down, it's address appears as text underneath. The code below works. The variable is defined. No problem. But how do I make an add-notes field display the data? In the script-section the add notes fields do not appear on the list of fields... Thanks in advance...! J get_address = Organization[School_name == input.Organization]; Adresse = get_address.Adresse;
Simple concept, marking a task or entry as completed?
The simplest way to describe what I am trying to do is a ToDo List... I want a list of things to do (with a submission form to add to the list), then a view of the tasks. Here is the catch, as I do the things on the things on the list, I want (I think some sort of validation formula) to display a checkmark.gif file either before or after the item on the list if it is something I have marked as completed. The concept seems simple enough, is it really?
Anyone having problems with ZOHO Creator API?
About 9 hours ago my web application which uses ZOHO Creator to store/retrieve data has stopped working. All API requests sent via both XML & CSV are returning a 500 error. Basic View requests however are still working Is anyone else having this problem or is this limited to my account? I've attempted to use a new API key - no luck, i Manually tried posting a basic command and get the 500 error. My app has been stable for over a year, and currently my users can't access my system. Cheers Derrick
Zoho Creator's Dev Community
This is in reply to : Snake eating it's own tail? First, Let us give credit to the developers who set the precedent of sharing knowledge and assisting others early on..(years back). I think it's safe to say that if they hadn't set this precedent we might not have this great ebb and flow of responses like we do today. Second, Smart developers/ businesses (I think most ZC developers) gives away scarcity to sell the even more scarce resource more often. What I mean by this... A good developer understands
XML-RPC / CSV-RPC Has Stopped working in ZOHO Creator
A few hours ago, the Zoho Creator API has started returning empty responses. The application has been working for over a year now - so its not a code problem on my end. I receive the ticket ok - but no matter what type of call i make (add/updated/edit) - i receive an empty response Is anyone else having this problem? I'm using the xml-rpc post method also tried csv-rpc. Both return Empty <response></response> no matter what query I attempt to run I setup test queries on my application via a standard
Where is "sendmail script" located?
Where is "sendmail script" located? I can't seem to find it.
There's no way for signed-in users to sign OUT of permalink views -- A SECURITY ISSUE
When my signed-in users access permalinks to views that require sign-in, there's no way for them to log OUT of Zoho from within that view. So, therefore, the user remains logged in even after they close their browser window. That's got to be a design omission. It's a serious security issue in my organization. Zoho Support, can you add a "Sign Out" option in every permalink view that requires a sign-in? Thank you. Please advise. Greg Malone Santa Fe, New Mexico, US
Attached Files
Is there any resolution to the attached file issues? We need the ability to upload using stateless forms move files via script from one db to another possibly rename files delete via script and on forms attach to emails w/out using a link
Need a new SubForum within ZOHO Creator
Stephen Rhyne's topic here ... http://help.zoho.com/portal/en/community/?ftid=2266000000632090 ... prompted me to start this (didn't want to hijack his topic). Stephen's post hilites the general problem faced by Developers working on the ZOHO platform ... not to denigrade anyone, but I am refering to the small group of Developers (usually coming from a background of programming with real languages/scripts) whose specific needs seem to be low on the totem pole of ZOHO Creator's priorities ... yes,
How do I change my e-mail address in user field?
See: dvdborrowing.blogspot.com When the user of this form clicks on "submit," the info is supposed to be sent to my e-mail address. I tested it as a user myself, but received no e-mail. Any idea why not and how do I fix?
Zoho Creater error....again
When I sign on to my db using Firefox 3.5.3, the application stops at "Loading...Please wait". I have shared my application with the developers so they can look to see what is going on.
DB loading issue
When I sign on to my db using Firefox 3.5.3, the application stops at "Loading...Please wait"
HTML view not working with IE 7 or IE 8
Hello. I created some simple tables and am bringing text as a string from some of my scripts into an HTML view and it doesn't view properly in Internet Explorer (IE just shows a blank page) but it looks right on Firefox. QUESTION?> Is there some specific settings to make these HTML views work on all browsers? My clients use a mixture of IE and Firefox. I need my apps to work on both. Any help would be greatly appreciated. Thanks. Update: I get this script error with IE version 8 Webpage error details
docBloc commenting and the result
Hello ZC Support, I used mult-line comments ALOT and I would really appreciate it if we could get more control over the formatting of our comments. It seams that comments are very hard to keep shaped. I use /* */ for commenting out code (whic works great). What ends up happening sometimes when I try to do a multiline comment like this..... /** *this is a function.. *@param */ I end up with weird junk like this..... <br><mybr></mybr><br><mybr></mybr> in my code. I think first having a ds documentor
Is it available regarding its performance for so much records? Is the rapid of SEARCHING in so a huge table available?
Dear Zoho Creator team, Now I have a requirement which need store about 10,000 to 100,000 records in ONE table (or form). Is it available regarding its performance for so much records? Is the rapid of SEARCHING in so a huge table available? Notes: the precondition is the account has the greated authority. Looking forward to your reply.
Email data
Can you email data to a private database or would it only work if the database was public? Thanks, Leo Saumure
Autofilter Lookup field Checkboxes
I am trying to create a way to keep track of a deck of flash cards I am creating. The cards will each have a letter sound (and the location of that letter sound in a word) associated with them. For example: fish - beg f face - beg f dress - end s snail - beg sn I have two forms Card_List and WordsSounds which is a list similar to the one above... just much longer. When you enter the Card Sound on to the Card_List I would like it too look up all the words from WordsSounds that match that sound, then
Maximum Number of Fields in a Form
Where (in the wiki) can I find the official information about the maximum number of fields that can be placed in a single Form ? I am assisting two Clients who have existing Forms with over 60 Fields ... and want to add even more ... so I need to know this limit and advise them accordingly about splitting their information into multiple Forms. I recall a response (on the older forum) many months ago about a number that was dependent on the type of fields involved (some fields took up a 2 count ?)
Failed to Add Data ?
Hi, We receive this error message: "The Following error has occurred while adding this record: Failed to Add Data. We submit validation failed " And we use limits "2 Get Data 500 500 138" Can I upgrade? And how? What's up ? Eric
Bug w/ running total feature in Forms w/ Groupings
I have a Form set up with both Groupings and a Sum enabled for running totals. There is a running total for each Group, as well as a final total for all records. However, the problem is that the Final sum seems to be counting each record AND each group subtotal above 1, which means that some records are counted twice and the final totals are much higher than they should be! Please advise!
problem with form validation
Hi all, I'm writing my first few bits of script. I want to validate a form that has two drop downs. If the first drop down is not set to a value from the list (ie it must not == -Select-) then the script should show an alert then cancel submit. If the first drop down succeeds then test the second similarly. What ever I do the first drop down fails. I always get a message in the status bar of the form with my error message. My condition looks like if ((form.field != "Option 1") || (form.field
Inconsistent rendering in List Views ...
I could swear there was discussion about this on the forum ... but I can't find it right now. Currently, when you have situation (in a List View) where the ... - Column Heading is something like Record Number - the Values for this field are small numbers (e.g. in a range of 1 to 999) ... you end up with a very wide column ... something like this ... Record Number 14 So, the common practice is to define the Column Headings as Record<br/>Number ... so you end up
Charts from non-numeric values (e.g. Yes / No / N/A)
Hi all, I'm building an application to store electoral observation forms on Zoho Creator. Many of the fields in my form are of "yes/no/na" type, for example, "Did the polling station open on time?" yes, no, n/a Now, from all the polling stations observed, I would like to generate a pie chart, showing what percentage of all stations opened on time ("yes"), which were late ("no") and where an n/a was stated. However, whenever I try to build that pie chart, I only get offered fields with NUMERIC values
Copy Form?
Is there an easier way to copy a form than pasting the majority of the script? It seems with Formsite and GDocs it is just a given to have such an ease of operation. Is it something I am missing or is it something that would bring my app down in flames if it were there?
Zoho Creator To Zoho Invoice
Hi, I'm looing at using Zoho creator to capture customer details on my website for new orders and was wondering if there's a way to easily export the customer data into Zoho Invoice without having to manually enter all the details myself?
Grouping parameter by html view???? Possible?
I wonder if it's possible to pass any kind of "grouping parameter" thought a html view??? Thanks Sergio.
Next Page