Quick application creation

1. General information

• This guide describes the fastest way to create a new application in NET Genium, generate sample data, and create view pages with various forms of visualization of the sample data.
• Creating a new application requires active administrator mode.

2. Creating an application with a table

• A minimal application contains at least one database table, or one edit form.
• From the NET Genium home page, it is possible to quickly create an application with a single table and define all columns of this new table.
• Optionally, sample data can be created and various forms of visualization of the sample data can be generated.
• After switching to Administrator mode, the home page displays the icon "Create application with table", which launches the wizard for creating a new application. The wizard creates one edit form and one view page with a datagrid displaying records from the new database table.

• Enter the table name – the name of the future application and simultaneously the name of the new edit form.
• Enter the columns of your new table – a list of names of new controls.
  • Individual column names are entered line by line, separated by the Enter key, each line represents one column of the table.
  • A data type may be specified after the column name, written after a colon and a space immediately following the name:
    • string
      • Wizard button for quick selection of this type: Text string
      • Target control: TextBox
      • Data type: Text string
      • Width: 150 px
      • Maximum length: 100 characters
    • integer
      • Wizard button for quick selection of this type: Whole number
      • Target control: TextBox
      • Data type: Integer
      • Width: 150 px
      • Maximum length: 100 characters
      • Alignment: Left
    • double
      • Wizard button for quick selection of this type: Decimal number
      • Target control: TextBox
      • Data type: Decimal number
      • Width: 150 px
      • Maximum length: 100 characters
      • Alignment: Left
    • date
      • Wizard button for quick selection of this type: Date
      • Target control: TextBox
      • Data type: Date
      • Width: 150 px
      • Maximum length: 50 characters
    • file
      • Wizard button for quick selection of this type: File
      • Target control: File
    • image
      • Wizard button for quick selection of this type: Image
      • Target control: Image
  • Specifying a data type is optional; if no data type is provided, the default type is string.

• A new application is created after pressing the “Go” button and answering the question “Do you want to create sample data and visualizations?”
• Answering “Yes” ensures:
  • Creation of one edit form
  • Creation of one view page with a datagrid displaying records from the new database table
  • Creation of five sample records in the new database table
  • Creation of a new category “Visualizations”, which contains the following view pages:
    • View table – datagrids with a standard query, an aggregate query, and a pivot table
    • Change tracking – datagrid showing history of changes in database records
    • Calendar – classic calendar similar to Outlook
    • Gantt diagram / Timetable
    • Booking calendar – multi-resource scheduling calendar
    • Chart
    • Map – map based on OpenStreetMap tiles
    • Tree structure
• Answering “No” ensures:
  • Creation of one edit form
  • Creation of one view page with a datagrid displaying records from the new database table
• Successful creation of the new application is confirmed by the message: “Congratulations, your new application is ready :-) The user mode will now be activated.”
• Pressing the “OK” button closes the wizard, and the newly created application can now be modified or extended as needed.

2.1. Structure of the new application including visualizations

2.2. Structure of the new application without visualizations