Often when you work with data and fields a lot of fields needs to be calculated, just like you do in Microsoft Excel or a Google Sheet. Wouldn't it be awesome if you could accomplish that in Wix Code?
Lets say I create a new field in my Data Collection and I choose Calculated Field as the field type. Then I can write formulas inside a value editor as I can in Airtable. =SUM(FieldKey+FieldKey2) and then the resulting value will be the sum of those two fields.
This way non-programmers would be able to do a lot more with ordinary Data Colllections and with no scripts inside.
If I then have a reference between two Data Collections I would be able to get data from the other data collection and sum with fields in the first one. This would power up the use of Data Collections.
Just a thought.