davep

Caspio is known for its scalability In the past we have powered disaster apps related to Hurricane Katrina for AJC (case study: http://www.caspio.com/pdfs/Caspio-Success-Story-AJC.pdf) and similar apps for Houston Chronicle for Hurricane Ike. Apps related to floods in Iowa and fires in San Diego were also powered by Caspio apps. If you expect a sudden increase in traffic just let Caspio support or your account manager to know so our engineers can apply some additional optimization on your apps. Dave

Try this: <script type=\"text/javascript\" language=\"JavaScript\"> document.order.submit(); </script>

You can specify fields as EMAIL and ensure no invalid character is entered. Aside from that if you want to prevent certain characters from your text fields and text area fields you would need a JavaScript code to do that.

Ask tech support to activate Orphan File Cleanup. More details are here: http://www.caspio.com/extend/platform-extensions/orphan-file-cleanup.aspx.

If you have a one time task of uploading a lot of images into your table, it can be done as a quick service by Caspio. Regarding your second question, you can upload anything you want but you get back the exact same thing. No reverse conversion occurs on the backend.

One way to do this is through writing a script and accessing your records and emails addresses through Caspio's Web Services API and generating your own emails.

To be effective in Caspio you need to be \"tech-savvy\" and be comfortable with standard office applications. Tables are buckets of data. They define the type of data that can be stored in the buckets. Views are just pictures of the data. They show you a part of the data that is comming from a bucket or data that is combined from different buckets. You cannot have a view unless you have tables.

Currently this can be done as a small custom work. In a release later this year it will be a built-in feature.

Authentication requires cookies. Make sure it is not disabled on yoru browser.

This can be done rather easily. Let's say your original query string parameter is called \"school\". In your first DataPage create an HTML block and in there put something like this: http://www.mydomain.com/SecondDataPage.html?school=[@school] So what you're doing is taking the paramter available to DataPage 1 and passing it as a paramter to DataPage 2. Of course you could wrap the link in a proper HTML tag. Caspio tables can reach over 1 million records without problem. For large table request that Caspio apply optimizations to the table for best performance. Regards,

This feature is currently under development and should be available in December 2007. In the meanwhile the JavaScript workaround can do the job in most cases.

Carol, currently logout is set to 2 hours systemwide. In the upcoming release you will be able to change this setting. Dave

I'm pretty sure it can be done in JavaScript. Any JS experts out there?

There are many attributes for the iframe tag that you can customize for your exact requirements. Some details can be found here: http://www.w3schools.com/tags/tag_iframe.asp

Yes, there are ways to do this. I assume you already have the averages figured out and that you round the average ratings to whole numbers. Create a table with two fields: \"rating\" and \"icon\". This will be your RatingMap table. The \"rating\" field will have all possible whole number ratings and the icon field should contain a properly formed html img tag of the corresponding icon for that rating. Something like this: RatingMap table rating icon =============================== 1 <img src=\"http://mysite.com/1.gif\"> 2 <img src=\"http://mysite.com/2.gif\"> etc. For displaying your reviews create a view between this table and your review table based on the rating field. Instead of displaying the rating number now you can display the icon field and have it render as HTML.

I'm having difficulty understanding the situation. I realize that multi-table views are not editable and therefore the standard ack email option cannot be used. But based on what action are you interested to send the email? Is there going to be an update of some kind? In that case you could use a hidden form with your intended email address. Are emails triggered by people? Consider using the new rich options in Render As Email where any email field displayed as email can include a complete customized email template associated with it. Please exapnd.

The final version of this is now loaded in every new account.

DataPages built on multi-table Views are not editable. That's why a lot of your editing otpions are grayed out. You have two choices: 1. Build your editable screens on tables, or 2. Instead of the standard details page from a view-datapage, use a link along with the id of the record as a parameter and pass it to another page where you can edit the record served by a datapage based on a table. Having the ability to skip some wizard screens is something we are considering for a future release.

This is a nice feature to add. We'll put it on the short list.

You want to make sure that both in Caspio and in Excel the field is formatted as text. I have a feeling Excel is treating it as number.

Also, if you have any new fields in your imported file, they will be added to the table structure.

Sure, all you need to do is create a Search and Report DataPage and on the second screen choose Default Criteria instead of Search Form.

Unfortunately I'm not a JS expert to answer your question, but there is a collection of JS solutions at http://www.caspio.com/support/jssolution.asp. Perhaps you can find some pointers there. By the way, JS solutions page is linked from the Resources page. Dave Caspio