User-submitted forms: Is there a way to have email address and name be automatically added to my Con

I have an "Update Request" Smartsheet, where employees can submit a request via a form. The 'name' and 'email' fields are both required, so I'm capturing those fields on every submission. BUT even though someone enters an email address and name, I still have to manually add that person to my Contacts.

How can I set my form so that each name/email address that is submitted will be compared to my Contacts list and automatically added if not already there?

Find more posts tagged with

Forms

Sheets

Contacts

Education

Marketing

Account and User Management

Comments

Alison

Hello Izi,

Thank you for contacting Smartsheet Support. At this time, Smartsheet does not support this functionality; however, I've let our Product team know about your request. Due to the large number of variables they have to consider when choosing what to develop next, we can't confirm when or if this will be built, but we have let them know.

You can always add more requests under "Submit Product Enhancement Request" under "Quick Links" to the right-hand-side of this page.

I'd love to know if anyone else has found a way to make this work so that I can let our team know.

Kind Regards,

Alison

Smartsheet Support

Alison

Hi Izi (again)!

I wanted to confirm that I looked into this further and I saw that the email addresses that are placed into a Contact List column, though they won't show up in your Smartsheet Contacts, they would populate under "Select Contacts" in your Update Request form.

I've included a few screenshots of this.

Please let me know if you have further questions on this.

Kind regards,

Alison

Smartsheet Support

Screen Shot 2018-03-05 at 2.21.12 PM.png

Screen Shot 2018-03-05 at 2.22.16 PM.png

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…