I figured that an application like this can help as this can be used for all sorts of businesses that provide a delivery service or conduct on-site work. I appreciate any input on how to solve this problem. Is there some sort of nested If statement that has to be used when creating this specific Collection? My dilemma is this, how does one create a collection that updates based on the latest changes and creates a row that's specific on both location and shift? Since there are 5 locations and two different shifts per location, there should only be 10 rows total. Creating a collection with these specific parameters.I already know how to use the Distinct formula when using a dropdown menu.When a driver selects a location, then either Day or Night Shift.There will be a separate row depending on if it Day or Night shift.It will only collect the most recent changes to the schedule.This collection will contain data from the "CrewSchedule" table.Create a collection (either OnStart or after the Crew Schedule is updated).Here's the steps that I know I have to do to make this work: The data table contains the following columns: There are 5 locations in which a delivery can originate.įor purposes of brevity, I will skip the email portion of the app and skip how to save data to a database, as these topics have been covered extensively in other posts. Each delivery or job is then saved to databased, a report is emailed, and can be viewed within PowerApps. Then, when a delivery is being made, a driver will create a log of which worker and their job role was on the delivery. This schedule can be viewed by anyone in the company within PowerApps A manager or shift lead can create a schedule, which is saved to a database and emailed to the company. There are two shifts, day and night shift. I'm developing an application that creates and manages a work schedule.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |