none
Rule to Set a Field Value

    Question

  • I'm trying to set a rule based condition to a text field and having issues.

    First,Initial,Last

    If Initial is empty, Full Name = First Last

    Condition: Initial Is Blank

    Rule Type: Action

    Run These Actions: Show the Value of Field or Formula

    fx: concat(First, " ",Last)

    Nothing shows up in Full Name (the rule is applied to this field) if I have a letter in Inital or not.

    InfoPath 2013


    • Edited by harringg Friday, August 08, 2014 4:35 AM
    Friday, August 08, 2014 4:35 AM

Answers

  • Hi

    Here is the solution that works for me, Select the Full name field right click and choose default value( fx)

    Click on insert function and choose contact

    concat(txtboxFirst, " ", txboxInitial, " ", txtboxLast)

    in this condition if your Initial is blank it will automatically will not appear and your full name will concat First + Last

    if you still face any other validation issue, let us know we would be happy to help.


    Krishana Kumar http://www.mosstechnet-kk.com

    • Marked as answer by harringg Wednesday, August 13, 2014 1:06 AM
    Tuesday, August 12, 2014 5:55 PM

All replies

  • Hi Harringg,

    Are you adding these rules and conditions on the InfoPath 2013 form itself?

    I have run into scenarios like these where the form hasn't behaved as I'd like and hence I use the SharePoint designer 2013 workflow.

    Take a look at one of my TechNet articles which talks about how I have used both Infopath designer and SharePoint designer to give me the actions and rules I needed.

    http://social.technet.microsoft.com/wiki/contents/articles/19797.sharepoint-2013-a-no-code-solution-to-build-a-change-management-request.aspx

    Hope this helps!


    Daniel Christian (MCTS)

    Friday, August 08, 2014 12:49 PM
  • Thanks.  I just have InfoPath Designer and am creating forms for local use.  I'll keep looking for a solution.

    Monday, August 11, 2014 1:31 AM
  • Hi

    you need to set your rules out differently

    i.e.

    if First is not empty then set full name to be First + Last

    if Initial is not empty then set full name to be Initial + Last


    Regards

    Sergio Giusti Sergio Blogs
    Linked In Profile

    Whenever you see a reply you think is helpful, click Vote As Helpful.
    Whenever you see a reply you think is the answer to the question, click Mark As Answer.

    Monday, August 11, 2014 11:45 AM
  • Hi

    Here is the solution that works for me, Select the Full name field right click and choose default value( fx)

    Click on insert function and choose contact

    concat(txtboxFirst, " ", txboxInitial, " ", txtboxLast)

    in this condition if your Initial is blank it will automatically will not appear and your full name will concat First + Last

    if you still face any other validation issue, let us know we would be happy to help.


    Krishana Kumar http://www.mosstechnet-kk.com

    • Marked as answer by harringg Wednesday, August 13, 2014 1:06 AM
    Tuesday, August 12, 2014 5:55 PM