Good afternoon
I’ve made an app that allows me to gather performance indicators on employees across a range of sites. Here are some example tables:
Contacts
| SiteID |
Site |
Suburb |
Region |
Employee |
Employee Mobile |
Employee Avail. |
Employee Email |
Manager |
Server Naming Scheme |
School Address |
Latitude |
Longitude |
LatLong |
| 123 |
Site Jelly |
Suburb A |
Alpha |
Julie |
|
M, T, W, Th, F |
|
|
123 - Site Jelly, Suburb A |
10 Fake Address, Suburb A |
|
|
|
| 456 |
Site Oreo |
Suburb B |
Alpha |
Wendy,
Luke |
|
M, T, W
W, Th, F |
|
|
124 - Site Jelly, Suburb A |
11 Fake Address, Suburb B |
|
|
|
| 789 |
Site Jelly |
Suburb C |
Delta |
Charlie |
|
Th, F |
|
|
125 - Site Jelly, Suburb A |
12 Fake Address, Suburb C |
|
|
|
Employee Records
| Date |
Site |
Employee |
Work Overview |
Workload |
Projects |
Comments |
Manager Comments |
| 01/01/20 |
123 |
Julie |
Completed monthly sales reports |
High |
None at this time. |
|
|
| 01/01/20 |
789 |
Charlie |
Completed onboarding |
Average |
Sales initiative |
|
|
These tables are referencing each other via the Site cell (i.e. SiteID is being used as the Key and Site as the Label). The Trainee cell is derefferenced based off of what Site is selected in the form.
This method will not work for rows of data such as these where more than one employee exists in the employee cell such as below:
| SiteID |
Site |
Suburb |
Region |
Employee |
Employee Mobile |
Employee Avail. |
Employee Email |
Manager |
Server Naming Scheme |
School Address |
Latitude |
Longitude |
LatLong |
| 456 |
Site Oreo |
Suburb B |
Alpha |
Wendy,
Luke |
|
M, T, W
W, Th, F |
|
|
124 - Site Jelly, Suburb A |
11 Fake Address, Suburb B |
|
|
|
There are numerous entries such as these within the full Contacts spreadsheet and this is unable to be changed (i.e. this spreadsheet links to other documents within my organisation).
In short:
Can I have AppSheet read and separate these data values (e.g. “Wendy, Luke”) and display them as a dropdown menu IF I select a site that has more than one employee in the Employee Column?
I’m venturing into new territory here, and I’m sure to run into more bumps and snags whilst figuring this out.
Any advise is appreciated and please feel free to ask me for more info.
Kind regards
LinkedIn
Twitter
