Blog Tech Tuesday: Connecting to SmartConnect and SmartConnect Online From Excel It’s no secret that getting a hold of your data in Excel is important (and sometimes absolutely necessary) for many...
Blog Tech Tuesday: Using Power Query to Merge Worksheets for the Excel Addin If you have multiple sheets in an Excel file that need to be integrated with the SmartConnect Excel Addin, this...
Blog Tech Thursday: Source File Name from Excel Folder Data Source If you’d rather watch a video explaining this, see below or click here. In my last blog post, we discussed...
Blog Tech Thursday: Resetting the web client password in SmartConnect One question I’ve seen come in a few times recently is “how do I reset the web client password in...
Blog Tech Tuesday: Returning max records in SmartList and SmartView If you try to compare records between SmartView and SmartList and they do not match, it’s possible it is because...
Blog Tech Tuesday: Extender Window Notes Hide Fields Have you ever created a Note Window within Extender and when you open the note window, you wished you could...
Blog Running SmartConnect from PowerShell Many people are choosing to do administration of common tasks using PowerShell and the SmartConnect customer base is no different....
Blog Tech Tuesday: Connecting to Various Systems using Excel In recent versions of Excel, Microsoft has put a lot of time into making it easy to pull data from...
Blog Tech Tuesday: Calculating Sequence Numbers when Creating General Ledger Transaction with Analytical Account (AA) In a prior article I discussed how to create General Ledger Transactions while including Analytical Accounts but with the assumption...
Blog Tech Tuesday: Filtering Columns in SmartView With the latest release of SmartView (18.0.6) we now have the option to filter columns more precisely. In the past,...