Posts Tagged ‘scripting’
Tech Tuesday: REST Lookups
This week we are going to look at REST Lookups and how they can simplify your integrations with REST APIs. We will be investigating several REST API features. We will be showing the configuration in SmartConnect.com, but all the same features are available in SmartConnect 21. Table of Contents What are REST Lookups? Adding a…
[Read More]Tech Tuesday: Fix Missing GP Accelerator Keys with Extender Enterprise
I’ve seen this question several times over the last few months and typically happens after a customer updates their GP from 2010 to a newer version.I’ll get a screenshot like this (boxes added by me for later clarification)Fig 1: GP 2010 with Accelerator keys visible for GP windowsand a message similar to this:I have just…
[Read More]Tech Tuesday: Conditionally Auto Opening an Extender Window with Extender Enterprise
The initial question was straightforward:I have an Extender window based on the Item Number in the Sales Transaction Entry scrolling window, is there a way to conditionally automatically open the Extender window based on that Item Number?We can start with the “easy” answer (ignoring the “conditionally” parameter).Extender can be configured to auto open an Extender…
[Read More]Tech Tuesday: Adding Script Namespaces to SmartConnect
SmartConnect has a feature that allows users to add scripting namespaces to enhance the scripting capabilities in any of the coding windows within SmartConnect (calculations, script tasks, restrictions, etc). SmartConnect has a few generic namespaces that include the majority of the classes and methods you would use in most scripts; this includes System.Windows.Forms, System.IO, System.Data.SqlClient,…
[Read More]Tech Tuesday: SmartConnect Secure Global Variables
This Tuesday we are taking a look at a feature that can be used within scripting to help improve the security of any tasks that you create. Secure global variables have been added to SmartConnect to allow users to store data in a variable that encrypts the value to prevent others from looking at the…
[Read More]SmartList Builder 2013 New Feature of the Day: SQL Scripting
SQL Scripting is a feature that will soon be available in SmartList Builder and Navigation List Builder with the next release. You will no longer have to go to SQL Management Studio and create a SQL View to pull into SmartList Builder when you want to write SQL Scripts to get the data you need.The…
[Read More]Extender 2013 Feature of the Day: Improved Scripting
What has changed in the scripting?The Enter Script window has been simplified and make to work similar to the way the Add Calculated Field window works. Whether you are entering a Dynamics GP Script or a SQL Script, the window will look about the same. The SQL Script window will ask you which company to…
[Read More]Tech Tuesday – SmartConnect 2012 Scripting Updates
This Tuesday we’re taking a quick look at the scripting windows in SmartConnect. There are a couple of improvements that have made scripting much easier and more useful in SmartConnect in the latest 2012 versions.I am especially excited about these new features since a lot of my work in SmartConnect revolves around developing scripts and…
[Read More]Scripting inside SmartConnect
For all of you out there that have been doing scripting inside of SmartConnect, we have an excellent (although belated) New Year’s gift for you. We have assembled a collection of the most requested scripts over the last year and have commented and formatted each script in detail. They are now all bundled together and…
[Read More]