I am sure there is an easy way to do this but I am still fairly new to Airtable.
I currently have a table that has six formula fields that give users information about their progress throughout the year based on criteria from other fields in the table. I have created a record review interface that allows each user read-only access to see all of their updated fields as well as the information from the formula fields. This is all working great except that multiple times throughout the year I need to go in and manually change which formula fields the users see.
For example, at the beginning of the year, formula field1 is in the interface which provides the inital progress that the users will see. On date1, I need to change field1 to formula field 2; on date2, I need to change field2 to formula field3, etc.
Is there a way to set up an automation to do this? I am not finding an automation that will allow me to replace fields in an interface, and I don't know enough about interfaces to see how to automate something like this. Any help would be greatly appreciated.
