Can Smartsheet get data from custom HTML forms on a website?

edited 12/09/19 in API & Developers
08/23/19 Edited 12/09/19

Hello,

If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit prettier. 

Thanks in advance!

Comments

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

    Hi,

    The third-party service/integration Zapier could probably work for this scenario. Is that an option for you?

    Hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • edited 08/23/19

    Hi Andrée,

    Thanks for your reply! Unfortunately, Zapier is not approved for use in my company. Are there any other options?

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

    Happy to help!

    Would it be ok with another integration like for example, the Google Forms one?

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • If you have developer resources you could look at using the Smartsheet API instead of third party integration service. Using the Smartsheet API you could add a new row to a sheet after the form submission is made. Note, requests to the Smartsheet API cannot be made directly from the browser on the form submission, but if you have a custom form built already you could have the form submission be sent back to your own server where the form is hosted from. Then you could write code that takes the form data and makes a request to the Smartsheet API from your server to add a new row to a sheet.

  • Stephanie ReedyStephanie Reedy ✭✭✭✭✭

    I'm also having this issue. I've tried Google Forms as we are moving to G-Suite. However, the Google Form to Smartsheet add in does not move the attachment. It also doesn't have a way to insert a primary key that is hidden to the user. 

  • Stephanie ReedyStephanie Reedy ✭✭✭✭✭

    I'm having the same issue. Were you able to find a way to do this?

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

    Unfortunately not!

    Can you describe your process and needs in more detail?

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.