I have a Trade Show Database & we have new shows each year. I have been manually updating certain fields in a layout to capture the new years purchase/booth information & updating the scripts accordingly.
We currently have a 2019 layout, with certain fields (C19Intro Cost, C19StandardCost, etc, etc) to capture the information specific for 2019. At the end of the year I will need to revise this for 2020.
I attached a screens shot showing the 2019 layout with the C19 specific fields.
Is there a scripts that I could use to automatically do this?