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

references
(Siang Teck Beh) #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?

(Tony Fader) #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

(Siang Teck Beh) #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