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)
I’m a Smartsheet admin and recently received an email regarding upcoming API deprecations. I want to confirm my understanding that no admin‑level or tenant‑wide action is required, and that any necessary changes would apply only to user‑owned scripts, integrations, or workflows that are directly calling the affected APIs.…
Hi everyone, I recently received a notice from Smartsheet regarding upcoming API endpoint deprecations and the 90‑day warning period. As a System Admin, I was informed that users in our organization are actively using Smartsheet API tokens, and some older endpoints will be sunset by June 3, 2026. Before we make any…
Is anyone having issues with the add row API function? Seems to be hindering for about an hour now on my end.
