Calculation to compare a range of names in a calculated field to a Value list and return Values that are not included in the Calculated cell
I am, after some help with a calulation i wish to use.
Basically I have a calcuation field SHOWS::ScubaNames that uses the Getfield("exapmle") to return a range of names from multiple fields I then seperate these by carriage returns.
I then want to compare this field SHOWS::ScubaNames to a value list "Boat Scuba" and have another calculation field SHOWS::AvailableScuba show me what names are in the Value list that are not in the calulated field SHOWS::ScubaNames.
I hope this makes sense Basically I want to compare a range of names in on field to a value list and return the difference.
Can anyone point me in a direction to start??
Many thanks in advance
Do you have FileMaker Advanced? A custom, recursive function can do this. If you do not, you can still do it with a script or a recursive calculation field (Tricky to define but can be done).
If you still need this, let me know what you have to work with here.