Caspio Capabilities - Client Serving Database, Dynamic Tables And Charts

[Percyqqing]

Hi All

Apologies if some of the below has been covered already, but I'm seriously looking at using Caspio as the online database for my firm and I need to know if it has the following capabilities. By way of background my firm currently has mulitple microsoft excel models to provide financial and production data for wheat farms. Each farm has spreadsheet with specific data for its different production types and different costs. I have structured our excel forms so that they have the same fields.

 

My online database will need the following features:

 

1. Can a caspio database using as a client (human users) serving database, whereby my clients can log in review and manipulate data and download data in an Microsoft Excel file?

2. A dynamic table where a client can view/manipulate multiple fields/metrics. Eg look at fertilisation costs for Argentina and Brazil farms, or US production by farm.

3. A dynamic variable width stack chart (also known as an industry cost curve) which displays cost info (y-axis) and production info (x-axis) - client would need to manipulate this curve and then download as pdf. We currently use a excel macro to generate these curves

4. A map page - basically a google may which pinpoints each farm. When a uses clicks a point on the map it will bring up basic info

5. Basic farm list page - whereby a client can click on a farm name and download a basic financial model for that farm (excel file)

6. Finally a basic page for each farm site (bearing in mind there are 5000+ farms) which displays the individual data for that site and for each number, where applicable, a click through to a pdf document where it was sourced.

 

Sorry for the long winded post. But would love any responses, I really would like to use Caspio. Also if any developers have experience building these kinds of database please contact me.

 

Cheers

[MayMusic]

You can request for a 2 week trial account and try it out. You should be able to implement all these http://www.caspio.com/signup/trial.aspx

 

1. Can a caspio database using as a client (human users) serving database, whereby my clients can log in review and manipulate data and download data in an Microsoft Excel file?

>>You can create an authenticated reprot and let the user to searcg for records and edit them either in reoport page or details page

http://howto.caspio.com/videos/getting-started/searchable-database/create-a-searchable-database-2-of-3-creating-a-report.html

http://howto.caspio.com/videos/getting-started/password-protection/

 

2. A dynamic table where a client can view/manipulate multiple fields/metrics. Eg look at fertilisation costs for Argentina and Brazil farms, or US production by farm.

>> I am not sure what you mean by dynamic table but you should be able to create a view out of a table to filter a table and then use it as a source of a report

 

3. A dynamic variable width stack chart (also known as an industry cost curve) which displays cost info (y-axis) and production info (x-axis) - client would need to manipulate this curve and then download as pdf. We currently use a excel macro to generate these curves

>> You can either create a chart DataPage or a combined chart and report http://howto.caspio.com/datapages/creating-datapages/creating-a-combined-chart-and-report-datapage/combined-chart-and-report-example.html and http://howto.caspio.com/datapages/creating-datapages/creating-a-chart-datapage/

 

4. A map page - basically a google may which pinpoints each farm. When a uses clicks a point on the map it will bring up basic info

>> Tutorial that shows how to create a google map to show the data from your table on it: http://howto.caspio.com/extensions/maps/map-mashup-instructions/map-mashup-version-7/

 

5. Basic farm list page - whereby a client can click on a farm name and download a basic financial model for that farm (excel file)

http://howto.caspio.com/datapages/creating-datapages/creating-a-search-and-report-datapage/how-to-search-results-downloadable-for-users.html

 

6. Finally a basic page for each farm site (bearing in mind there are 5000+ farms) which displays the individual data for that site and for each number, where applicable, a click through to a pdf document where it was sourced.

>>You can create a report on the table you have all farms information in and for  each record you can have a PDF to show as explained here http://howto.caspio.com/tech-tips/tech-tip-embed-documents-in-datapages.html

 

Caspio has a developer team that can build your whole orpart of the app for you which will save you time and money. To get a price quote fill out this form at http://www.caspio.com/support/professional-services.aspx

[Percyqqing]

Thanks for the reply

[MayMusic]

  Good luck on your app!