Upload Attachments
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?
Best Answers
-
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.
-
For more on copying rows see:
Answers
-
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
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
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.
-
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.
-
For more on copying rows see:
-
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
-
Awesome! Glad I could help you out! Thanks.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
