How to move record to new database based on field
Sorry for the tons of noob questions!
Is it possible to move a record from one database to another, based on a field entry.
We have a "Status" field for our church.
We have a "No longer attending" status, and we would like to keep their information in another database, not the main one?
Is there a way to automatically move it to the other database once I mark it as "No Longer Attending"?
Maybe a better way to do it would have a button appear (via a portal which I do know how to do) that says "Move record", once I mark it "No longer attending".
How do I setup that button to move the record to a new database?
Thanks a ton!