Dynamic View on multiple exernal user groups

SUNNY_BUNNY

Hi, I'm trying to setup dynamic view where multiple external user groups update data daily. Since data should be limited to each of the groups, how can I setup shared filter to limit only the applicable data that they need to update?

Paul Newcome

You would need to set up a shared filter on the sheet for each of the different vendors. Then you can create a Dynamic View for Vendor 1 and select their shared filter in the first part of the Dynamic View builder. Then you can create a copy of this Dynamic View, adjust the filter for Vendor 2, create a copy, adjust the filter for Vendor 3, so on and so forth.

Paul Newcome

Do you have a column in the source sheet that indicates which group?

SUNNY_BUNNY

Yes, I have a vendor column to identify.

Paul Newcome

You would need to set up a shared filter on the sheet for each of the different vendors. Then you can create a Dynamic View for Vendor 1 and select their shared filter in the first part of the Dynamic View builder. Then you can create a copy of this Dynamic View, adjust the filter for Vendor 2, create a copy, adjust the filter for Vendor 3, so on and so forth.