AnsweredAssumed Answered

How can I automatically make fields active or inactive for data entry ?

Question asked by ChristofBirkenmaier on May 11, 2013
Latest reply on May 11, 2013 by ChristofBirkenmaier

Title

How can I automatically make fields active or inactive for data entry ?

Post

     Hi everyone!

     I am new to FM and I cannot seem to find an answer to my question in any forum or knowledge base.

     The database I set up, is to manage different kinds of business transactions which each have different options for billing.
     But I don't want to create multiple tables and multiple layouts to enter the hours, travel time, etc.
     What I would like to do, is to have one layout which contains all the data fields reqiured by the 3 options and to have certain fields active (available) for data entry or inactive (unavailable) for data entry, depending on the kind of transaction.
     The type of transaction I want to select by a simple checkbox field at the top of the page.

     In principle, such settings can be made via the "Inspector" under "Data" - "Behaviour" - "Field Entry", but that would require me to create 3 different layouts.

     Does anyone have a solution for this?
     I have tried conditional formating and I have looked ats scripts, but couldn't find a solution.

     Thanks! Christof

Outcomes