4 Replies Latest reply on Jan 31, 2014 1:11 PM by wesfolio

    Trying to auto-enter text


      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,