Updating 2 tables at once

[George_Copeland]

Hi,

I am creating 2 tables, one which is to be our internal database which shows all our products that we have (10 columns per product). The second table is a product table to be shared with customers and be accessible through an external link. The main difference will be the second table will have reduced information that is sensitive (6 columns per product).

I would like to update table 1 acting as the main internal database, which then feeds and automatically updates the 6 columns in the external table. Is this possible?

Secondly - i believe its possible to share 1 table within a base, while keeping other tables hidden, is that correct?

Many thanks for your help :slightly_smiling_face:

[kuovonne]

You can create a filtered view of a table and then share that filtered view. You will also need to make sure that you do not show all fields in expanded records.

I also recommend locking the view (if you have Pro subscription) so that the view isn’t accidentally changed to reveal more info than you want.