Alerts

How do you set an alert if a line of data has been added to your spreadsheet by a form submission or manual entry by others?

Best Answer

  • SRLinhardt
    SRLinhardt ✭✭✭✭
    Answer ✓

    You would want to add a workflow.

    Use the "Alert someone when specific criteria are met" template.


    If you want it to be any, then you can leave the trigger as "when rows are added or changed" when "any field" changes.


    Then specify who needs the alert and customize the message.

    Having a form populate the rows or a manual entry will both trigger this alert.

Answers

  • SRLinhardt
    SRLinhardt ✭✭✭✭
    Answer ✓

    You would want to add a workflow.

    Use the "Alert someone when specific criteria are met" template.


    If you want it to be any, then you can leave the trigger as "when rows are added or changed" when "any field" changes.


    Then specify who needs the alert and customize the message.

    Having a form populate the rows or a manual entry will both trigger this alert.

  • Sirius_200
    Sirius_200 ✭✭✭

    Thank you @SRLinhardt ! this is what I needed! Thank you!