U Man Genius docs

Popup ninext

Fields and Functions

Jacques TUR

The Fields and Formulas/Functions (Fields & Fx) menu allows you to find dependencies for a selected field or global function. This means you can identify all the formulas that use a specific field or global function.

Why This is Useful

When modifying or deleting a field or global function, this feature helps you verify its impact on the rest of the database.

⁠

Dependency Impact Levels

There are three levels of impact, represented by three different badges:

Badge

Formula

User interface

Display

⁠

The field is used in a formula (or a trigger such as onClick, afterUpdate, or afterCreate). Any modification or deletion will affect the database's functionality.

⁠

The field is used in a trigger (e.g., visibility, canWrite, canRead, beforeShow, afterHide). Modifying it will only affect the user interface behavior and not the database functionality or data calculations.

⁠

The field is only used for display purposes. Modifying it will only affect data presentation, without altering the user interface behavior or data calculations.

There are no rows in this table

⁠

The number displayed inside the badge represents the total number of dependencies.

Understanding Dependencies

A field can have multiple dependencies, and each dependency may also have its own dependencies. This hierarchical structure helps in understanding how changes to a field or function affect the database.

⁠

Direct use

Select a Table or Global Functions Line:

Use the dropdown menu on the left to select a table or the "Global Functions" line.

⁠

Select a Field or function:

Use the dropdown menu on the right to select a field or function - from the previously selected table or the global functions.

⁠

Using the Field Editor

You can also directly click on the badge above the field in the field list. This automatically opens the Ninext Popup, selecting the corresponding table and field.

⁠