Sorry, new to Filemaker and I just can't seem to find the right way to handle this calculation.
What I need to happen is a field called "payment status" should be set to "paid" when a user enters a date into the field "Date Paid" on a particular record. I am using the calculation option in auto-enter data.
What I would like to write is:
If "Date Paid" is greater than zero (or If Date Paid contains a date)
Then set "Payment Status" to 'Paid'
I just can't seem to find the way to do this. Thanks in advance.