Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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)
Hi, We are a developer and building a custom web platform for one of our client who is using smartsheet. Our platform needs to get data from smartsheet and need to show the data in our custom UI. Could anyone recommend the APIs we should be using for this?
This solution updates a column formula across multiple sheets in a workspace. The script finds all sheets with a certain string in the name, finds a certain column by name on those sheets, and then updates all column formulas to a new column formula. At the time of posting, Control Center Global Updates did not allow me to…
We have a webhook created in one of our Smartsheets, and we've been noticing lately that the webhook callbacks immediately disables the webhook after 1 try, causing data discrepancies between the Smartsheet and the system it sends the data to. Here's an excerpt JSON message received from Smartsheet showing the callback…
