Skip to main content
M
marks9591820
Known Participant
February 5, 2019
Answered

Trying to auto-populate employee's crafts based on which employee is selected

  • February 5, 2019
  • 1 reply
  • 1424 views

I am trying to make it so when certain Employee's names are selected, their Craft automatically populates in a separate form field such as OP (for Operator) and LAB (for Laborer).

When I use this script in the Custom Calculation Script:

var v = this.getField("Name").valueAsString; 

if (v=="CHRIS CHAPMAN") event.value = "OP"; 

else event.value = ""; 

It works fine. But when I try to use this script for both "OP" and "LAB" with a list of employee's names like this:

var v = this.getField("Name").valueAsString; 

if (v=="MARTY J ADAMS", "ANDREW ALLEN", "JUDY ALOISI", "FRANK AMES", "JAIME ANDERSON", "RICK ANGLEMYER", "MARK APP", "KENNETH ARSANTO", "STEVEN ASCHIM", "ROSS ATKINS", "ANTHONY AVILLO", "COLBY BACON", "DAN BADERDEEN", "BRANDI BAKER", "DAVID BALDERSON", "ALBERT BALORA", "JOSEPH BARTKOVICH", "GLEN BARTOLOTTI", "MICHAEL BEHLING", "KURT BELANGER", "RANDALL BELLEVILLE", "TERRY BENGE", "JEREMY BICKFORD", "JIMMY BLOSL", "LINDA BOHNA", "RAYMOND BONILLA", "ROBERT BOYD", "JASON BOYES", "DENNIS BRADLEY", "TROY BRAUN", "DAVID BRITTAIN", "JOHN BROWN", "KEN BRUMLEY", "KURT CANNON", "SVEN CARLSSON", "RUSSEL CARVER", "JOSHUA CASCIO", "CHRIS CHAPMAN", "JAMES CLAIRE", "JOEL CLARK", "RANDALL CLARK", "DALE COBLENTZ", "WILLIAM COLBERG", "WILLIAM COLLINS", "DAVID COLLIS", "GARY COOPER", "ROBERT CORNELIUS", "STEVEN CRANDALL", "CHARLES CROTEAU", "CASEY DALE", "WALT DAVY", "FLORENTINO DAZA-MIRANDA", "DERICK DEESE", "JAIME DICEY", "TYLOR DICKMAN", "PAT DUNCAN", "WAYNE DURHAM", "DICK DWIRE", "THOMAS ELLIOT", "ALLISON ENTERS", "BARNEY ERDAHL", "NOLAN ESTILL", "MATTHEW FARRENS", "MICHAEL FENTON", "DEVIN FIELDSTAD", "FRANK FOOTE", "STEVEN FRITTS", "JOSEPH FUCHS", "ELISANDRO GARZA", "AUSTIN GEORGE", "JOHN-PAUL GERIMONTE", "LES GIERSDORF", "BRIAN GJERNES", "WILLIAM GRAFF", "ADAM GREENE", "MICHAEL GREGORY", "WALTER GRIMM", "BERNARD GRISWOLD", "RICHARD HACKNEY", "JOEL HAGGERTY", "DAVID HALL", "TREVOR HANSEN", "ROCCI HASH", "BILL HAUGHTON", "WILLIAM HAUGSNESS", "STEPHEN HIEHN") event.value = "OP"; 

else event.value = "";

AND

var v = this.getField("Name").valueAsString; 

