Validating Excel spreadsheet data in ServiceNow
One of the most common uses of ServiceNow is importing and storing data. Data import is often facilitated through import sets and transform maps. But what if you need to ensure data accuracy before a file is even attached? By validating the contents of an Excel file in advance, you can prevent users from uploading […]
Attaching an Excel attachment via email in ServiceNow
We use transform maps for a lot but there are often times when we need to trigger a transform to occur on command, quite frequently through email. Assume you had a scenario where a client was interested in sending in a data source via email into the instance with the expectation that the data […]
Validating Excel spreadsheet data in ServiceNow
One of the most common uses of ServiceNow is importing and storing data. While import sets and transform maps have their own methods of validating the data before the data is imported into the system, it is also possible to validate the contents of an Excel file before allowing a user to attach it […]
