Dynamic Data Charts – Interactive Example

Help Topics

• Welcome to Caspio Online Help
• ▶Introduction to Caspio Bridge
  • What is the advantage of using a Web Database?
  • Why Use DataPages?
  • Caspio Bridge Environment
  • ▶Caspio Bridge System Requirements
    • Known Issues
• ▶Videos
  • ▶Getting Started Videos
    • ▶Create a Web Form
      • Create a Web Form (1 of 3) Create a Table
      • Create a Web Form (2 of 3) Create a DataPage
      • Create a Web Form (3 of 3) Deploy a DataPage
    • ▶Create a Searchable Database
      • Create a Searchable Database (1 of 3) Import a Table
      • Create a Searchable Database (2 of 3) Creating a Report
      • Create a Searchable Database (3 of 3) Cascading Dropdowns
    • ▶Creating Your Caspio App
      • Creating Your Caspio App (1 of 3) Planning Your App
      • Creating Your Caspio App (2 of 3) Creating Your DataPages
      • Creating Your Caspio App (3 of 3) Website Deployment
    • ▶Password Protection
      • Password Protection (1 of 3) Lookup and Authentication Tables
      • Password Protection (2 of 3) Authentication and Logout Links
      • Password Protection (3 of 3) Authenticated Data and Password Recovery
    • ▶Record Level Security
      • Record Level Security (1 of 3) Stamping New Records
      • Record Level Security (2 of 3) Create a Filtered Report
      • Record Level Security (3 of 3) Filtered Dropdowns
    • ▶Advanced Reporting
      • Advanced Reporting (1 of 3) View Construction
      • Advanced Reporting (2 of 3) Grouping and Aggregations
      • Advanced Reporting (3 of 3) Calculated Fields
  • ▶Full Implementation Videos
    • Social Networking Site
    • Event Calendar System
• ▶Tables
  • How do I Create a New Table?
  • About Data Types
  • Importing Data
  • Managing Data
  • Modifying Tables
  • Field Re-ordering in Table Design
  • Table Relationships
  • Lookup Tables
  • Exporting Data
  • ▶Scheduled Import/Export Tasks
    • Scheduled Import Tasks
    • Scheduled Export Tasks
    • Define an External Site
• ▼DataPages
  • ▼Creating DataPages
    • ▶Creating a Submission Form DataPage
      • Add a Dynamic Redirect After Form Submission
      • Add Separate Input Fields for Date/Time Parts
    • ▶Creating a Report DataPage
      • Update Records Using a Details Page
      • Search and Filter Comparison Types
      • How to make Search Results Downloadable for Users
      • Limiting Records per Page and Total Records Returned
      • How to Add Today to “After Now” or “Next X Days” Criteria
    • ▼Creating a Chart DataPage
      • Dynamic Data Charts – Interactive Example
    • ▶Creating a Combined Chart and Report DataPage
      • Combined Chart and Report – Example
      • Combined Chart and Report – Example Two
    • ▶Creating a Calendar DataPage
      • Calendar DataPage – Monthly Example
      • Calendar DataPage – Weekly Example
    • Creating an HTML Page DataPage
    • Creating an Update Form for User Profile Information
    • Creating a Password Recovery DataPage
    • Creating a Mobile Form DataPage
    • ▶Advanced Reporting
      • ▶Calculated Fields
        • Caspio Bridge Function Reference
      • Data Grouping
      • Totals & Aggregation
    • Faster Wizard Navigation
    • Previewing DataPages
    • Inline Options for DataPages
    • Relative Paths in Destination Page Redirection
  • ▶Form Elements
    • HTML Blocks
    • Header and Footer
    • How to Display a Field Data as Hyperlink
    • Repeat Input Fields to Prevent Misspellings
    • ▶Dropdowns and Listboxes
      • ▶Dynamically Add Options to Dropdowns and Listboxes
        • Add an Option to a Public Facing Dropdown
      • Adding an “Any” Option to a Dropdown
      • Multi-select List Boxes in Search Forms
      • Cascading Dropdowns and Listboxes
      • Default Choices in Dropdowns and Listboxes
    • Remaining Character Count in Text Areas
    • AutoValue
    • Radio Buttons: Selecting All Options
    • Stamp the Time and/or URL on a New Submission or Update
    • In Action: Creating an “I Agree” Checkbox
  • Editing DataPages
  • ▶Managing DataPages
    • Moving DataPages
    • Copying DataPages
    • Exporting a DataPage
• ▶Deployment
  • ▶Deploying DataPages
    • Embed DataPages in the Webpage Header
  • ▶SEO Deployment
    • SEO Deployment Guidelines
    • Sitemap Generator for Caspio SEO Deployments
  • Block Access to DataPages by IP Address
  • ▶Iframe Deployment
    • Remove the Iframe Border and Change the Size
    • Make Any Iframe Resizable
    • Create a List Report Showing Associated Records from a Second Table
    • Create an Embeddable Tabbed Interface
  • Deploy Caspio DataPages in WordPress
