I am using the free trial of FM Pro to see if it meets my needs before I purchase. I have about 40 records created, but inside each record, I have a field that I want to be automatically populated. I don't want there to be any option to change it. I would like it so that whenever a 'new record' button is pushed and a new record opens up, I would like it automatically to put the value in as it will always be the same. I know in Excel/Numbers, you can fill down on the spreadsheet for that particular column, but I don't want to constantly have to do a 'fill' every time I update the database.
Appreciate any suggestions.