Function to take peice of text from merged text string ? - InfoPath Dev
in

InfoPath Dev

Function to take peice of text from merged text string ?

Last post 08-28-2015 02:05 PM by justinf10000. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 08-13-2015 07:51 AM

    Function to take peice of text from merged text string ?

     So basically this is how the form works.

    I have a multi-selection list box populated from a list.

    Whoever is picked from this list gets merged into another field with the function substring-after(eval(eval(Additional_Signoff, 'concat(., "; ")'), ".."), ";") 

    Everyone selected from this list will receive email notifications that they must sign off on the form.

    I need them to be able to do this simultaneously. I'd rather not use an approval workflow and keep all the signing off within the form itself.

    so that function above will return a value like  us/423424; us/324234; us/23424; us23424 . It can vary anywhere from 1-15+ people.

     

    I need a function that can pull the 1st ID from that string and stick it into Field1

    I need a function that can pull the 2nd ID from that string and stick it into Field2

    I need a function that can pull the 3rd ID from that string and stick it into Field3

    etc.

    I need them to be able to ONLY sign the field designated by their UserID and not the other fields.

    Any ideas? 

  • 08-28-2015 11:59 AM In reply to

    Re: Function to take peice of text from merged text string ?

     Hi there,

     I am attaching a sample form with a solution to your problem. Hope this helps!

     Kind Regards,

     Reema

    Reema Daga
    Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

    Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

     

  • 08-28-2015 12:12 PM In reply to

    Re: Function to take peice of text from merged text string ?

    Thank you !

  • 08-28-2015 01:26 PM In reply to

    Re: Function to take peice of text from merged text string ?

     Hey Reema actually we use InfoPath 2010 here at my work so I'm unable to open the file. Could you post the code in notepad or show me a 2010 version? Thanks!!

  • 08-28-2015 01:53 PM In reply to

    Re: Function to take peice of text from merged text string ?

    Attaching the 2010 version.

    Thanks

    Reema 

  • 08-28-2015 02:05 PM In reply to

    Re: Function to take peice of text from merged text string ?

     Thanks again :)

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