What is a Formula Field?

Fields in Morph Tables can have the type ‘Formula’.

A Formula Field holds the results of a calculation using the value of other fields in the same record. If you’re familiar with formulae in spreadsheets, this works in exactly the same way.

Creating a Formula Field

You can create a Formula field by selecting Formula in the Type of the Create Field popup.

Simply write what you want the Formula to show in the text box and let Morph’s AI handle it. Other Fields can be referred to by using “@” and selecting the one you want from the drop-down options.

You will need to click 'Test Run' to check that the Formula returns the correct results. Once it validates, press the Create Field button as normal. Done!