Upload Attachments

flashock

Can i request user to upload their attachment and at the same time, prevent user from seeing other attachments on the same row uploaded by other users?

Mike Wilday

Have you considered using two separate sheets for this process?

Sheet one captures the web form data and copies the row and attachments to sheet two when a new row is added.

Sheet two would include the attachments from sheet one. You could do the approval process on sheet two and do a vlookup to the approval column to sheet one to indicate approval. Would something like that work? Attachments could be included in sheet 2 but sheet 1 would only include the attachments from the form and any newly added ones.

Mike Wilday

For more on copying rows see:

https://help.smartsheet.com/articles/770589-copying-a-row-to-another-sheet

Bassam Khalil

Hi @flashock

Hope you are fine, yes you can request the user to upload their attachment by designing automation to do that, but the sharing permission is per sheet not per row so you can't prevent a user from seeing other attachments on the same row uploaded by other users.

the following article will help you to understand the Sharing Permission in Smartsheet

https://help.smartsheet.com/articles/1155182-sharing-permission-levels

flashock

Hi Bassam

Thank you! i love the article, it provide a clear picture.

However, let me give a scenario on the flow.

1) there is a web form that allow user A (no access to sheet) to upload document for approval.

2) The form will go through approval process from user B and C (both are viewer access), they will upload a document (user B & C, do not want User A to see the attachment)

3) upon user B & C approval, Automation will request user A to upload a final document.

Issue here : if i set a Request update automation to user A for him to upload an attachment, I will have to select the "attachment", when user A receive "update form" he will be able to upload attachment and at the same time see other attachment that user B & C uploaded.

Mike Wilday

Have you considered using two separate sheets for this process?

Sheet one captures the web form data and copies the row and attachments to sheet two when a new row is added.

Sheet two would include the attachments from sheet one. You could do the approval process on sheet two and do a vlookup to the approval column to sheet one to indicate approval. Would something like that work? Attachments could be included in sheet 2 but sheet 1 would only include the attachments from the form and any newly added ones.

Mike Wilday

For more on copying rows see:

https://help.smartsheet.com/articles/770589-copying-a-row-to-another-sheet

flashock

https://community.smartsheet.com/discussion/comment/273243#Comment_273243

Hi Mike

I was thinking along this line but hit the wall. Copying from sheet 1 to 2 include attachment.

But you idea is brilliant! it works for me.

User A stay within sheet 1 with attachment they uploaded and eventually they will upload a final document.

User B & C stay with sheet 2 with initial attachments from user A and their uploads is not accessible by user A.

It works perfectly!

Thank you so much! Wishing you and yours health and prosperity in the new year.

Regards

Flashock

Mike Wilday

Awesome! Glad I could help you out! Thanks.