Hi everyone,
I'm a complete beginner on power apps (and programming in general), so I may be biting off more than I can chew.
I'm trying to work on an app for filing and printing service reports.
Each report requires the following fields:
- report number
- customer name
- customer reference
- machine type
- machine serial number
- type of intervention
- reason of call
- intervention description
- dates with hours worked for each day (travel, work start, work finish, break)
My current situation is:
- I have created two lists, one for the reports with all fields ("Service Reports") save for the dates and one for the dates and hours ("Timetable").
- I managed to create a summary collection with an overview of which records are inserted in the "Service Reports" list.
- I created a detail window to view a selected item in the list.
- I created a form to add a new record to the service report list.
- I created a "print" button and window to have a printout of a report, with a button that sends a pdf of the page to the user and a normal print button.
- I created a form that allows the user to write a date and hours in the Timetable list.
And this is where my troubles begin.
In order to be able to fill the list I had to use only text fields:
The "add to calendar" button adds a line in the list, and each box corresponds to a different column.
What I need now is finding a way to select the date -which is usually more than one day- and lookup the other columns (hours) from the list above and put them on the bottom of this page:
Does anyone have any piece of advice?
I was thinking of adding something in the "edit" window, but I wouldn't know how to bind the two things (the report and the days/hours) together.
