SQLite Web Database Repeater

Databases are a critical part of most Web and WebApps. They have the ability to store and retrieve information. Thorium Builder's Database Widgets are designed to work easily with Web Project Databases and WebApps Project Databases. Note that if your project is not selected as a Web Project With Database or WebApp With Database , as shown above, you will see no widgets listed in the Database Widget Area.

The Database Repeater is a Widget that will display a list of records from a database. The Records are filtered and sorted according to the settings that you apply.

...

When first dropped into the Page Editor, the Database Repeater Widget appears as above. Double-click on the widget, to access its advanced properties.

Advanced Properties Window (General Tab)

...
  • Data Source Filter

    The category of records you want to display.It can be all records.

  • Data Hierarchy

    The Data Hierarchy selector defines the level of the records that you want to display. There are three settings:

    • 1. All Hierarchy (default) : all the records for the selected category are displayed.

    • 2. Root Records Only: Only the records at the first level of the database category will be displayed.

    • 3. Show Only Current record Child:

      a. First, you must display a detail page for a record.
      b. Add the Database Displayer Record to the page.
      c. Add any Text or images into the Database Displayer Record.
      d. Select this option.e. Only the child records of the current records will be displayed.

      ...
  • Sorted By

    The default sorting (Older, More Recents First, Alphabetical or Event Date).

  • Detail Page

    When the user selects an item from the Database Repeater list, the user is then taken to the page that holds the Database Displayer Widget information. The name of that page can be chosen from the selector dropdown.

  • Items per Line

    The number of Columns for the repeater (From 1 to 6).When you want to display Records such as Images, Cards, etc… , choosing a number of columns greater than one will automatically create a smart grid view.

  • Alignment

    Select here how you want to justify the Tabs.

Advanced Property Settings (Advanced Tab)

  • Repeater Min Height

    Set the minimum height of the Repeater in Pixels.

  • Use Masonry Style

    Enable the Masonry Style (See Cards-Columns for more details).

  • Row Limit

    Enable a limit for the number of records that will be loaded on first load.It is highly recommended to limit the number of rows loaded when the database contains a large number of records.

  • Records per Load

    The Maximum number of records loaded on first load and when the Infinite Scroll option is set.

  • Infinite Scroll

    Enable a fonctionnality that will load a new packet of records every time the user scroll to the end of the page.

  • More Button Text

    The Text of the button that lets the user load more packets of records.

...

Example of Web Repeater Implementation

Copyright©  Nymphide Lab 2020 - All Rights Reserved 

...