how to show only content in a multiple user sheet that was entered by the requester?

Sven Krohn

Lets say...

Tom, Alex, Paul are in the field, submitting content for columns A, B and C to me through a FORM. This content goes straight into my master SHEET which also has column D, E and F with confidential information.

Tom needs to make a change to his content after submitting the form.

How can he re-visit his content?

• He should not be able to see what Alex and Paul submitted (therefore: view content which was submitted by the user who is logged in only; view only if creator (I set up the form so that it will add the "creator" info to the sheet automatically already) matches with current user). Please note that users could always change, meaning maybe tomorrow it´s no longer Paul submitting content, but Peter.
• he should not be able to see the content of columns C, D and E (to be hidden)
• he needs to be able to edit his content in column A, B and C.

I was able to cover the last 2 bullet points with dynamic view, but don´t know how to resolve the first one.

Do-able? Who is up for this challenge?

Thanks!

Andrée Starå

@Sven Krohn

Happy to help!

You'd set it up in the Report (has any of) Current User.

Make sense?

Andrée Starå

Hi @Sven Krohn

I think you could use a similar method as in your other question.

• WorkApps or Dynamic View.

Would that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sven Krohn

but how would I define this criteria?

• He should not be able to see what Alex and Paul submitted (therefore: view content which was submitted by the user who is logged in only; view only if creator (I set up the form so that it will add the "creator" info to the sheet automatically already) matches with current user). Please note that users could always change, meaning maybe tomorrow it´s no longer Paul submitting content, but Peter.

Andrée Starå

@Sven Krohn

Not sure I follow!

Wouldn't the Current User feature work?

Sven Krohn

Hi Andrée,

where would I apply the "current user" feature?

Thanks!

Sven

Andrée Starå

@Sven Krohn

Happy to help!

You'd set it up in the Report (has any of) Current User.

Make sense?

Sven Krohn

it does! Thanks! I appreciate it!!

Andrée Starå

@Sven Krohn

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!