Using status flags

Discussion created by jurgmay on Mar 2, 2016
Latest reply on Mar 3, 2016 by jurgmay

Hi all,


If there are three possible states for a record - Expired, Active and Pending - what is the best way to record the status of that record?


At the moment I have three separate fields - 'isActive', 'isExpired' and 'isPending' - but only one of these will ever have a value of 1 at any given time and the others will be 0. Is it therefore better to have a 'status' field and denote 'Expired' as 0, 'Active' as 1, and 'Pending' as 2 for example?


Thanks in advance.