title: Alternative to Excel userform in google sheets
body: <p>Been looking around and can't find an answer..</p>
  
  <p>I have to create a piece of work. where several users create a "Order" that then gets submitted into a database sheet.</p>
  
  <p>In Microsoft excel I would usually create a button that opens up a userform with my various fields that need to be entered, the user would then click submit.</p>
  
  <p>When submitting it would check the data and then if all ok add it to a tab within the workbook.</p>
  
  <p>I am trying to replicate this in google sheets.. any ideas?</p>
  
  <p>I looked at google forms but that doesn't really work as the user would need to see what was previously submitted (Hence why I liked to use MS excel userforms as it is a pop up)</p>
  
  <p>Thanks</p>