if (v=="WILLIAM ABEL", "DEBORAH ADAMS", "MARTY R ADAMS", "DONALD ANDERSON", "MERRILL ANDERSON", "DAVID ARCHER", "TANA ARISMAN", "BRANDON ATWOOD", "MICHAEL AUSTIN", "WILLIAM BAKER", "RYAN BALAS", "CORBIN BARBOUR", "KARY BASDEN", "VIRGINIA BASHER", "ROBERT BAYLES", "BRIAN BEAN", "HAROLD BEHRE", "JAN BENNETT", "GENNAIVE BERRY", "ERIC BRANHAM", "KYLER BRAUN", "RAQUEL BRECKENRIDGE", "TRAVIS BREWER", "DEMETRIUS BROWN", "TYRONE BUFANDA", "DONALD BULLARD", "NICHOLAS BURGESS", "CHERELL BURTON", "DWIGHT BURTON", "MICHAEL BYRD", "CONNIE CALLOWAY", "SHADEN CANNON", "SUSAN CARSON", "KIERRA CARSON", "SCOTT CAUDEL", "COLEEN DOVE", "THOMAS ELLIOTT", "BOBBIE ELLIS", "MARCUS ENRIQUEZ", "ANTHONY ESPITIA", "JEREMY EVANSON", "HARVEY FERGUSON", "LORI FLORENCE", "EMMANUEL FLORES", "JONATHAN FLYGARE", "RYAN FORD", "ROBERT FULMER", "WAYNE GARDNER", "JANA GILLIHAN", "HENRY GILMORE", "BRYAN GOODRICH", "NATHAN GOODRICH", "ANTHONY GOTT", "RYAN CERNY", "LEN CHAMBERLAIN", "FINNISH CHEATHAM", "ANNA CHRISTENSEN", "DOUGLAS CHU", "MARION CLOSE", "LEONARDO COBB", "BRYAN COCHRAN", "ZACHARY COLSON", "MICHAEL CONWAY", "RANDAL CORDOVA", "SHARON COTTRELL", "JAMES CRABTREE", "JAMIN CRON", "RUBIN CURRY", "JAMES DAILEY", "RICHARD DECKER", "KEITH DEMPS", "ROSE DESART", "SHAWN DEVORE", "STEPHEN GRIMWOOD", "ETHAN GUNSAULS", "JEFF HAEDIKE", "TESFALDET HAILE", "MICHAEL HAMMER", "SOLOMON HARGROVE", "BILLIE HARPEL-MCQUEEN", "EFREM HEAPES", "GEORGE HEAVENS", "MICHAEL HICKERSON", "JOHN HIGGENBOTTOM", "JAMES HIGUERA", "CANDICE HILL", "MARK HITE", "AARON HOLT", "SHAUNA HUCKINS", "JESTEN HUNT", "MALIK ISHFAAQ", "ANDREW JACOBSEN", "ABDOULIE JALLOW", "DUANE JOHNSON", "DUANE JONES", "KATRINA JONES", "MATHEW KACZENSKI", "THOMAS KELL", "SHAWN KING", "MERLE KIVIJARVI", "TRAVIS KOA", "PAMELA KREBS", "ALBERTO KUCHLER", "SHARON LANE", "ERIC LEVERETT", "DOUGLAS LEWIS", "JOSE LEYVA", "GILBERT LINDSEY", "GREG LOTT") event.value = "LAB"; 

else event.value = ""; 

Any single employee I select will only populate as "LAB". Why is LAB dominate over OP? Can I not have so many names in one script/do I have to split the scripts up per individual employee?

This topic has been closed for replies.
Correct answer Bernd Alheit

Yes, I put them under the form field where I want LAB/OP to go. Under Custom Calculation Script


Use something like this:

var arr1 = ["MARTY J ADAMS", "ANDREW ALLEN", "JUDY ALOISI", ...];

var arr2 = [ ...];

var v = this.getField("Name").valueAsString;

if (arr1.indexOf(v)!=-1) event.value = "OP";

else if (arr2.indexOf(v) != -1) event.value = "LAB";

else event.value = "";

1 reply

try67
Community Expert
try67Community Expert
Community Expert
February 5, 2019

That's not how the logic operators work in JavaScript. You should use an array for the values, like this:

var arr = ["MARTY J ADAMS", "ANDREW ALLEN", "JUDY ALOISI", ...];

var v = this.getField("Name").valueAsString;

if (arr.indexOf(v)!=-1) event.value = "OP"; 

else event.value = "";

M
marks9591820Author
Known Participant
February 5, 2019

So I used what you gave me for both the "OP" and "LAB" employees and I'm still having the same problem with all of them saying either LAB or OP. It looks like if it has something to do with the order of the 2 scripts. If I have the script for the "OP" last, then they all show as OP. When I have the script for LAB listed last, then they all show as LAB.

Bernd Alheit
Community Expert
Bernd AlheitCommunity Expert
Community Expert
February 5, 2019

Does you use the 2 scripts in one form field?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices