Introduce expressed fields

[ijreilly]

We would like to offer the user the possibility to create field expressed as a function of other fields belonging to the same object (excluding relations). For example, object Company has fields numberOfEmployees (type number) and salariesExpense (type number), we could introduce a field averageSalary that would be: salariesExpense / numberOfEmployees. This field would be of type generated and built leveraging typeORM's asExpression as we did for the search.

In a first version

• this setting would be accessible at field creation level step 2 (after selecting a field type (the above described field would be of type Number)).
• the user would have to input their expression (we need to think of hints to help build the expression in the right format)

[ijreilly]

@FelixMalfait fyi

[Bonapara]

Not 100% convinced by this feature from a product point of view at this stage. I think we need to build and agree on our global Compute fields strategy first to avoid introducing 3 different field types for formulas/compute fields.

[FelixMalfait]

Called "formula" in Clay which I think is the most clear term

[ijreilly]

@Bonapara @FelixMalfait is this on hold for now? i thought so from @Bonapara s input

[FelixMalfait]

@ijreilly yes I just wanted you to log it but not prioritize it, thanks!