A man has been appointed to the role of “period dignity officer” in Scotland and many women have taken to Twitter to express their frustrations.