• ▶Automatic Emails
  • Acknowledgement Emails
  • ▶Notification Emails
    • Troubleshooting Notification Emails
  • File Attachments in Automatic Emails
• ▶Authentication and Security
  • ▶Web User Authentication
    • How to Create a Logout Link
    • How to Hide Multiple Login Screens
    • ▶Create a Standalone Login Screen
      • User Specific Redirects from Stand Alone Login Screens
    • Creating User Permissions in your App
  • ▶Record Level Security
    • Stamp a Record with User Profile Data
    • Restrict Access to Records by User or Department, etc.
    • Lookup Table Filtered by RLS
    • In Action: Creating a Workflow Using RLS and Filtered Drop Downs
  • Adding Encryption to DataPages
  • Blocking Spam with CAPTCHA
  • DataPage Folders
• ▶Styles and Formatting
  • About Styles
  • Creating a Style
  • ▶Layout Options
    • Change the Default Alignment of Field Labels
    • Change the Button Cell Alignment
  • ▶Border Options
    • Add Rounded Borders to Fields
  • ▶Font Options
    • Design Using Google Web Fonts
    • Creating Glossy Heading Text
  • ▶Advanced Style Options
    • Adding a Gradient Background to Fields
    • Add a Background Gradient
    • Replace Record Links with Images
    • Replace Standard Buttons with Images
    • Change the Color of Error Field Labels
  • Exporting and Importing Styles
  • Set the Width of a DataPage
  • ▶Web Form Columns and Configurations Options
    • Adding Multiple Column Formatting to DataPage Sections
    • Adding Multiple Elements on a Single Line
  • Styling for Advanced Reporting
• ▶Files and Images
  • Uploading Files and Images
  • Adding a Lightbox to View Images
  • Referencing an Image Stored in Caspio Bridge
  • Creating Thumbnails with the Image Resizer
• ▶Localizations
  • ▶Creating a Localization
    • Arabic, Hebrew and Other Right-to-Left Languages
  • Formatting and Rendering
  • Format Types
  • International Dates in Calendar Fields
  • Exporting and Importing Localizations
  • Customize Localizations to Improve Usability
• ▶Views
  • Create a View to Filter a Table
  • Creating a View to Join Tables
  • Modifying Views
  • Importing Views
  • Exporting Views
• ▶Parameters
  • Enable Parameters
  • Displaying Parameters
  • Passing Parameters through Caspio Bridge
  • Passing Parameters Using a Query String
  • Receiving Parameters
  • Resetting Parameters
  • Parameters in Dropdowns, Listboxes and Radio Buttons
  • Creating Dynamic Labels
  • ▶Parameters In Action
    • In Action: Add a Search Interface to a Results Page
    • In Action: Results and Details in Two Separate Web Pages
    • In Action: Display a Personalized Message to Your Users
    • In Action: Multi-Page Forms
    • In Action: One-To-Many Relational DataPages
    • In Action: Search Page and Results Page in Two Different Webpages
    • In Action: Link a Results Page to a Results Page
• ▶Account Management
  • Account Alerts
  • ▶Internal Users and Groups
    • Table Security
    • DataPage Privilege Control
    • Privileges of Internal Users
    • Managing Groups
    • Managing Privileges
  • Backing Up Your Applications
• ▶Common Customizations
  • ▶DataPage Interface Additions
    • How to Add a Reset Button in the Web Form to Clear Entries
    • Search Again Link on the Results Page
    • Add a Mouse Over Help Icon
    • Add a Loading Graphic
    • Create-an-Add-to-Outlook-link
    • Creating Date Specific New Record Links in Calendar DataPages
    • Add Auto-Clearing Default Text to Form Input Fields
  • Create an Approval Process for New Records
  • Hide Fields in DataPages
  • Generate Link Menus and Pop-up Windows
  • Dynamically Change the Background of a Results Page Record
  • Create a Floating Feedback Tab
  • Limit the Number of Maximum Submissions
  • Vote Up – Vote Down Individual Records
  • Create an Auto-Scrolling Record Viewer
  • Add a Time Limit to Submission Forms
• ▶Extensions
  • ▶Social Media
    • Add a Tweet This Link
    • Add a Facebook Like Button
    • ▶Create Facebook Apps and Page Tabs with Caspio DataPages
      • Allow Facebook Registration
      • Display a User's Facebook Profile Photo
    • Create an Add This Button
  • ▶iPhone, iPad and Smartphone Solutions
    • In Action: Using the iPhone Kit
    • How to Add QR Codes to Your App
  • ▶Caspio Bridge Plug-In for MS Office
    • Microsoft Office Plug-In (Office 2010)
    • Microsoft Office Plug-In (Office 2003-2007)
  • ▶Maps
    • Map Mashup Instructions
    • How to Use Geocodes Instead of Address in Map Mashup
    • How to Change Text Color or Style in the Map Bubble
    • How to Set Up a Distance Search
    • Hide the Map When No Results Are Found
  • Adding a PrintWhatYouLike Link
  • Convert Existing HTML Forms to Submit Data to Caspio Bridge
