AutoStore: AutoCapture Default Date


I recall the very first script that I ever created for a workflow with AutoStore. The scenario was for a small but very busy accounting team who needed to scan invoices, and have them delivered to a shared folder that was named Vendor Invoices in a more organized way.

In order to demonstrate how an alternative process could work, I configured an AutoCapture Form with three fields to collect the following:
  • Vendor Name
  • Invoice Number
  • Invoice Date

The Vendor Name value would be used to create the subfolder, and the file name would be comprised of the Invoice Number and Invoice Date values. The next stop was a demonstration for the client.

They were able to see a real improvement to their current process in terms of the time savings for capturing invoices, which were estimated at an average of 40 per day. Paired with the ability to easily locate the document at a later time using a well organized folder structure with consistent file naming, all of it was clear and simple.

Because most invoices would be from the previous day, I was then asked if there was a way to set the Invoice Date to yesterday's date by default.

In an instant, I recalled installing an available update on my AutoStore 4.6 server for the AutoCapture component that contained a newly added VBScript option. Not long before this moment, I had visited my local bookstore, purchased the title Microsoft WSH and VBScript Programming for the Absolute Beginner, written by Jerry Lee Ford, Jr., and remembered reading about data types, in particular, working with dates.

Indicating my high confidence to the client that this could be done, but that I would need to confirm, I returned to my AutoStore Process Designer later that day to do just that.

The first thing I did was go to the VBScript documentation found in the help file. I located a method named SetFieldValue. To use this method, the Field Name and Field Value parameters need to be supplied.

AutoCapture SetFieldValue Method
Form.SetFieldValue FieldName, FieldValue 

After several failed attempts, I realized that the Run on form load setting for the Form's configuration needed to be enabled, and was then able to see the current date value set into the Invoice Date field using the following line of code in the Form_OnLoad event handler.

Setting an AutoCapture Date field to the current date
Sub Form_OnLoad(Form)
    Form.SetFieldValue "Invoice Date", Date()
End Sub 

VBScript has a built-in function named Date() that returns the current date of the system. Next, a little subtraction to the current date, and the result becomes yesterday's date.

Setting an AutoCapture Date field to yesterday's date
Sub Form_OnLoad(Form)
    Form.SetFieldValue "Invoice Date", Date() - 1
End Sub 

This was my very first AutoStore script. It started with a problem, and with a little digging, the Invoice Date field in the Vendor Invoices AutoCapture form was set to yesterday's date.

Now, when I ran an end-to-end test, the format of the date with the slash (/) characters was something that needed to be further addressed. In the next article, I'll describe my second-ever AutoStore script where I reformat the date value to use for the file name.

Comments

Post a Comment

Popular posts from this blog

VBScript: Ensure Backslash Folder Path

Image
To preface what could be regarded as a very small thing, I am reminded of a common turn of phrase concerning the amount of perspiration that should be afforded to the "stuff" belonging to a particular size-category, and pretty sure there was a book written about that topic. Not to come across as disagreeable, but rather to invite a little balance based on my own general observations over time, an increase in cost with things such as time, money, even relationships, can be avoided when the "small stuff" is given the regard that it deserves. One of these tiny details has to do with string variables that reference folder paths within a script. There are times when it is important that a defined directory for a particular folder should and must always end with a backslash. As an example: folderPath = "C:\Example"   Of course, it really is not very difficult to manually enter that backslash into the path. folderPath = "C:\Example\" ...
Read more

AutoStore: Workflow Loop Example

Image
Regardless of the programming language, a looping-statement is a common declaration for iterating through collections of things, such as the items of an array, records selected from a database, elements within an XML file, or the files inside a directory. A recent AutoStore challenge was presented where a script was used to fetch data in a process that returned either one or many items. This was the easy part. However, each return record needed to be specific to an individual Route based on one of those items returned. Example Example1@email.com Example1/URL Example2@email.com Example2/URL Example3@email.com Example3/URL Although the captured document being processed would be common for all in the return, the recipient belonging to one of these unique records should not be aware of  nor  receive any of the information that would belong to a different recipient. Because an unknown number of return records would be expected, this presents a challenge due ...
Read more

AutoStore: Create a Custom RRT

Image
Have you ever needed to dynamically create a custom RRT for an AutoStore process? In my previous post AutoCapture Default Date , I described my very first AutoStore script where the value of an  Invoice Date  field in an AutoCapture Vendor Invoices  form was assigned a default value of the day prior from the current date. This Invoice Date  needs to be part of the file name, however its format contains slash (/) characters that cannot be part of the file name. So, we'll use the AutoStore VB/JScript process component to create a new RRT that's more friendly. To do so, we'll look at how to do the following: Bring the existing Invoice Date  value into the script Reformat the Invoice Date  to a Windows-friendly file name Output the reformatted Invoice Date to a new custom RRT After adding the VB/JScript process component in between the capture component and the Send to Folder route component of the configuration file, we open the AutoCap...
Read more