Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
I want to build time calculator in the existing timesheet entry page. I will add a new tab page after the Lines Tab page and it should look like as shown below.
If you see the above image, we have two filter dropdown at the top from where user would select Period start date and end date. This would ideally be the same as the timesheet period user has already selected while filling timesheet details. Then system should generate those many columns in the grid for each of these days. Max period would be 2 weeks long only.
Now as you see, i want to generate this grid having fix number of Rows having Row header in it. User will fill in the hour of 'Start' and 'End' for each day when he/she starts and ends the day at the work. The last row would just show the difference of 'Start' and 'End'. I have shown that in the '1-Jul' column. So basically it will show user the exact time he worked. This is the calculator which would show the instance Difference. We don't want to store any of these in the database. It will act as a pure calculator for the user.
I am not sure what control can help me to show such dynamics details. Does Grid control support the 'Row Header' where i am showing labels such as 'Start' ,'End' and 'Difference'? I believe somewhere temporary tables would help me to generate dynamic columns but not sure how to do the rows labels with it.
Has anyone faced this before?
You can configure time sheets in a way that users have to enter a start and end time rather than entering a decimal time value.
To me it looks that you try to develop something very similar/identical.
Are you aware of this standard start-end time functionality that can be enabled in the project parameters form in the HR module for your employees?
Thanks for your reply.
I just created a sample grid in the image that has 3 rows in it. However, it will have few more rows as well which i didn't put it in the image. so, It's not just about Start and end time.
I just wanted to have an idea how we would create such a grid that too in the existing Timesheet Entry Form as an extension.
Anyone with such experience of creating a Grid with row headers?
I'm not able to fully understand what you want to achieve and why. Where can a user define on what project he did work with what category and activity? Why should a user be able to choose a flexible time period? Why not just a fixed length with e.g. a period of one week?
What are the reasons why you are not using the standard time sheet features?
There is a dynamic layout framework in Budget planning, could possibly explore and leverage
Users may be Lazy or may not be able to calculate the difference between their start time and end time of the day. Hence, they would just put start time and end time and 'difference' field would show them the total hours worked. It's just a simple calculator of the time difference. It has nothing to do the project or timesheet.
They just don't want to calculate the different using their mind or a Calculator App available on their desktop OS.
Please have a look at how the standard timesheet feature is making the calculation.
My problem is not about how to calculate it. My issue is on how to generate UI with all those textboxes for each day as shown in the image in the question.
Instead of designing this in D365FO, you can alternatively use the excel addin and allow your users recording the time there exactly in the way illustrated above. They can then upload their recorded times into a project hours journal and get them posted.
I still do not believe that some modification/coding is necessary here :-)
I understand what you're saying on excel Add-in. The screen shot i have shown is just a sample one where user has to provide some input. There will be also a row which will show some of hours entered in the timesheet for each day (which is a sum of hours of a particular project categories only). I believe in that case i need to prepopulate that in excel add in somehow. not sure how to do that
Probably have a look at the available excel templates, such as the 'HourJournalTransEntryTemplate' that you can find the common module under the document templates. MS uses simple forumulas to make calculations there. Another good example is the 'LedgerJournalLineEntryTemplate' where you can also possibly 'borrow' things that have been realized there.
Finally, below post came to my rescue.
Business Applications communities