troubleshooting Question

How do I use Case() in a script in FMPA 11

Avatar of MarkJulie
MarkJulieFlag for United States of America asked on
FileMaker Pro
3 Comments1 Solution538 ViewsLast Modified:
I know how to write scripts using the left sidebar choices in Edit Script, so I am familiar with If(). I am less familiar with custom functions and the necessary parameters. I want this code to work (is it a custom function or a calculation in a script?):

If [ table1:field1 xor table2:field1 ]
Case (
IsEmpty ( table1:field1 ) ; Set Field [table1:field1 ; table2:field1] ;
IsEmpty ( table2:field1 ) ; Set Field [table2:field1 ; table1:field1] ;
Show Custom Dialogue
End If

Custom dialogue would prompt me to verify that either field is empty.
Conceptually easy but I don't know how to start.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros