DataMesh & Locked columns

Susan Vieira

Hello,

Will Data Mesh still import appropriately if the some columns in the target sheet are now locked?

Genevieve P.

Hi@Susan Vieira

Yes, DataMesh will still update cells even if the column is locked. The workflow essentially has "Admin" access on the sheet so it can override the lock.

Cheers,

Genevieve

Genevieve P.

Hi@Susan Vieira

Yes, DataMesh will still update cells even if the column is locked. The workflow essentially has "Admin" access on the sheet so it can override the lock.

Cheers,

Genevieve

Susan Vieira

Thanks!

Genevieve P.

@Susan Vieira

I've just double checked and I realized I tested this on a sheet where I had Admin access and I was the builder of the Workflow.

I believe if the user who built the workflow only has Editor access on the sheet, then no, you wouldn't be able to update the column. It will be based on that user's permission, does that make sense?

Susan Vieira

Yes it does. In my case, the User is the Owner so we should be all set. Thank You!