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

John Ivancic

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

Jay Bautista

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

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.  

John Ivancic

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? 

Kennedy Stomps

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!

John Ivancic

Hi Kennedy,

 

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

 

Cheers,

 

John

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