Changes in Execute 21.1.214

With Execute’s move to smaller and more frequent releases, keeping tabs on What’s New could be a bit overwhelming. In this release, we’ve changed things a bit.

When new versions of Execute are available, administrators with the “IT Monitor” administrator privilege will continue to see a dashboard widget notifying them of the availability of a new version. This panel now includes a “What’s New” link which shows a summarized list of all new changes (potentially summarizing multiple releases) released since the version currently running in that environment. If you are a few versions behind on your upgrades, this gives one place to look for all of the new bug fixes and exciting enhancements you’ll receive when you upgrade your environment.

Similarly, the “About” screen will also show information about the next available version and a link to the same summarized release notes.

Similarly, under the help menu, release notes have also been split into two options:

1. “Release Notes (Available Version)” is a link to the summarized release notes showing everything new and exciting when you upgrade your environment
2. “Release Notes (Current Version)” is a link to the release notes for the version of Execute currently running in the environment

The new calculated fields in Execute have been phenomenally successful and many of you are finding all sorts of great uses for them. In this release, we’ve added a few new functions based on your feedback.

InList

Sometimes you need to check if a value is one of a big list of options. While you can do this with the if function, it’s not pleasant. Trying to get the brackets right in an expression like if([CUSTOM/AFE_TYPE/VALUE]=="Drilling",true,[CUSTOM/AFE_TYPE/VALUE]=="Complete",true,[CUSTOM/AFE_TYPE/VALUE]=="Drill & Complete",true,false))) is enough to break anybody’s brain.

So… We’ve added the InList function which returns whether a value is found in a list of values.

i.e. the following will return true when the AFE Type is one of “Drilling”, “Completion” or “Drill & Complete”

inlist([CUSTOM/AFE_TYPE/VALUE],"Drilling","Completion","Drill & Complete")

Usually, inList would be used in condition part of if statement:

if(inlist([CUSTOM/AFE_TYPE/VALUE],"Drilling","Completion","Drill & Complete"),"drilling & completion AFE","not a D&C AFE")

FirstNonEmpty

Sometimes it’s helpful to return the first non-empty value from a bunch of text fields (such as when showing the “best available identifier for an AFE”). The new FirstNonEmpty function helps with that!

i.e. Here is a function that returns the description (if one), or the internal justification (if one), or a constant string.

FirstNonEmpty([DESCRIPTION],[INTERNAL_JUSTIFICATION],"This AFE has no name")

Document Link Counting

Another common ask has been around getting a count of linked documents, so we’ve introduced DocumentLinkChildrenCount and DocumentLinkCount to help with that.

i.e. Find the number of child wells for a site.

DoumentLinkChildCount("WELL")

i.e. Find the count of AFEs linked to a Job (child, associated, parent… all are counted).

DoumentLinkCount("AFE")