Adding values to a list field only when values are not equal

Need help
1

I have about 100 things in my database in a data type called ‘Holes’. Among other data fields, each thing contains three separate data fields as follows:

Value 1 Men
Value 2 Women
List Field Gender Values

What I’m trying to accomplish is this:

  1. compare Value 1 Men to Value 2 Women
  2. when the values are NOT equal, add Value 1 Men to list field Gender Values
  3. when the values are NOT equal, add Value 2 Women to list field Gender Values

FYI, I created a post in the category 'Questions" a few days ago, but I have received no replies. Here’s a link to that post:

In this original post I asked this question: When uploading a .csv file, must a list field contain more than one value separated by a comma?

2

This topic was automatically closed after 70 days. New replies are no longer allowed.