Save field that was calculated from SQL column

Good Morning.

Create a new table and the window already saves it in the database but when entering an SQL as seen in the image the field is no longer editable and is not saved in the database, this calculates but is not saved in the database any idea how to save the field, thanks for your time.

hi,

virtual columns are readonly only.
If you want to save data create a column without using column SQL.

cheers,
norbert

It is a physical column, but when putting the sql statement it takes the column as virtual and does not save the information, it is a percentage calculation that I wanted to make, I solved it using the methods in the CallOuts tab.

Tanks for your time.

Thx for sharing your solution David!

1 Like