Automatically create a record when a date expires
I have a table called "Jobs". This has a sub-table called "Workings". In the "jobs" table there is a "Date" field that I set manually. I would like to create a formula that, when the date specified in the "Date" field arrives, automatically creates a record in the "Workings" sub-table, associated with the parent table. I can't find solutions ...
You can try this in a button on the Jobs table:
let t := this if DateFieldName < today() then let newRec := (create Workings) newRec.(Jobs := t; DateExpired := t.DateFieldName) end
Of course you need to change the names of the tables and fields so they match yours.
Let me know if that works then we can add a loop so you can add it to the Trigger after Open of the table Jobs.