Welcome to the Simpler Developer page. Here we will provide the tools necessary to help you develop datapps for your organization. In order to develop, your organization must be licensed to use the Simpler platform and have a development site installed. 

On this site, you will find videos, tutorials,  documentation, and resources that will help you as you learn about datapps and how to create them..

Please contact us with troubleshooting inquiries and further questions.

Search for a topic:

What is Simpler Systems?

The Simpler Systems application synchronizes data from the source database(s) according to a schedule and stores it in the Simpler database. Using the Simpler platform, the data is then displayed in a browser on any computer or tablet with the appropriate user authentication where anyone can navigate the data. No programming, SQL, or reporting tools knowledge required!

Each link on the menu invokes a Search page that allows the user to enter criteria that will either filter, sort, group, or aggregate the datapp, or pool of data used for that link. Some of the links will display the entire data set for that area of the application, others present data that is already composed in a way that displays the data specific to a topic. Watch this short video to see what we mean.


Create a Basic Datapp

Creating a basic datapp is easy. Watch this short video and then follow the steps in your environment.


Setting up the Environment

This document includes information about hardware and software requirements, folder structure, setting up the web server and authentication options.


Syncing the Data

Syncing the data....

 

Development Resources

The following links will take you to...

 
 
 

Template Documentation

The template documentation includes a list of the templates, tags, and functions.

 

Script Functions

The Simpler platform script functions are similar to how Excel uses functions

Script Examples

The script examples page defines and shows examples for:

  • Lists
  • Types
  • Type Conversion and List Reduction
  • Identifiers
  • Expressions
  • Conditionals
  • Functions
  • URL Evaluation

Once a data pool or view is created and put on the Simpler platform, it can be composed in hundreds of ways based on filters, grouping, and aggregation. Here are some examples of what that can look like for our demo dataset of Compensation for California Entities (Counties, Cities, Districts, etc...)For each example:

  1. Take a look at the criteria bar on the page to see how the examples were created.
  2. Click to the Search page to see what it looks like in the form.
  3. Look at the URL to see how it controls what you see on the Data page.

Filters

  • Null Values  - Ventura County First 5, unpaid positions
  • Not Blank - Ventura County First 5, paid positions
  • Range - City of San Buenaventura - Positions with Regular Pay 45,000 to 50,000
  • Less than or Equal to - City of San Buenaventura - Positions with Regular Pay less than 5,000
  • Exclusion - Ventura County Schools, excluding Charters

Grouping

 

Developer Videos

The following videos cover a variety of topics. Click on the icon in the bottom right to play in full screen mode for best viewing.

 
 

Indexing Optimization

A real life example of indexing and updating for performance enhancement. It includes info on working with syncs, indices, keys, and summary tables.

 
 

Feature 2

The following is placeholder text known as “lorem ipsum,” which is scrambled Latin used by designers to mimic real copy. Donec eu est non lacus lacinia semper. Sed a ligula quis sapien lacinia egestas. Fusce at massa nec sapien auctor gravida in in tellus. Sed a ligula quis sapien lacinia egestas.

Feature 3

The following is placeholder text known as “lorem ipsum,” which is scrambled Latin used by designers to mimic real copy. Donec ac fringilla turpis. Donec ac fringilla turpis. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.