How can I change a field's value after an expiration date?

[unclegeo]

Heres the application; I broker used gear on consignment. Filemaker lets me manage the list of items for sale.

Listings for items (each item is a record) are assigned a "status" field value of "For Sale" when we list it or "Off List" after we sell it. Normally we manually set this "status" field with a pull down menu.

But, I also list gear for other brokers and this stuff goes so fast it is impossible to call everyone and verify the current status ("For Sale" or "Off List&quotan dupdate the database.

I'd like to make a timer of some sort so that I could automatically have the "status" field for these kind of items set to the value "Off List" after say 60 days.

I'd greatly appreciate any ideas. Thanks!

 

[RobQME]

Hi

One way is to create a field based on the last modification date (assuming that you won't be changing each record unless you manually set them to Off List) - you could then use a loop to run on startup or when triggered to check each of records
eg
Show All Records
Go to Record First
Loop
If (sale_status = "off list&quot
Go to next record (exyt after last)
Else
If (modification_date_field - Today > 60)
Set Field (sale_status, "off list&quot
Go to next record (exit after last)
End Loop

You might want soemthing in the second part of the loop to differentiate between records that are your own products and those that you want to use your 60 day test for.

Hope this helps

Rob