ContributionsMost RecentMost LikesSolutionsTest As Role URLs? I have an app where I rely heavily on roles and role permissions to view certain data and forms. Because of this I need to test as a role when developing new roles to ensure the users cant access other roles data. Is there a way to get these "test as role XXX" as a callable URL I can map to a button on the admin dashboard? I want to use the custom branding setting in the app to hide the Quickbase standard menu options for all users so they can't try and get to the My Apps page in our realm. Is the custom URL to test as a role possible? Bar 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 ------------------------------