How to automatically Copy records from Table1 to Table2 after applying filter on Table1.

Murali, If you want to have this job run on a scheduled basis, you can create a scheduled automation. Otherwise, if you want it to run when something happens, such as a new record is added, or a record is modified or deleted and so on, create an appropriate automation. Then for actions, select "Copy Records" and specify the source table as table1 and apply the filter on table1. Then specify the target table as table2 and make sure you map the fields in table2 to the source fields in table1.

The beauty of quickbase as told in the words of Kirk Trachy is: "If you can say a requirement in a sentence, you can do it in quickbase."

Hope that helps.