Does Smartsheet allow for integration with Access database tables?
Is this something that a connector is needed for; such as Data Uploader?
Will the integration work with older editions of Access or only Microsoft 365?
HI, Integration is possible via the Smartsheet Data Connector - https://www.smartsheet.com/marketplace/apps/live-data-connector . Although it does not mention Access specifically it does work with Access and with normal desktop versions of Access as well as the version delivered via 0365. The connector will provide a read only link to your Smartsheet sheets and reports.
If you need to be able to pass back data from Access to your sheets then that is a job for some custom code written using the Smartsheet API. We provide custom apps that do this.
cheers
Dan
"If you need to be able to pass back data from Access to your sheets then that is a job for some custom code written using the Smartsheet API. We provide custom apps that do this."
Could I get some more information on the custom apps your are referring to...
I would like to link an Access query to Smartsheet. The query needs to be refreshed by the user within Smartsheet so as to provide the most current information available.
I am trying to apply logic to my dynamic view that will prevent the rest of the questions from being required/answered if "No" is selected for "Ordered Restraint Initiated". I am testing it with just a couple of fields - I tried both required and non-required fields and it doesn't seem to work. Once I save the changes and…
Hello Bridge folks! Scenario: I’m calling an API that paginates its response data by providing a “next_page_token”. I use this in another call to get the second page of the response data. I’m using a child workflow to run once to get the first page of data, determine if there is a next_page_token, and if there is, call…
We have a user that is having issues with the Smartsheet connector, where shared or owned sheets are not appearing when selecting the desired sheet. In this case it is the add a row function. Permissions have been verified, other attempts to rename the sheet which had worked in the past also did not work. Any suggestions…
