My app’s URL: borrowwamsipad.glideapp.io
In a nutshell, I have a form button feeding a log. In that log I have a field called “Status” which is either “available or unavailable”. I also have an if/then called “Next Status” which gives the opposite status.
On a homescreen sheet, I have a lookup column that’s finding both the status and next status of an item. The homescreen displays the current status (Status) and has the form button that send the “next status” to the status column of the log (to complete the loop).
The glitch I’m experiencing is that even though I’m sending the “next status” value to the log, the current “status” value is the one recorded. The only thing I can think of is that it’s calculating the if/then in the log prior to the data actually being recorded which then would throw off all the conditions. Thoughts?