Does the WeWork app have to be open for this to work?

No, the app can be closed, but your phone must be powered on with Bluetooth enabled, and location services always allowed.