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)
Hello Smartsheet Team, Thank you for the notification regarding the upcoming API changes. We primarily use the Smartsheet API through third-party integration platforms (Zapier and Domo) rather than custom-built solutions. I would like to clarify the following points: Will Zapier and Domo automatically handle the API…
Hi Everyone, I have a Console Application that was developed using .NET Core 3.1 and Smartsheet SDK version 2.126.0. The application currently uses the following endpoints, which are scheduled to be deprecated in early 2026: GET /workspaces/{workspaceId}/folders GET /workspaces GET /workspaces/{workspaceId} GET…
Hi, Zapier Integrations team here. We are experiencing users reporting being unable to set up a webhook subscription to Smartsheet when a POST request is made to https://api.smartsheet.com/2.0/webhooks Response received { "errorCode": 1008, "message": "Unable to parse request. The following error occurred: Field 'name'…