Welcome to the community, Emmett! :grinning_face_with_big_eyes: This should be fairly easy to do using a formula that checks one or more date fields in your table. You won’t get the colored background of a single select field, but the contents will be driven dynamically by the date(s) in each record. If you describe your setup in more detail, we can provide more specific guidance on how to create the formula.
Welcome to the community, Emmett! :grinning_face_with_big_eyes: This should be fairly easy to do using a formula that checks one or more date fields in your table. You won’t get the colored background of a single select field, but the contents will be driven dynamically by the date(s) in each record. If you describe your setup in more detail, we can provide more specific guidance on how to create the formula.
Hi Justin,
I believe I’ve already implemented what you’re describing. I have created a dynamic “Reservation Status” field that uses a nested If statement to check if today’s date is:
*Greater than Check Out, it returns “past”
*Less than Check In, it returns “Future”
*If neither, then it must be “Current.”
IF(TODAY()>{Check Out},“Past”, IF(TODAY()<{Check In},“Future”, “Current”))
Is that the extent of what I can do in AirTable?
Hi Justin,
I believe I’ve already implemented what you’re describing. I have created a dynamic “Reservation Status” field that uses a nested If statement to check if today’s date is:
*Greater than Check Out, it returns “past”
*Less than Check In, it returns “Future”
*If neither, then it must be “Current.”
IF(TODAY()>{Check Out},“Past”, IF(TODAY()<{Check In},“Future”, “Current”))
Is that the extent of what I can do in AirTable?
Not necessarily. There are other functions that can be used to examine and process dates as well. If your current formula doesn’t quite give you what you want, how exactly would you like the setup to behave?
Not necessarily. There are other functions that can be used to examine and process dates as well. If your current formula doesn’t quite give you what you want, how exactly would you like the setup to behave?
I think the OP is looking to do something like change the field color based on status — which, as you know, can’t currently be done.
@Emmett_Klopp – at the moment, your choices are limited to record coloring, which tags the entire record, not field, with a colored flag, and the hack/workaround of using emoji coloring. Admittedly, neither are as satisfying or intuitive as conditional formatting on a cell level — but I have to assume its something that will eventually appear in Airtable…