Script to modify field

[deanwall]

We have an FM database to record records of PAT Testing.

One of the layouts is a report that shows all of the tests carried out.

I have a field named "Restest date" and another field named "Retest Due"

I want to create a script that looks through the list of records, and adds 'DUE' the the Retest Due field on all records where the Retest Date is before todays date.

Is this possible?

[mr_vodka]

Enter Find Mode []

Set Field [ "<" & Get (CurrentDate) ]

Set Error Capture [On]

Perform Find []

If [ Get (FoundCount) ]

Replace Field Contents [ Retest Due; "Due" ]

End If

However, why not just have Retest Due be a calc instead?

[deanwall]

I thought that, but then I thought that it would only update the Retest Due field if the record was modified?

Would it auto update when the "Restest Date" had passed?

[mr_vodka]

Also if this is just for display, then you can use put a copy of the Restest date field on your layout, and format the date field as a Custom Date format of "Due" ( Select Field and then under the format menu --> Date )

You can then apply conditional formatting to the field where when Self ≥ Get ( CurrentDate ), you change the color of the text to white ( or whatever your background color is )

[deanwall]

OK, I'm going to go with making Retest Due a calc field.

Not too sure about the calculation though, There is no field with the current date in the table, would I have to create that?

Total newbie to Filemaker, calculations etc are a bit daunting at the moment :

[deanwall]

Got it : Thanks for your help!