I have a form with 3 columns
Date Item Cost
10/feb/2022 pc 100
I want to enter the data by using the “Form” button which brings up a popup to easily create a new record but I don’t want to manually enter today’s date each time (only the time and cost). TODAY() of course doesn’t work because on the next day all the previous dates will be changed to today’s day.
The highlighted Date column should be automatically filled with today’s date (11-feb-2002).