Help with set up tables

BobG
Participant III

I would like to know how to best wet up tables to handle the following situations.
I have employees some of whom work at multiple locations.
Locations have more than one employee assigned to them.
Work tickets are issued to specific locations.

I want the employees to see the work tickets that are either new or incomplete when they check into a specific location and not the work tickets for every location they work at. I know how to do this in a relational db but how do I do this in Appsheet?

Thanks

0 4 214
4 REPLIES 4

Steve
Participant V

How would you do it there?

Using 2 many to one relationships to a separate table. Is that the same thing I need to do with appsheet?

  • Employees: (EmpId, โ€ฆ)
  • Locations: (LocId, โ€ฆ)
  • LocEmps: (LocId, EmpId)
  • Tickets: (TktId, LocId, โ€ฆ)

Employees at a given location (row in Locations๐Ÿ˜ž

SELECT(LocEmps[EmpId], ([_THISROW].[LocId] = [LocId]))

Tickets available to a given row in LocEmps:

SELECT(Tickets[TktId], ([_THISROW].[LocId] = [LocId]))

See also:




Thanks Steve.
Iโ€™m still n the upslope of the learning curve so the links will be helpful Iโ€™m sure.

Top Labels in this Space