Hi,
In our case, we wanted to add records from two separate csv files to the database, one that we DO want displayed and one that we DON’T want displayed on the front end.
From reading your documentation it looks like the easiest way to do that is to add a hidden field and then add a filter in the Page shortcode that will determine if that record is displayed in search/sort functions on the front end of the site or not.
The one downside is that the two imported csv files will be intermingled in the single database.
I will check your suggestion, although we are only using List display, no sign-ups or record details.
BTW, we are using your database to display record albums. Thanks!