A No-Code Challenge from Microsoft - Response #2

In a post the other day, I mentioned that I came across a statement in an article about Microsoft's Power Fx language that read:

"The truth is, point-and-click tools are great for quickly assembling experiences and workflows, but many real-world solutions need a layer of logic that goes beyond what is practical to drag and drop, for example:

Show a list of customers who signed up in the last 7 days within 15 miles of this location.

Highlight the newest entries in green.

When a user clicks for more details, if the record has outstanding action items associated with it, pop those to the top of the screen."

I wanted to find out how true that statement is, so I decided to try building an app on no-code platforms that met those criteria. Below is my second attempt, which I created on Caspio. 

================================================

I used the same database as before (customer Id, customer name, address, distance from us in miles, sign-up date, action items) and imported it from Google Sheets. Once the data had been imported I selected the "Data Pages" tab and created a tabular report to display the customer records:

Next, I made a copy of the report, opened it and selected to filter the report with pre-defined criteria:

Once I picked the "distance" and "sign-up date" as the fields I wanted to use in my filter, I set the first criteria as "distance" less than or equal to "15":

And I set the sign-up date to "within the previous 7 days":

Once I made those changes, I previewed the report again and this time the only record displayed was the one record that met the two criteria:

Note: You can also set a different colored background for certain records with Caspio but it requires using some JavaScript statements. The exact steps you need to use (including the JavaScript) are laid out in detail at:

https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/ 

However, since this is supposed to be a "no-code" project I decided to leave this example as is and not bother trying to include the record coloring feature.