Field Update Automation

Field Update Automation

It would be nice if a rule could trigger a field update that is a little more sophisticate than just putting text into a box. I would like to update a field based on another field. For example, set Invoices.Subject = Invoices.Invoice Number.

Better yet, allow formulas - set Invoices.Subject = right(Invoices.Invoice Number, 6)

The field update function seems very limited as it is now.