ContributionsMost RecentMost LikesSolutionsBar Chart Report - Show Tasks by Date and include dates with no records I want to create a bar graph that shows users with records assigned to them by day of the week and have the bar chart show days of the week where there are 0 records for that day. I believe I have to do some type of report formula but I can't figure it out. Any help is appreciated. ------------------------------ Joshua Case ------------------------------ Pipelines - Outlook Events I have pipelines created for our service application to create tech dispatches via Outlook calendar events when tasks are created. I want to add a link to the task record in QB as part of the Outlook event body but I cant seem to create it. Can anyone help or know how to do this? ------------------------------ Joshua Case ------------------------------ Re: Creating multiple child records based on the quantity of a field in the parent tableIs there a way to now do this via a pipeline? I am looking to have records created in a separate table based on a QTY entered in the original table. So if a part is ordered and we ordered a QTY of 15. Create 15 new records in the separate table to then track each part's unique serial, MAC, etc.. ------------------------------ Joshua Case ------------------------------ Calculate Normal Hours and OT HoursI need to calculate hours that are considered OT or Premium vs Standard Hours based on a end-user in and out time. I am asking the end-user to enter their in and out time as part of the form. If the in time is before 7 AM EST then those hours from the designated start to 7 AM would be Premium. In the reverse any time worked past 5 PM would be premium. Example: In Time: 6 AM Out Time: 6 PM Regular Hours: 10 Premium Hours: 2 How do I make these calculations? ------------------------------ Joshua Case ------------------------------ Re: Anyway to remove the (tot) from a summary report column headers?Was this ever resolved? ------------------------------ Joshua Case ------------------------------ Re: % from QB to SharePoint shows incorrectlyThis is resolved. Had to convert the percentage from my QB field to an integer by doing a number formula of dividing my percentage field by 1. Example Code: [My Percentage Field]/1 ------------------------------ Joshua Case ------------------------------ % from QB to SharePoint shows incorrectlyI have a pipeline that is sending a numeric % field value to a NEW SharePoint item where the column that receives my QB % is formatted to be a number and show as a percentage. When the pipeline runs and sends the value from QB to SharePoint it displays as an incorrect % in the NEW SharePoint item. Example below. QB % Field Value: 20% SharePoint Number column display value: 2,000 % Is there any trick to have the value of 20% come over exactly as 20% in SharePoint? ------------------------------ Joshua Case ------------------------------ % from QB to SharePoint shows incorrectlyI have a pipeline that is sending a numeric % field value to a NEW SharePoint item where the column that receives my QB % is formatted to be a number and show as a percentage. When the pipeline runs and sends the value from QB to SharePoint it displays as an incorrect % in the NEW SharePoint item. Example below. QB % Field Value: 20% SharePoint Number column display value: 2,000 % Is there any trick to have the value of 20% come over exactly as 20% in SharePoint? ------------------------------ Joshua Case ------------------------------ Re: Pipeline - SharePoint Item Search Issue Would you run this as an expression first and then by the condition of finding the specific number? I am sorry I am new to using expressions like this. I ask because when I run this I find an item but it displays an error. I have the conditions set as this: ------------------------------ Joshua Case ------------------------------ Re: Pipeline - SharePoint Item Search Issue So if I made the column type maybe a line of text would that work best? Also the SharePoint is an older site, could that be contributing to the error? At the issues simplest form if I run a single step of just "search items", point it at the SharePoint and the correct list, add conditions where "QB ID" equals 602 (a known items related QB ID), I get a result of no records found. Could it have to do with field or column needing to be in the default report for the list? ------------------------------ Joshua Case ------------------------------