Set a field value IF/OR Based on two fields - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Set a field value IF/OR Based on two fields

Last post 08-31-2021 08:09 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-31-2021 07:10 AM

    Set a field value IF/OR Based on two fields

    I want to concat a few fields together to maintain a unique Title for sharepoint list items. However due to URL length restrictions I need to cut down the size of the title. In order to do that I want to identify two fields (FieldA and FieldB) to use. FIELDA will never not be empty. It is a required field. If FIELDA is not empty and FIELDB is empty then concat FIELDA. OR If FIELDA is not empty and FIELDB is not empty then concat FIELDB. Here is my current concat formula: concat(substring-before(Registration Cut-Off Date, "T"), " ", Office, " ", FIELDA, " ", FIELDB) Now I did figure out a way to do it using action rules and having a "helper field". But is there a way to do this using xpath all in the same formula/field?
  • 08-31-2021 08:09 AM In reply to

    Re: Set a field value IF/OR Based on two fields

    You can use the approach outlined here: https://docs.microsoft.com/en-us/archive/blogs/infopath/conditional-default-values
    Hilary Stoupa

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