How can I update the record in another table if condition is matched?

That doesn’t sound specific enough. If Record A from Table 1 has a checkmark, update which records in Table 2? Every record? Are your records linked together?

I will try to elaborate it more.

There are multiple entries in my Table 1. I also have a column named Approved. There are some entries which will be Approved (checkbox is checked with a tick mark if approved). So now, if the entry which I entered now, is Approved, the I want to print its primary key and some other columns automatically in Table 2.

So records in Table 2 are the same as Table 1, except they are approved? Why not just use one table and filter your views based on the checkbox field?

It is a work flow. Department 1 (Table 1) approves and pushes the info to Department 2 (Table 2). Department 2 inputs some other information and pushes to Department 3 (Table 3). So I want a separate table for each department.

So I haven’t used the concept of filter.

Typically, it is advised that “The same info” be kept in one place, one table. Moving the same record into several tables adds many points of potential human error, plus you’re eating up limited Automation Runs you get per month.

Using filtered views, however, is how Airtable is designed to work in instances like these. Table 1 would have a view called “Department A” and would have a filter applied where the checkbox is empty and would only have the fields Department A needs to fill in visible. Once the checkbox is filled in it would be filtered out of that view automatically. Conversely, Department B would get their own view that is filtered to where the checkbox is filled and would have the additional columns visible.

So can each view be set accessible to particular department? If so, then this could be the best.

@mshah72

In addition to all the excellent guidance that @Kamille_Parks gave you above, you might benefit greatly from taking my free Airtable training course, which covers the concept of views in depth: