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)
raise HttpError(rex, "SSL handshake error, old CA bundle or old OpenSSL?") from rex smartsheet.exceptions.HttpError: (SSLError(MaxRetryError("HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded with url: /2.0/sheets (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED]…
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…
The new version of the api (FolderResources.GetFolderChildren) isn't returning correctly the createdAt and modifiedAt fields for sheets. As an examplle the following call isn't returing the fields correctly : SmartsheetClient.FolderResources.GetFolderChildren(9999, null, null, null, null, null, null); Can someone raise…
