ContributionsMost RecentMost LikesSolutionsRe: Button that can change a field and then go to edit modeawesome thanks, Mark! It works ------------------------------ Endy Lu ------------------------------ Re: Button that can change a field and then go to edit modesure thing, this is my code var text Declined = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=dghxdxrc9kgh4qbn746c7dje9wds&rid="&[Record ID#]&"&_fid_6=Declined"; "javascript:{"& "fetch('"& $declined &"');"& "location.reload('"& $Declined &"');"& "}" ------------------------------ Endy Lu ------------------------------ Button that can change a field and then go to edit modeI have a declined button where when you press it, the status will be changed to declined. However, I put in a rule where a status cant be declined without a decline reason. Currently, when the button is pressed it will bypass my rule. Is there any way I can make my button change the status to declined and then go to edit mode, so I can choose a decline reason? ------------------------------ Endy Lu ------------------------------Button that can change a field and then go to edit modeI have a declined button where when you press it the status will be set to declined. However, I put in a rule where a status cant be declined without a decline reason. Currently, when the button is pressed it bypasses my rule. Is there any way I can make my button change the status to declined and then go to edit mode, so I can choose a decline reason? ------------------------------ Endy Lu ------------------------------ Re: Date/Time duration formula in hours, excluding 12am-4amhow will this formula works if I want to exclude weekends? I only want to include regular business hours 9-5 Monday to Friday! ------------------------------ Endy Lu ------------------------------ Calculating duration for business hoursI have a formula where it is tracking how long does a rep stay on a current status. I'm using the following formula to calculate this but it seems like it is also including the hours during the nonbusiness hours(9am-6pm). Is there a way to write a formula to only calculate the hours during our office hours? ------------------------------ Endy Lu ------------------------------