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.
Please help: Boolean expression to show who should be in attendance...
I have a list of participants, they have 5 checkboxes on their record signifying Monday through Friday. I also have a form for attendance. I would like my attendance for to simply have a yes or no next to the participants names'. What I can't figure out is how is how to display their names with a yes or no radio based on if they are supposed to even be here on the given day. For example, if today is Tuesday and I have 5 participants schedule to attend on Tuesday, and 7 total (2 not scheduled for
Snake eating it's own tail?
I could be wrong but this seems like it could be really bad. Does not Zoho worry that by having a marketplace where developers can quote, build and charge you for their knowledge it could hinder the concept of public applications let alone community support? I mean I have many questions about how this system works and I worry that little if any will get any attention from people who know what they are doing, if I knew I would certainly sell my services and feed my children than give away the knowledge
Freezing Screen when trying to access With Action - Free Flow Scripting for a Form
I can access the free flow scripting for a form and all other actions, except for with action. Everytime I click on this link my window freezes. There is scripting information within this link that I need to view. Is there another way to access the scripting information?
Why is my Home Library application not showing on my blog site?
Using Zoho Creator, I created a Home Library of my DVD collection, then developed a "Borrow a DVD" application which I embedded on my blog site. The application contained fields by which my friends could fill in their name, phone number, e-mail address, etc. for whenever they wanted to borrow a DVD. Everything looked great. The next day, however, the application form could not be seen, but in its place was a Zoho login form. Why is the original form not showing, and how do I get it back? (BTW,
Can I upload a new sheet with the Zoho Sheet API?
Hello, I'm trying to implement the Zoho Sheet REST API from within Creator, uploading some CSV data. I call a postUrl sending data using the following code: url = "http://sheet.zoho.com/api/private/xml/uploadbook?apikey=<myapikey>&ticket=<myticket>"; data = map(); data.put("content", mycsvdata); data.put("workbookName", "TESTUPLOAD"); data.put("contentType", "csv"); response = postUrl(url, data); which executes without error. When I look in Sheet, the new Sheet is there with the correct name, but
Share to Users - Customize Message
I am trying to find where you can change the default customize message that appears when trying to share a view to another user. Can this be done? Thank you for all your help
Show address in form when organization name is chosen
Hey guys! I have a drop-down lookup field listing organization names (names come from the form "organisation" which also contains other information on the organization, hereunder the address). When a name is selected I would like the address of the organization to appear as text underneath. How can I do that? Thanks in advance... J
Autofilter Picklists
Hi - I currently have a form, called form1, with a last name and first name lookup field. The lookup fields arepopulated from a single line field on another form, called form2. I am trying to figure out some scripting that will allow me to have the first name lookup field, on form1, autofilter so that when a last name is selected only the corresponding first name will be displayed. (For example, if I have Bob Jones entered on form2, then when I select Jones from form1 I want the first name lookup
Any suggestions for Zoho Creator Application Development Form, View, & Function Naming Conventions
Hello. While considering that good and proven software development techniques utilize some form of standardization of naming conventions database methodologies I'd like to know what the Zoho Creator user community is using to make their development projects easier in order to conform to naming standards and database normalization. This is what I'm planning to use for naming conventions (for the actual "link name" as the form will have its regular name in the "XXX" part of the form name): Forms -
Need help undoing an import of info into a database.
I need help! I was managing an email database and thought I'd somehow deleted most of my records, so I imported them again from a backup, only to find out that the original records were there but hiddend because of a search I'd previously used. Now I have a database full of duplicates (my original info, which I'd spent hours editing, is what I want to keep!). Is there a way to remove the info I most recently added in one go?
How to create a user login audit trail
Hello. How can I create a user login audit trail every time a Zoho Account user logs into my application? I need this for an audit control functional requirement for an application that I'm building. Any solutions / suggestions would be greatly appreciated. Thanks.
Combining Zoho Creator and other Zoho Apps like Zoho Forums, Invoice, Business, Share, Wiki, etc.
Hello. I'd like to know if any of the Zoho Creator developers out there are using Zoho Creator with other Zoho Apps and how well they interface together in allowing bi-directional communication (whenever possible). My interest in this is due to that fact that I don't want to reinvent the "wheel" so to speak if a Zoho App already provides the functional capabilities. For example, I have functional specs from a client that requires a Web Application where the majority of it's functional requirements
order by into a view passing parameters via the url
I wonder if there is any way to apply "order by" into a view passing parameters via the url. Thanks! Sergio Galiano
Experiments with some built-in Map and Field functions ...
In this post ... http://help.zoho.com/portal/en/community/#Topic/2266000000625224 ... user srhyne (Stephen to his friends) mentioned ... Put all your form fields and form values into a map variable WITH 7 LINES OF CODE! fields = getFieldNames(); form_map = map(); for each field in fields { value = getFieldValue(field); form_map.put(field, value); }Being the "push the envelope" kind of guy ... my immediate thought was ... Can we reduce this to just one line of code ? What if you could create a User
Next Page