This is a little bit more complicated than it needs to be so I’m pretty sure someone can make it less complicated but here is the rough layout, and it works pretty much flawlessly as it is. You will need a Zapier account to make this work but the good news is you can...
