About ZOHO Creator's Access Control Model ...
Charles: I am starting a new post in response to your response here ... http://help.zoho.com/portal/en/community/?ftid=2266000000389255 ... as it is otherwise likely to be buried amongst other points raised by the author of that post (niskypto) Naturally, you will start to handle authorization in your application logic, which we don't want to encourage for the fact that it is liable to be hacked. You have Zoho Accounts for authentication and Zoho Creator's Sharing module for authorization. Any enhancement
How do I get the date and time and input it into a field upon success?
When user clicks submit, I want the date and time to be inputed into my field, so that data will be shown in view.
Customizing Label widths in a permalink
When I use a permalink and customize the width of labels, the text wraps correctly in Internet Explorer, but not Firefox.
possible problem with file attachments
hi zoho, Problem is in form view mode. When I click on an attachment uploaded by the user, it does not download . Instead, the click takes me to this url : https://creatorexport.zoho.com/DownloadFile.do?filepath=/1256072884521_bemdts.doc&sharedBy=stressrecess&appLinkName=therapists&viewLinkName=Approval I cannot access these attachments, nor can I download them. Is there a setting I need to change or is this a problem on your end? The problem is the same in IE7 and Firefox 3.5. I was able
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
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
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"
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.
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!
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
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.
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
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?
Next Page