https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/124405.aspxTue, 31 Aug 2021 15:09:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124405Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124405.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=124405You can use the approach outlined here: https://docs.microsoft.com/en-us/archive/blogs/infopath/conditional-default-valueshttps://www.infopathdev.com:443/forums/thread/124404.aspxTue, 31 Aug 2021 14:10:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124404DarthBrute0https://www.infopathdev.com:443/forums/thread/124404.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=124404I 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?