Derek Wormald was arrested and charged following an incident at Rhythm & Booze in Market Place on Saturday 6th August.
The 48-year-old appeared at Mansfield Magistrates’ Court on Tuesday.
He has been charged with attempted robbery and two firearms offences.
Wormald, of Cinderhills Road, Holmfirth, West Yorkshire, has also been charged with the robbery of a bookmakers in Swadlincote, Derbyshire on Tuesday 2nd August.
He was remanded in custody and is due to appear at Nottingham Crown Court on Tuesday 23rd August.
Anyone who was in Retford town centre at the time and who saw the man, the vehicle or who witnessed the incident is asked to contact Det Con Debbie Burton or Det Sgt Andy Rhodes at Retford CID on 0300 300 9999.
Alternatively they can also call Crimestoppers annonymously on 0800 555 111.