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.

Can one web form populate different sheets

Options
Jay Sanders
edited 12/09/19 in Archived 2015 Posts

I'd like to know the following re web forms:

 

One - Can one web form submission populate different sheets

 

Two - Can web forms assign unique ID#.

 

 

Comments

  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭
    Options

    Jay, 

     

    One - No. one web form cannot populate different sheets, but a sheet can have more than one webform.   I haven't heard of a limit.   One idea would be to use a report to capture the data from the other sheet for the another team to review.  I don't see think cell linking would work since the data won't exist until the webform is populated and submitted.

     

    Two - webforms CAN assigned a unique ID#.  Setup an column with Auto-number properties and each time a row is added to the sheet, the cell will be autopopulated with a unique ID. I use this for a Help Desk Trouble ticket system and have SS assigned a Ticket #.   My populates with ###-MM/DD.   Read here for details:  http://help.smartsheet.com/customer/portal/articles/1108408#advanced 

     

  • Raymond Cich
    Options

    Actually you can populate one sheet using a web form and them populate the additional sheet(s) using zapier. See recent webinar with Erin harlin from smartsheet on you tube about automating smartsheet

     

  • Travis
    Travis Employee
    Options

    Here is the YouTube video on using Zapier to automate your work: https://www.youtube.com/watch?v=adyrvA-bZfs

     

  • Jennifer Dewhurst
    Options

    Another possibility is using AppSheet as a companion to your webform. You can link more than one sheet to AppSheet, which is also compatible with SmartSheet. It has the added benefit of being able to be used on mobile devices. 

  • Angie Hatfield
    Angie Hatfield ✭✭✭✭
    edited 10/26/18
    Options

    Before I dig into Zapier or Appsheet, I was wondering if there is a more recent way to do this?

    I have three sheets. One has the web form. Once a new submission arrives, I then go in and move it to the appropriate sheet. I don't want to create multiple forms, because the only difference is one selection.

    I don't mind have the form info on one sheet and then copied, linked, moved to the other sheets.

    I thought about using one form with two separate reports, but the other 2 sheets have more info than the first sheet, so it won't work.

    Thank you

This discussion has been closed.