Hello experts,
I have a sharepoint page where employees log the times they start each operation for each work order. My goal is to make a form where they can enter all the information easily. It is one that would have to be opened multiple times to get the start and stop times for different ops. I have a button that fills each time entry with the current time upon clicking. This works well. Each cell works on different buttons for different times, and all of those are controlled with variables. Basically variable op1start is set to "" on visible for formscreen1, and when the button is clicked it is given a variable. The time cells work off the following formula:
If(MaskStop="",Right(Left(Parent.Default,5),2),Text(Minute(Now()),"00"))
This all works great the first time. The issue I have is after the form is closed, if you click NEW, when the new form opens the variables have not reset, so the time boxes that were filled in the last use now autopopulate with the current time. I have tried adding Set(Var, "") to multiple places as well as resetform(formscreen1) on save, on new, on success, everywhere I can think of, and none of them have helped. By all accounts a Set(var,"") at either on save, on new, or on visible, ought to do it. Is there something special about it being a form rather than an app? Any ideas of what I am missing?
Thanks!
Curtis
Share
Report
All responses (
Answers (
3,847
