1 Reply Latest reply on Jun 24, 2014 10:05 AM by philmodjunk

    creating two new fields



      creating two new fields


           How do you create a new field on the fly, e.g., if a condition is meet then let var 1 = something;, if not then var 2 = the something.  as if date is between july 1, 2014 and august 30, 2014 then sum tot = something; if false then fall tot = that something.  I would use an array or do loop in other programs but not sure how to handle this case in FM12

        • 1. Re: creating two new fields

               You do not create fields "on the fly" in FileMaker. Nor should you need to.

               Instead of creating fields, you create records--probably records in a related table as this is a relational database system--which can be a bit different from just using a programming language.