Assigning Numeric Values to Words

Discussion created by MichaelHart on Feb 13, 2016
Latest reply on Feb 17, 2016 by MichaelHart

Using FMP-13, I want to assign numeric values (either 0 or 1) to a list of words in value-list so I can calculate if an inventory item is available or not AND determine why it is not available. The value-list of the assigned numeric-values would be: "Sold" = 0, "NFS" = 0, "Consigned" = 0, "Available" = 1.

I've been accomplishing this by just using a "0" or "1" as the input values and doing a simple "If (test ; resultOne ; resultTwo) but would like to use a value-list to be more descriptive than just a simple "yes" or 'no" but still be able to calculate a "yes" or "no" summation based on all the words in the value-list. I hope that makes sense.