dwinters
Design Dabbler

how can i limit the amount of text being saved to a multi line text field

  1. Sharepoint nintex 2013
  2. An a lazy approval returns a long string of data
  3. This approver comments is then saved to a multiline list text field
  4. It there a way before saving the approver comments to a multi line field to cut off/limit the number of characters/words in the workflow before saving it to the multilne list text field?

Thank you

0 Kudos
Reply
6 Replies
v-tmasenko
Design Canvas Artiste

Re: how can i limit the amount of text being saved to a multi line text field

1) disconnect the control on the form
2) create a hidden control that is connected to the SharePoint column from the previous step
3) create a rule that uses the runtime function called subString(step1_control, 1, YourMaxLength) to assign to the control from step 2
0 Kudos
Reply
dwinters
Design Dabbler

Re: how can i limit the amount of text being saved to a multi line text field

thank you for this suggestion, unfortunately i am not using forms. Just workflow and sharepoint 2013.

0 Kudos
Reply
v-tmasenko
Design Canvas Artiste

Re: how can i limit the amount of text being saved to a multi line text field

In your Workflow, use "Extract Substring From Start of String" and reference the source string as the multi-line text string column in your List and Output into the same column.
0 Kudos
Reply
dwinters
Design Dabbler

Re: how can i limit the amount of text being saved to a multi line text field

i have 2013 nintex workflow, apparently i dont have that nintex action....darn...

0 Kudos
Reply
kunalpatel
Automation Master
Automation Master

Re: how can i limit the amount of text being saved to a multi line text field

@dwinters ......Did you try using build string's inner function Substring? FYI...it will also count the space between two words too....see below:

 

 

SC15.jpg

 

 

Testing using Run Now in build string:

 

SC16.jpg

 

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: how can i limit the amount of text being saved to a multi line text field

@dwinters sure you have that functionality.

sub.png

0 Kudos
Reply