Trying to auto-enter text

Discussion created by wesfolio on Jan 30, 2014
Latest reply on Jan 31, 2014 by wesfolio

I have an invoicing database.

When an invoice is created, a status field automatically enteres "open" from a value list. The value list has just 2 items: "open" or "paid"

When I get paid, I have a related database for earnings.

As I enter information about my payment, I'd like the status field to automatically be set to "paid" as soon as I type in a dollar amount in the "amountEarned" field.

I'm having a tough time figuring this out. Hope this isn't too simplistic for this forum.


many thanks,