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

AppSheet AppSheet Q&A
1

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?

2

@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-aa73-ace5df8ba1b5 Virtual Columns help.appsheet.com

3

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