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

  • 25 November 2019
  • 6 replies
  • 14 views

Badge +1
  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


6 replies

Userlevel 3
Badge +9
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
Badge +1

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

Userlevel 3
Badge +9
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.
Badge +1

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

Badge +12

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

 

 

5650i8954D74E597D50EB.jpg

 

 

Testing using Run Now in build string:

 

5651i2B89BAFBA506F414.jpg

 

Userlevel 6
Badge +22

@dwinters sure you have that functionality.

5652i6BBB62F560598802.png

Reply