A more robust solution for calculated fields

Pseudo fields

Coming soon

This page is a stub and will be expanded soon. It will cover how to define and use pseudo fields (a.k.a. pseudocolumns) consistently across models, forms, and tables.

Problem

You need to perform some calculations during data entry, but you do not want these columns to be editable by the user.

For example, you want to record the Temperature, and your measurement is in degrees Celsius (°C), but in that same datatable you also need to store the temperature in Kelvin (K).

Solution

Use Pseudo Fields. A pseudo field is a read-only field that is calculated based on other fields in the form. In our example, we could create a pseudo field for the temperature in Kelvin, which would be calculated from the Celsius input.