Confused about using a ref column with date and the TODAY() Function

Ask for Help
1

I have two tables DATE and LOG.
I want the DATE field in my LOG table to auto fill todays date (which it does) but now i want use the reference date from DATE instead but still auto fill todays date on new records. I cant figure this part out. Ive tried formatting a bunch of different ways but it never accepts it as one of the referenced dates from DATE. i always have to hand pick the date:
see the example here:
https://docs.getgrist.com/nzhH61EKqme7/date-ref?utm_id=share-doc

2

to see it work, just enter something in the ENTRY column
and as a new record it should put in todays date correctly selected from the ref table.

3

I think you want the Date REF column to have this as the formula instead of just TODAY(): DATE.lookupOne(Date=TODAY())

4

awesome thanks! lookup i should have known.