Is it possible to create formula fields in a Xano table, similar to how Airtable does it?

Hello,

I'm trying to create a table in Xano that will calculate the price of an item / set of items. For example, say I have an inventory table and want to have the following fields:
1. Item name = Product A
2. Cost per item = $2.00
3. Number of items = 4
4. Total cost of items = $2.00 x 4 = $8.00


This table will have #4 for each row entry so I don't think using the regular function stack approach will be the best since I want to store this data in the database table.

I would like to create column #4 as a formula field in the database table so I don't have to do those calculations on the frontend. How can I create #4 in the database table? 

Thank you
Other
6 replies