Update Request - Read-Only fields?

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)
Best Answer
-
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:
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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:
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi AndrΓ©e
Ah ok so if the column is locked then that should work. I will give that a try.
-
That did the job! Thanks a bunch.
-
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.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!