ContributionsMost RecentMost LikesSolutionsCustomize "Save and Keep Working" when there are two formsI have two forms in my Project Portfolio table that each display different data for a project record: Project Request and Project Record. The project request form is limited to only specific intake fields and the project record is a complete record of project data. The table has multiple relationships, pulling related data from other tables/apps. When the project request form is used, and the requestor needs to relate a project to a facility or contact, they have to save and keep working. When they do, it redirects them to the full project record form which I don't want to happen. I want the save and keep working to save and stay on the project request form. Is this possible, and if so what do I need to do? I can't restrict the forms by roles because sometimes a requestor is also a project manager and they would need access to the full project record form to do other work. Thanks in advance for your help! :) ------------------------------ Sherry Blackburn ------------------------------ Re: Date/Time duration formula in hours, excluding 12am-4amThat's it!! Works beautifully. Thank you so much for your help.Re: Date/Time duration formula in hours, excluding 12am-4am Spoke too soon. When the outagerange includes Saturday or Sunday, it is returning 0 hours for those days.Re: Date/Time duration formula in hours, excluding 12am-4am BINGO!! It works perfectly. Thank you so much! We are happy dancing over here.Re: Date/Time duration formula in hours, excluding 12am-4am I changed the field type, but it is returning 0 no matter what date/time I put in the start and end fields. I don't think I need the var Number WeekDayDays. Ourstations operate365 days a year, round the clock with the exception of midnight to 4am. This is by far the most complicated formula I've worked on, so feel free to treat me as a beginner :) var timeofday DayStartTime = ToTimeOfDay("4:00 am"); var timeofday DayEndTime = ToTimeOfDay("12:01 am"); var datetime StartClock = [Outage Start Date/Time]; var datetime EndClock = [Outage End Date/Time]; var DateTime StartDateTime = Max($StartClock, ToTimestamp(ToDate($StartClock), $DayStartTime)); var DateTime EndDateTimeTesting = If(IsNull($EndClock), Now() ,$EndClock); var DateTime EndDateTime = Min($EndDateTimeTesting, ToTimestamp(ToDate($EndDateTimeTesting), $DayEndTime)); var Number WeekDayDays = WeekdaySub(ToDate($EndDateTime), ToDate($StartDateTime)) + 1; var number HoursBeforeStartEndAdjustment = $WeekDayDays * ToHours($DayEndTime - $DayStartTime); var datetime StartDateTimeBounded = If(ToTimeOfDay($StartDateTime) < $DayStartTime, ToTimestamp(ToDate($StartDateTime), $DayStartTime), $StartDateTime); var datetime EndDateTimeBounded = If(ToTimeOfDay($EndDateTime) > $DayEndTime, ToTimestamp(ToDate($EndDateTime), $DayEndTime), $EndDateTime); Max(0, Round($HoursBeforeStartEndAdjustment - Max(0,ToHours(ToTimeOfDay($StartDateTimeBounded) - $DayStartTime)) - Max(0,ToHours($DayEndTime - ToTimeOfDay($EndDateTimeBounded))),0.1)) Re: Date/Time duration formula in hours, excluding 12am-4amI'm getting this error. The field type is "Formula-Duration".Re: Date/Time duration formula in hours, excluding 12am-4amThe reason for the exclusion is that the equipment is not in service during those hours. So we want those hours removed from the calculation, so that the outage hours only reflect the hours when the equipment should be operational for service, but is not. It is highly unlikely, but not impossible, that an outage would be resolved during those hours. An outage could last more than one day, so those hours would need to be excluded for every 24 hours. Date/Time duration formula in hours, excluding 12am-4amI am calculating elevator/escalator outages and need a formula that will calculate the hours between two Date/Time fields "Incident Start Date/Time" and "Incident End Date/Time". The kicker is I need the formula specificallyto exclude the hours of 12am-4am.Thanks in advance for your help!Re: January 2018 Release Notes Correction: Happens when opening an app from the tab, but then goes away after clicking on the Home icon (sometimes takes 2-3 clicks to go away). Re: January 2018 Release NotesSame issue here. Only happens when in the table view, not from the home page. I'm using IE.