Hello everyone,
I’d like to know if it’s possible to make a form so that when the user enters all their fields, a calculation is made with the fields they’ve filled in to put them in a new column?
Example:
I have a table with 5 columns:
- Dependency
- Penetration
- Maturity
- Confidence
- Threat
The user can only enter the first 4 columns, but the last column will be the result of a calculation:
Threat = (Dependency * Penetration) / (Maturity * Confidence)
Is it possible to add this calculation to the form invisibly for the threat column?
I know it’s possible to do this in postgresql but I can’t see how to do it via the Ignimission platform…