AnsweredAssumed Answered

I need to use Conditional formatting on one field based on information from another.

Question asked by sbalschi on Mar 16, 2018
Latest reply on Mar 19, 2018 by sbalschi

This challenge is based on UPC entry.


I have one field that is a pull down menu of UPC types (UPC-A, UPC-SCS...).


Then I have a field that the values for that UPC are entered into.


I am wanting to make the UPC entry field change formatting so that if the UPC type field says "EAN-8" (O-411375-1), it won't accept input for "UPC-A" (0-68820-10626-5).


Another acceptable solution would be that incorrect input would turn red and bold, or some other indication that it was wrong.


Is this possible using FileMaker Pro 14?


Thank you