Skip to main content
Nintex Community Menu Bar
Solved

Set O365 form field to read-only after form submission


Forum|alt.badge.img+4

Is it possible to make a people-picker name field read-only after form has been submitted?  In our process, "Submit" sends the form into an approval workflow based on the reporting structure of the person in the "Name" field.  We've just learned that users can and do make name changes within the form, essentially negating the previous approval loop.

 

Any help would be greatly appreciated.  Thanks in advance!

Best answer by shaunlub

The settings for the People Picker should be similar to this:

The setting for the Calculated Value control would be similar to this:

Employee Name is the SharePoint People/Group column (so the People Picker is connected to this - saves input to this column).

The Calculated Value just pulls this in when the form is opened. If Recalculate Formula on View Mode is set to No, this will be empty when you open the form in display mode after submitting - so this needs to be Yes.

There is a learning curve for everything. Questions make learning curves shorter. Have fun.

View original
Translate

Forum|alt.badge.img+11
  • Scholar
  • June 16, 2017

Anne,

I would recommend making the People Picker control only active on the New Form.

In the Control Settings, under Apperance=> Visible, select Expression, and then enter isNewMode from the functions.

You could have a Label or Calculated Value control hidden behind the People Picker, which will display the contents of the column where the People Picker is saving the Name.

So - in New Mode, a name is selected; when submitted, that name is only visible in the un-editable Label or Calculated Value control.

Translate

Forum|alt.badge.img+4

Thank you, shaunlub, that makes sense.  Got the people picker to display only in New Mode but can't seem to get the employee name to populate from People Picker to Label or Calculated Value control.  Would you mind providing some direction?  Sorry to be needy, I'm still quite new-ish to Nintex.

Many thanks!   

Translate

Forum|alt.badge.img+5

Did you try break permission inheritance and update permissions in the workflow?

Translate

Forum|alt.badge.img+4

There are several instances of activity-level permissions settings in this workflow, I'm afraid that won't help in that case.  Thank you for the suggestion!  

Translate

Forum|alt.badge.img+11
  • Scholar
  • June 17, 2017

The settings for the People Picker should be similar to this:

The setting for the Calculated Value control would be similar to this:

Employee Name is the SharePoint People/Group column (so the People Picker is connected to this - saves input to this column).

The Calculated Value just pulls this in when the form is opened. If Recalculate Formula on View Mode is set to No, this will be empty when you open the form in display mode after submitting - so this needs to be Yes.

There is a learning curve for everything. Questions make learning curves shorter. Have fun.

Translate

Forum|alt.badge.img+4

That did the trick!  Thank you so much, shaunlub!!

Translate

Forum|alt.badge.img+4

Hey shuanlub.  We encountered a bit of a problem with the calculated value solution.  Because the control is not connected to a list column, if a request is opened after submission and another field edited, the traveler's name is removed from list view.  And because the Employee Name column is a people picker field, it is not available in the 'Connected to' options for the calculated value control (nor would it be for a label).  I've been unable to find a solution that both shows the traveler name on the form and does not remove it from the SP list.  We're supposed to roll this out next week.  Yikes.  Any suggestions?  Thanks so much!!

Translate

Forum|alt.badge.img+11
  • Scholar
  • June 23, 2017

The People Picker needs to be attached to a People/Group column to be able to user the SharePoint profile to access Display Name, Email Address, etc.

So, I would recommend using only the Calculated Value to pull in the logged-in user's display name and save that out to a text column. You would not be able to enter another name, though.

The settings would be:

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings