Graphical data selection for (logical) humans

Show and Tell
#1

Hello all,

This is a graphical data selection tool for tabular data. The criteria used for selection can be arbitrarily complex. You can save queries and use baked-in examples.

Updated version:

explorer
explorer.gif800×450 2.55 MB

The purpose of this app was to encourage staff who are not programmers to extract the records they need without having to make a request from our department. Many of our staff rely on lists of records that satisfy some criteria of interest. Since there is no way to know what the criteria are, this app helps by providing a general solution.

It is just a proof of concept right now but you get the idea.

Shareable demo of Data Explorer:
https://anvil.works/build#clone:ZATAYK4UFBSV4N5F=EUDTLKRUSGDMAQ777ZNS7KUI

9 Likes
Intuitive Search
#2

This is a really great example @alcampopiano . Reminds me of the good ole Paradox - ObjectPal days, when you could just put a form together to create a query for your users or managers, and stop the endless request from them to run a new query and analyse the data.
0%20for%20Windows%20-%20Form
Just thinking how easy it was to code in the mid 90’s. Anvil is really bringing back that feel. Not quite as easy as Paradox - Object Pal, but I could swear that Python was somehow influenced by Object Pal.

3 Likes
#3

Thank you. I have updated the GIF and added an up-to-date shareable clone.