[Music] hey everyone it's justin thank you for watching in this video it's a hashtag bill with aes i've got to get this done i didn't realize the deadline was september 4th which is this coming sunday so i pulled an app that i did actually build as a poc for a customer i wanted to show that we could capture not just time worked within servicenow but we could do some stuff with that time worked so what i did in aes is i created some tables here you can see i've got a time work table so basically this duplicates the time work table but it has billable time works it had some fields in it that the customer needed then i have a table to store a list of the catalog items that are billable and a list of the incident categories that are billable so if someone wants to put a new catalog item out there they can just go add it to this table and mark it as billable and now when anybody logs time against it it'll take that time and write it to this new table and put the cost in there and stuff like that the other thing that i had in there there's actually another table you can see all four there's the billable rates so this table contains a start date a stop date and the actual rate for what that rate was at that particular time so that was the table structure for this app i built in aes i've got a workflow that essentially says hey if something gets added to the time work table and it's in the available time word category for incident or it's a catalog item that's billable go right to this table and pull in the latest value it's got some security wrapped around it and essentially it creates a table that can be exported to csv or exported to an excel file and taken that and put into a finance system it actually was really easy to build i separated all of it from the out of the box capability for time worked so that way it's encapsulated within this app so when that customer goes to do upgrades they're not going to have to worry about skips and issues with out of the box features so it's completely separate while it does look at the time work table it copies all over into this application and takes care of it so i hope you found this video helpful if you did please like please subscribe or share with somebody who might be interested in building applications in app engine studio and until next time don't forget to always be learning [Music] you