Auto Enter Date

[mediteer 0]

Simple question--I want a specific field to 'auto enter' the current date every time the file is opened. Can someone help me.

[sbg2 0]

Create a script to Set Field[g_MyCurrentDateField; Get(CurrentDate)]. A global field sounds like the way to go here.

Then set the script to run when the file is opened.

File>File Options

Open/Close tab

Check the Perform Script box under "when opening this file" and then select your new script.

[mediteer 0]

thanks very much, that works for the current record being viewed at the time the entire file is opened, however all the other records in the file have not been auto-updated. Any way to do this so all the records in the file are updated also.

[Inky Phil 1]

As sbg2 suggested, make the field a global. That way the same value will apply to all records.

How do you make it a global?

define database>fields>select field>options>storage

Phil

[mediteer 0]

Incredible!! Both of you are amazing. Thanks so much!!