I have a field named "Checked out?" I would like this field to have a value of "Yes" if 2 other fields meet certain criteria. The criteria is, field "Checked out by" filled in and field "Returned Date" NOT filled in. This is what I see as a way to see if an item has been checked out or not. If anyone has a better way to do this, please let me know.

Thanks,

dcecil

Hi dcecil,

Set an Auto-Enter (Replace) value on your Checked Out field with this calculation:

If(not IsEmpty(CheckedOutBy) and not ReturnedDate ; "Yes" )

If your ReturnDate is NOT a date field, change it to:

If(not IsEmpty(CheckedOutBy) and not IsEmpty(ReturnedDate) ; "Yes" )

Auto-Enter (Replace) means from Options, the Auto-Enter tab and checkbox 'by Calculation'. Then unchecking right below that the 'Do not Replace Existing Value if any.' It can also just be a calculation.

LaRetta :wink2:

Ooops.

Apologies for the error in my second calculaton. Of course it should have been:

If(not IsEmpty(CheckedOutBy) and IsEmpty(ReturnedDate) ; "Yes" )

This is ONLY if ReturnedDate is type text. ReturnedDate SHOULD be date anway but I didn't want to leave garbage in any post. I was in too much of a hurry this morning ...

Thanks! That works great. This forum is fantastic!

dcecil