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.

How to show the actual person who added information to a sheet

John Ivancic
John Ivancic ✭✭
edited 12/09/19 in Archived 2016 Posts

In smartsheet, you have the Created By and Modified By autonumber system properties. If you have created a web form, any responses provided via the web form reflect "web-form@smartsheet.com" in those columns. Is it possible to get the actual persons email who submitted the information via the web form reflected there instead?

 

Appreciate any and all responses

 

John

Comments

  • Make the Web Form accessible by registered SS user (requires log in) and that will show the e-mail account of the contributor.

  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    Jay's response is one way but it resticts you to Smartsheet users and/or collaborators or you can create columns for the webform user info and make that info a "Required Field" on the webform.  

  • Hi Jay Bautista and Stephanie Taylor, Thanks for the input provided! Considering the audience I am dealing with and the fact that the whole point of the webform (at least in this case) is for pure speed of information delivery, adding one more field of that nature may not bring us the required result each time. Ideally, it should be a purely automated process. I wonder if this could be a future improvement? Cool

  • Kennedy Stomps
    Kennedy Stomps Employee
    edited 09/08/16

    Hi John-- To confirm, Smartsheet would need a way to "know" the email address of the user inputting information into the form. The only ways to do this are to either limit the form to logged-in Smartsheet users, or to require users to enter an email address when filling out the form. Unless one of these functions is implemented, there's simply no way for Smartsheet to "know" the email address of the user submitting the form. Hope that helps clear things up!

  • Hi Kennedy,

     

    Thanks for the final clarification on this. Appreciate the help from all!

     

    Cheers,

     

    John

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Also, if requesting user to enter email address, Smartsheet does not currently validate it as a valid address, much less the correct one.

    There are other web forms tools out there that can connect to Smartsheet quite easily and those might be a better solution for you.


    Craig

This discussion has been closed.