Sign in to join the conversation:
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?
Sara,
Set up a notification at Alerts (bottom of the sheet) for immediate email alerts when anything changes.
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.
