Send a form out daily track responses on separate row...

Send a form out daily track responses on separate row...

We have a form we would like to send to employees every morning, then be able to track each response separately. Tried automating the sending out of the form but when employees respond it overwrites the previous response because it was a "request for update". We need to track each response separately.

On the same sheet when we send out the form it is sending a preview of the sheet. We don't want this to happen. What are we doing wrong?

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Tiffanni Sanstra

    I’d recommend creating a form and then add a link to the form in an Alert and send that out.

    Would that work?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • We tried that but when we do the email is showing a preview of the sheet and we don't want that.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Tiffanni Sanstra

    In the advanced options of the alert you can select which columns to include. You need to at least select one.

    Would that work?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • We tried creating an alert and that does work however it is showing the sheet and the answers which we do NOT want. Does anyone know how to not show the sheet preview at all? We did limit the columns, but it looks weird to send a blank sheet. Would prefer not to show the sheet at all.

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 05/28/20

    @Tiffanni Sanstra

    It doesn't sound like you're sending an Automation Alert.

    Are you?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Andree,

    We are new to Smartsheets, but yes we believe we are sending an automation alert.

    What we are not understanding is why the alert is sharing a snapshot of the sheet with everyone. Even when we hide the columns it still sends the snapshot. Having difficulty figuring out if it is a permissions related issue or just our lack of understanding of how the Automated Alert works.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Tiffanni Sanstra

    Strange!

    Can you maybe share the sheet(s)/copies of the sheet(s) or some screenshots or the alert? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.