My team and I are attempting to create a board that logs when our staff goes on duty and off duty. Although we’re having trouble with getting it to keep to just on-duty and off-duty statues when using text or even booleans. When setting it up at first, it shows on duty, we click it again, and then it shows off-duty. After that, nothing else is registered. What are we doing wrong and has someone attempted to do something like this before?
My first guess, if using a boolean, is that you aren’t accounting for the fact that it can be in one of three states (blank, false, true). It’s best to never explicitly check for false. Only check for true or not true.
This is currently what I have set within the spreadsheet although it isn’t functioning on the front-end though even though I have an action connected to it.
you are using a spreadsheet (GS) to save your duty status and your Status Types column depends on this value from GS, right?
Maybe you are having a synchronization problem when you change the status quickly. When Glide sends a value to GS, it waits 5-8 seconds for any update and if this is carried out several times at a short time you could have a ping-pong effect and see wrong values.
Would you mind creating your logic and test it using a Glide Table instead? A GT is better than a GS in these cases.