Question about case statement if it exist in FileMaker Pro Advanced and automation

Discussion created by cdurham on Feb 23, 2012
Latest reply on Feb 23, 2012 by RayCologon

Hello all,


I need to know if 1. It is possible to code a wildcard statement in FileMaker Pro. 2. Write a case statement that supports 3 or more conditions (for those of you who write sql code you will know what I am talking about) I have inherited code that I am not familiar with. This (Sales) process has been around since 2004 and I joined this company in the summer of 2011. I never heard of Filemaker until 2011 so please bear with me. I have attached the actual table that I am using and needing the case statement for. I also need to know that once a row is updated with the case statement, how do I write a loop for it to automate all of the process. anyones help would be appreciated.