Help with set up tables

AppSheet AppSheet Q&A
,
1

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

2

BobG:

I know how to do this in a relational db

How would you do it there?

3

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

4
  • 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:

2 Likes
5

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

1 Like