If you’ve been wondering how to add a computed field to an existing ACL table, you’re at the right place. I’ll take you through it step-by-step.
In ACL tip: What is a Computed Field?, I defined computed fields and provided 2 examples. I suggest you read that post before you dive into this one.
That post also explains expressions and functions, which you need to understand when creating computed fields. Both that post and this one are long ones, complete with graphics. You might want to print them both out first…
In this post, I’ll show you how to add the c_Region field that is described in the computed field post. It’s not as hard as it looks.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, Free, Free Download, How to..., Written by Skyyler
Tagged as acl, add, builder, column, computed, customer, c_region, edit, error, expression, f/x, field, function, green checkmark, How to..., length, number, red cross, selected fields, start, string, SUBSTR, table layout, tutorial, valid, verify
To make these posts easier to find (and link to), here’s a list of all the ACL posts on this blog in alphabetical order, and by most popular.
I’ll add other posts as they are written.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Excel, Free, How to..., Scripting (ACL), Technology, Top 10
Tagged as acerno, acl, AuditNet, bootcamp, builder, coderre, computed field, data analytics, error, expression, freeze, function, history, import, index, join, list, log, message, script, social networking, table layout, teach yourself, tips, Top 10, training, tricks, youtube