Hi all;
I have created a new app and within this app I am creating new fields. I have been doing this through a script, something new for me. Within the script I am creating new fields based on the data within the excel spreadsheet. I have been largely successful in this up until this problem.
In column B of my spreadsheet I have Customer and in column A of my spreadsheet I have Plant. What I am doing is creating a new field called "region" and multiple Plants can be within a region. That was easy enough to create the field for (if/then statement joined with or). My problem comes when I have to create a region that is both plant and customer numbers.
For a normal Region the script I have created is this:
If([Plant] = 'xxxx' or [Plant] = 'yyyy' or [Plant] = 'zzzz', 'Region A'. This works as planned returning Region A.
Where I cannot get the region to work is when I am combining Plant and Customer. Here is how I have written the script:
If([Plant] = 'xxxx' or [Plant] = 'yyyy' or [Plant] = 'zzzz' and [Customer] = 'aaaaa' or [Customer] = 'bbbbb', 'Region B'. This does not provide any data, or even the name of the region, when I load the data. I am trying just to pull the data for those customers within these plants.
Any help in what I am doing wrong would be appreciated.
