Quick application creation

1. General information

• This guide describes the fastest ways to create a new application in NET Genium — either manually or using AI.
• When creating applications manually, the process may also include generating sample data and creating view pages with various visualization forms.
• When using AI, it is possible to create an application containing multiple tables including the corresponding edit forms, and a logically connected structure derived from the description entered by the user.
• The application creation function is available only in Administrator mode, because it modifies the database structure, creates new tables, and generates the corresponding edit forms and view pages.

2. Creating an application

• In NET Genium, a new application can be created in Administrator mode directly from the home page using the “Create new application” wizard.
• A minimal application contains at least one database table and the corresponding edit form.
• The wizard offers two options for creating an application, each differing in how the structure is defined:
  • Single table
    • Manual definition of the table name and individual columns, including optional specification of data types.
    • It is optionally possible to generate sample data and automatically create view pages with different types of visualizations.
  • Application using AI
    • Creation of an application automatically based on the name and an optional description.
    • AI can propose the structure of one or more tables, including the corresponding edit forms.

2.1. Single table

• After switching to Administrator mode, the “Create new application” icon becomes available on the home page.
• Selecting “Single table” launches the wizard for creating a new application containing one database table. The wizard automatically generates:
  • an edit form corresponding to the new database table,
  • a view page with a datagrid showing the table records.

The wizard contains two input fields that define the structure of the future application:

• 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.1. Structure of the new application including visualizations

2.1.2. Structure of the new application without visualizations

2.2. Application using AI

• After switching to Administrator mode, the “Create new application” icon becomes available on the home page.
• Selecting “Application using AI” launches the wizard designed to automatically create a new application with the assistance of AI.

• This method is suitable especially when the user wants to quickly prepare a more complex application whose structure does not have to be precisely defined in advance. AI is able to propose multiple tables, corresponding edit forms, and relationships between them based on the description.

The wizard contains two input fields that determine the structure of the future application:

• Enter application name – the name of the future application, serving as the main identifier and helping AI understand the focus of the new application. Based on the name, AI can infer the basic structure of the application.
• Enter the description of your new application – an optional text field that allows specifying the purpose of the application more precisely.
  • The more detailed the description is, the more accurately AI will propose:
    • the final set of tables,
    • names of individual tables,
    • names of columns and their data types,
    • logical relationships between tables using foreign keys,
    • the structure and visual layout of edit forms.
  • The description may include key elements such as required data, workflow, specific categories of information, or examples of items.
    • AI always proposes data types automatically, regardless of whether they are mentioned in the description.
  • Data types are determined based on:
    • the meaning of the fields that AI generates,
    • the application name entered,
    • the words and context contained in the description (if provided).
  • The proposed data types correspond to the default types described in the chapter “Single table”, section “Enter columns of your new table”.
• When you click inside the “Enter the description of your new application” field, a link labeled “Assistant for generating the application description…” appears.
  • Clicking this link opens a new Microsoft Copilot Studio window, where you can communicate with AI in a natural conversational way, gradually refine the purpose of the application, add required fields and information, optionally specify workflow, or let the assistant propose suitable wording for the description.
  • The resulting description can be copied from the Microsoft Copilot Studio window, pasted back into the “Enter the description of your new application” field, and you can then continue creating the application using AI.
• The new application is created by pressing the “Start” button.
• Successful creation of the new application is confirmed by the message: “Congratulations, your new application is ready :-) User mode will now be activated.”
• After clicking “OK”, the wizard closes and the newly created application can be freely modified or further extended.

2.2.1. Structure of the new application

• Structure of the new application in the case where “Received invoices” was entered in the “Enter application name” field.