Email notification after change a sheet

Yonatan Shalev

Hi,

 

Can i set to recive an email once someone have entered a  new web form update?

 

10X

JLC

Hi Yonatan, if I understand what you're asking correctly, I've set up a workaround for the exact same thing on one of my sheets. First I added a new checkbox field in my form (Web Forms > Add Field > Create New... > Checkbox) and named it "New form submission" for clarity. Then, I changed the options of this field to be hidden (Display Type > check "Hidden Field") and automatically checked (Default Value > select "Checked" radio button). When back in my sheet I hid the "New form submission" column that was created as I don't actually need to see it. Then, I set up the alert: Alert > New Notification > Send (recipient) an email (how often you want to receive it) when "New form submission" changes. Hope that makes sense!