Drop down selection question
i have 2 tables
Table 1 - Door list that contain all relevant information
Table 2 - Job entry that record the installation work of a door
How can i make sure 1 door only have 1 installation job?
When i create entry in Table 2, i have a dropdown list from table 1. How can i have dropdown that has the door with
job filtered out?
or i just record everything in table 1, then create a slice to have 2 information? However, this method will seems a bit hard if i wish to manage the Google Sheets itself.
Or any other way to do so?