Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

automatically send web form daily

Hello,

is it possible to set a webform to be emailed daily so that the person can fill it out every day and add a line to the sheet? (this is for a timesheet).

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭

    I don't see a scheduling option in Forms so it's probably not possibe to use the Form UI to send it daily.

     

    For a work around you could try this:

    1. Create a sheet with two columns: Date and Contact list types.

    2. Share sheet with employees you are collecting timesheets from
    3. date column:  =Today()
    4. contact = employee

    5. Set a notication to send to the employee and set the date to be the 'Today' column.

    6. In the notification reminder message, past the URL for the form and tell the user to ignore the rest of the message.

     

    Tihs will send on weeekends and holidays, I am not sure if the workday() fuction will be able to conrol that.

  • Travis
    Travis Employee

    Brett, that would work but on 3. change it to =TODAY(1) which will be today + 1 day. Reminders need to be set at least one day in the future.  On 4. Set a reminder, not a notification. 

     

    There is likely a feature or add on you can use for your email client to send recurring emails. I did a quick search and see its possible in both Gmail and Outlook.  Try Googling "How do you send a recurring email in *name of email service*"

  • Lachlan Stead
    Lachlan Stead ✭✭✭✭✭✭

    Another work around for this is to get the form link, then on the sheet, select a row, go to file, send sheet as attachment, select PDF (options), select 'selected rows', ok, then type out what ever you want to say and put use below link to fill out form, and paste the link. You can then schedule recurring emails to be sent. It will have a blank attachment but it works! 

    Still, it would be great if smartsheet added a schedule function to the send form link option in more!

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

    Hi all,

    Good news! It's coming!

    Customers have requested the ability to set up workflows that repeat on a regular schedule.

    We're preparing recurrence for time-based workflows so you can save even more time on repetitive steps, such as daily due date reminders and weekly status update requests. This automation enhancement will be available this spring.

    https://community.smartsheet.com/discussion/coming-2019-recurring-workf…

    Hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

This discussion has been closed.