Update Request - Read-Only fields?

Manu

Is there any way to send an update request, but only have certain fields editable?

The issue is that I need to send some contextual info on the update request, but some fields should *not* be changed.

If I only send the update request for the fields that need to be updated, the recipient will not have enough context.

And no I cannot share the entire sheet (external client, a lot of sensitive info on the sheet)

Find more posts tagged with

Accepted answers

Andrée Starå

Hi Manu,

If you lock the columns they can’t change the values. (depending on their permissions)

You can also add placeholder information to the message if that helps.

More info:

https://help.smartsheet.com/articles/2477796-dynamically-add-cell-data-in-the-subject-and-body-of-request-messages

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi Manu,

If you lock the columns they can’t change the values. (depending on their permissions)

You can also add placeholder information to the message if that helps.

More info:

https://help.smartsheet.com/articles/2477796-dynamically-add-cell-data-in-the-subject-and-body-of-request-messages

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Manu

Hi Andrée

Ah ok so if the column is locked then that should work. I will give that a try.

Manu

That did the job! Thanks a bunch.

Manu

Actually this only partly solves the problem because I still receive an updated confirmation email with a link to the sheet. And frankly I do not want the client to even receive a link to the sheet, even if I understand without permissions he will not be able to open that link.

Andrée Starå

Unfortunately, it's not possible at the moment to not receive it, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.