Hello Appsheet Community
- Customers Table
- Sales Table
- Payments from Customers Table
I need to make a virtual column in Customers Table contain a Ref_Rows from two table (Sales & Payment) sorted by date.
Knowing: Sales and Payment table have a REF Column refer to [Customer ID] in Customers Table.
I’ve solved this problem by creating an additional Table using Query Function in google sheet, But that make the app more slower.
Is it possible to do it inside Appsheet?
Don’t you think that it is an important feature?
Any Ideas or suggestions are welcomed.