Hello, I have 2 tables 1. Construction Si...

[Siang_Teck_Beh]

Hello,

I have 2 tables

1. Construction Sites (Contains column “STATE”) 2. Equipments

A constructions sites have many equipments. How can group the equipment by STATE, which the data only store in first table?

[tony1]

@Siang_Teck_Beh Create a virtual column in your Equipments table with this formula:

[Ref column to Sites Table].[STATE]

Then you can group by that virtual column.

More info:

help.appsheet.com - Virtual Columns https://help.appsheet.com/expressions/expression-types/dereference-expressions https://www.appsheet.com/samples/A-basic-demo-of-table-references?appGuidString=6ffad040-b04a-4325-a... Virtual Columns help.appsheet.com

[Siang_Teck_Beh]

Thanks a lot. I’m trying to use that formula in the previous virtual column, it does not work well. however, once created new column, it WORKS like charm!!!

THANKS