• ▶Release Notes
  • Caspio Bridge 7.2
  • Caspio Bridge 7.1.5
  • ▶Caspio Bridge 7.1
    • 7.1.1 Patch
  • ▶Caspio Bridge 7.0
    • 7.0.1 Patch
    • 7.0.2 Patch
  • Caspio Bridge 6.9.5
  • Caspio Bridge 6.9
  • What’s New in Caspio Bridge 6.9
  • ▶Caspio Bridge 6.8
    • 6.8 Interface Changes
  • Caspio Bridge 6.7
  • Caspio Bridge 6.6
  • Caspio Bridge 6.5
  • Caspio Bridge 6.0
• ▶Tech Tips
  • Tech Tip: Embed Documents in DataPages
  • Tech Tip: Integrate Google Analytics into Submission Form DataPages
  • Tech Tip: Dynamically Add Options to Dropdowns and Listboxes
  • Tech Tip: Leverage the Power of Social Media in Your Apps
  • Tech Tip: Optimize Your Web Forms for Maximum Usability
  • Tech Tip: Custom Filter Elements
  • Tech Tip: Creating a Floating Navigation Menu
  • Tech Tip: How to Validate a User Email Address
  • Tech Tip: Creating Collapsible Sections
  • Tech Tip: Create Tabbed Navigation for Multiple DataPages
  • Tech Tip: Adding a Zoom Window to Images
  • Tech Tip: 5 Ways to Customize the Look of Your DataPages
  • Tech Tip: 5 Techniques to Create Web 2.0 Style Design
• ▶Instant Apps
  • Classified Ads
  • Business Directory
  • Vacation Requests
  • Resource Scheduling
• ▶FAQ
  • ▶DataHub
    • What IP address range Caspio is using for DataHub?
  • ▶Authentication
    • Why user cannot login to app or DataPage?
    • Why DataPage Logout redirects to Caspio.com?
    • How to separate login form from an authenticated DataPage?
  • ▶Time and Date
    • How to eliminate Time from a Date dropdown?
    • Why Date Fields from Excel Import Incorrectly?
  • ▶Map-Mashup
    • How to hide the map if no records found on the result page?
    • How to change text color or style of the map bubble?
    • How to display a dynamic image inside a map bubble?
    • How to use geocodes instead of address in map mash-up?
    • How to set a default map for when there are no records?
  • ▶Deployment
    • Troubleshooting Search Engine Optimized (SEO) Deployment
    • How to embed Caspio on Ning?
    • How to Resize an iframe
  • ▶Web Forms
    • How to remove blanks from a dropdown or listbox?
    • How to add a reset button to my form to clear entries?
    • Why do I get Error: "Duplicate values are not allowed …"?
    • How to Limit Votes to One per User?
  • ▶Reports DataPages
    • Why do I get "error in formula" message in a Report DataPage?
    • How to determine the number of years between two dates?
    • How to calculate date difference such as days between when a record was submitted and now?
    • How to do Keyword Search across multiple fields?
    • How to do conditional or IF, THEN, ELSE in calculated fields?
    • Why the sorting of my numbers is wrong?
    • How to display a field data as hyperlink?
    • How to make the search results downloadable for my users?
    • How to add "Today" to "After Now" or "Next X Days" criteria?
    • How to put a “Search Again” link on my DataPage?
    • Why strange characters on my DataPage?
    • How do I edit data through my Details page?
    • How to count the number of times a record has been viewed?
  • ▶JavaScript Issues
    • Why JavaScript is not working with multiple DataPages deployed on one page?
  • ▶Auto Emails
    • Why acknowledgement emails are not received?
    • How Many Addresses are Allowed in Notification Emails?
  • ▶API and Microsoft Office Plugin
    • How can I get Web Services API and Plug-in for Microsoft Office?
  • ▶Styles and Localization
    • How to use an image as form background?
  • ▶Errors and Messages
    • Why do I get "Object moved to here." or "This webpage is not available"?
    • Why do I get Error 50501?
    • Why do I get Error 50510?
    • Why do I get Error 60025?
  • ▶Security, SSL and Encryption
    • Can I use Caspio SSL without a website SSL?
    • Why I see no SSL lock icon for my web page?
  • ▶Parameters
    • Why wrong results when parameters are passed to search form?
    • How to pass multiple values in one parameter?
    • How to clear parameter when value is blank?
• Sitemap