I am having a ticket system where workers can clock-in during their worktime. This is going to be complex and I am not sure if it will be possible.
How the app looks like: https://gyazo.com/c8761eaa962db09ceb8dff502ba24321
You see 2 dropdowns at the start, tijd begin and tijd eind. these are the starting and end times. The textfield tijdtotaal is the formula bases on these 2 dropdowns. It calculates the time between them.
An employee can work more than 8 hours a day and fill in multiple tickets, because they can work on different projects.
Whenever tijdtotaal of the day they are wanting to fill in a ticket, is higher than 8, I want it to make a new ticket with the rest of the hours.
This may be very confusing, it is quite hard to explain. I will give an example now:
On the screenshot above you will see 2 rows (2 tickets) that have been filled in by an employee. You can see the date is the same of these 2 tickets.
You see the 4,25 and 4,75 which is the column for tijdtotaal. Whenever this column goes over 8, I want to get another ticket and the second ticket should only be going to 8.
So it should like this:
It took -1 hours of the second ticket and created a new ticket with ALL the same details, except, this ticket has the 1 hour that went over the 8 hours.
Just using this code to send the form away: SubmitForm(EditForm1)
I hope I have explained this well enough, if I didn't, let me know and I will try and explain it better.
Not exactly what I need with that -8.
If the first ticket is 5 hours and another one gets created with 4 hours, it will look like this now:
How it needs to look:
Learn how to create your own user groups today!
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!