Web form notification

Sara Tucker

I have set up a sheet with a corresonding web form so people can order items that I will need to purchase for the company.  What do I do so I am notified immediately that a Web form has been submitted and the request has been added to my Sheet?

Atus Bartal

Sara,

 

Set up a notification at Alerts (bottom of the sheet) for immediate email alerts when anything changes.

Admin@PAT

Hi Sara, 

I had the same issue and was inadvertanly missing action items. In your webform add a 'checkbox/drop down list' or simply a text box that you can populate, as hidden and populate it as 'checked'. I called this column NEW in my sheet. I then set up an alert that emailed me immediately when a NEW item was loaded. 

 

As the box is 'hidden' and 'always checked/populated' now I never miss any new line that are put in using the webform. Once you place the order or add it to your list elsewhere you can then change - if a dropdown list like mine to 'complete' or 'added to order' to indicate you have actioned it.