2 Replies Latest reply on May 17, 2017 12:22 AM by Eugen Lupascu

    Composed name in PDM?

    Eugen Lupascu

      Good day to all


      I have this WIP folder data card:


      As you can see I have this field "Nume proiect" in PDM and I want from the lists items from right to generate the name "CA10A - GFL"


      List are:


      Tip de celula:

      Celula de afumare -            CA

      Celula de fierbere -             CF

      Celula de racire intensiva - CR


      Numar de carucioare:

      celula mica                     - 05

      1 carucior                       - 10

      2 carucioare                   - 20

      3 carucioare                   - 30

      4 carucioare                   - 40


      Tip de incalzire:

      Abur               -   A

      Electrica        -   E

      Gaz               -   G

      Diesel            -   D


      Tip de generator:

      Generator Rumegus  -                 GR

      Generator Chipsuri  -                    GC

      Generator Frictiune  -                    GF

      Generator Fum lichid  -                GFL

      Generator Tehnologie noua -         GI


      As you can see I want also that every list Item to generate an initial or initials that will compose the name "CA10A - GFL"

      Is there a way to achieve this?


      Thank you!

      Have a nice day!

        • Re: Composed name in PDM?
          Jeff Sweeney

          PDM Pro?

          I don't think you could accomplish this with static text, but you could do it if you used a read-only text box and an import formula:


          Leave your code values at the end of your drop list selections. Then look at the right x characters. So the final would look something like this...

          $RIGHT(Tip de celula,2)$RIGHT(Numar de carucioare,2)$RIGHT(Tip de incalzire,1)-$RIGHT(Tip de generator,3)


          (You'll need to pick the variables from the variable list, you cannot add these in exactly as shown.)