I am trying to create an invoice worksheet app of sorts.
Within this I am trying to create a drop-down list of employees (which references a sheet) where I can select multiple employees who are working on the job for that day. From that list that I create I would like to be able to input values (rates) to each employee based upon the job they did for that day Then input the hours they worked.
Any help on where I should start looking would be appreciated
Hi and Welcome to the community!
In short, what you will want to do is create a separate table that provides the list of work done on a jobโฆmaybe named โWork Listโ. This table becomes a โchildโ table of the Jobs table - meaning that there is a strong parent/child relationship between the two. This โWork Listโ table would have, at a minimum, the columns:
AppSheet performs a lot of โconnection magicโ to set this all up within the views for you.
AppSheetโs design for a parent/child table setup in this manner, would be to add each of the Work List rows one-by-one. So when you add or edit a Job row, you will have the child โWork Listโ table visible by default with an Add button to add a new โWork Listโ item.
There are some work around ways that allow you to add multiple child rows at once and then edit them together in an editable table. I would recommend getting the parent/child tables established and setup first. Then come back to the community for additional help if you wish to enhance the user input experience.
Here is an article that may help with parent/child relationship - Scroll down to the section named "Expressing Ownership Between Tables"
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |