Formula in SharePoint List Tool - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Formula in SharePoint List Tool

Last post 01-08-2017 02:19 PM by Rommel Sta. Juana. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-05-2017 04:52 PM

    Formula in SharePoint List Tool

    Hi,

    Good day. I just want to inquire if the SharePoint List Tool (mapping tool) has the ability to map fields but trimming the value using a formula? For example, I have a field called "Order" which exceeds 255 characters so I want to trim the value like substring(fieldname, 1, 255) so that if the SubmitToSharePointList command is executed, the value on the "Order" field will still be save on the list because the number of characters had been trim to 255 characters.

    Thanks in advance.

    Regards,

    Rommel

  • 01-06-2017 08:53 AM In reply to

    Re: Formula in SharePoint List Tool

    Hi, Rommel - no, it does not. You can add another field to your data source (not displayed on your form) with a default value for this and map that instead.
    Hilary Stoupa

  • 01-08-2017 02:19 PM In reply to

    Re: Formula in SharePoint List Tool

     Thanks for the advice Hilary. I was planning to have the update to my form without adding new fields but in that case, I think I really need to add a new field. Thanks in advance.

     

    Regards,

    Rommel

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.