Jump to content
  • 0

Caspio Capabilities - Client Serving Database, Dynamic Tables And Charts


Percyqqing
 Share

Question

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

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...