AnsweredAssumed Answered

How to get a calculation to enter text into a field

Question asked by johnrobins on Dec 9, 2018
Latest reply on Dec 10, 2018 by beverly

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.