Sign in to join the conversation:
All: this is to share/record a way to push the submit button in a smartsheet webform using vba. I share this because I spent way more time trying different options posted on different websites than I would like to admit.
Dim IE As Object
Set IE = CreateObject("InternetExplorer.application")
IE.navigate "www.smartsheet.com/formurl"
IE.Document.querySelector("button[type=submit]").Click
Hi L@123, thanks for sharing. I wonder if you are sharing the information from smartsheet to a VBA form. If so I wonder what other steps I must take into account.
Best regards
Mau
I am moving information from a microsoft application such as access or excel to a smartsheet form, then automatically submitting the form with a method that requires very little programming knowledge. In order to utilize this, you update the url with a query string to autofill the individual fields (https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values) then submit.
If you wish to transfer data from smartsheet to a microsoft application, the reverse of what I am doing, an ODBC connection is the way to go. They have a decent tutorial on how to do this. (http://smartsheet-platform.github.io/odbc-docs/#overview)
As a Smartsheet user, I would like guidance on how to get started with APIs. I am looking for step-by-step instructions on how to understand, access, and use the Smartsheet API for basic tasks such as retrieving data, updating sheets, and automating workflows. It would be helpful to know the tools required, and best…
Anyone know how I fix my API Smartsheet token returning a 401 unauthorized error when trying to access a sheet I am the owner of and created myself?
Hello everyone, Looking for some assistance on the replacement of includeAll parameter for update column (Multi Dropdown). Looks like I'm limited to 1000 options now, so curious if there is a workaround. Any help would be appreciated on how people are using pagination or if this has been addressed a different way now.…
