Automate

 View Only
  • 1.  Creating Materials on a loop?

    Posted 05-13-2021 14:06
    Hi everyone - I am working on a form in Evolve with an MM01 script and I would like to be able to create multiple materials (between 1-20) depending on what the originator determines.  I'm a little stumped on how to make this work. I have a working script that we have used prior to Evolve that will create multiple materials.  We now want to bring this into a form and I was thinking of using a repeating table so multiple materials can be added.  Do I need to set the script up with a loop in order to run the script?  When I think this through, I cannot figure out which field would be the Header. Or do I just create some arbitrary field and then every field after would be the "D" identifiers?

    ------------------------------
    Krista Zinna | Master Data Specialist
    Timken Company | 234-262-2008
    ------------------------------


  • 2.  RE: Creating Materials on a loop?

    Posted 05-13-2021 14:43
    Hi Krista -

    That concept is not considered a loop, it is just that the web service (the script within an Evolve form) needs to be repeating.  It would be a repeating table, but what is important is that when you import the MM01 script into your solution, you need to check the box to generate repeating section, so that the web service for MM01 can be repeated across multiple rows of that repeating table.


    So the concept with the H and the Ds does not apply here since it is not a loop. A loop is if you have a section of a script that is repeated within that single script. This is a situation where the whole script itself is repeated.

    Thank you!
    Jennifer

    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------



  • 3.  RE: Creating Materials on a loop?

    Posted 05-13-2021 15:05
    Thank you Jennifer!  I will try this.  I do have one more question if you don't mind, before I import my script.   Is there documentation somewhere on how to handle IF conditions that you have in your script when importing to Evolve?  I know that I have to create an additional field instead of my columns with an "IF_" in front of my field if I want to use a field that already exists in my script, but I can't seem to figure out what to do with that "IF_" field once I am in Evolve.  Here is a screenshot of my script.  If column F is populated with an actual EAN then I want the first part of the script to run, inserting the value in line 1 of the MEAN table and checking as the Main UPC.    Then it moves on and populates two more UPCs in lines 2 and 3.  But if column F is not populated I want to just skip rows 44-49.   When I convert this to XML I am creating an "IF_International_Article_Number but what do I actually do with that field once I'm designing my form?  I can't seem to find much documentation on this. 





    ------------------------------
    Krista Zinna | Master Data Specialist
    Timken Company | 234-262-2008
    ------------------------------



  • 4.  RE: Creating Materials on a loop?

    Posted 05-13-2021 15:52
    Hi Krista -

    So this is where there aren't necessarily right or wrong ways to any one thing, but just personal preference. So in the forms world, instead of an excel column being the basis of an IF condition, it can be a form field. So in your example, you're saying that there will be a field in your form called IF_International_Article_Number. Now the field absolutely does not need to be called IF_International_Article_Number.  It could just be called International_Article_Number, but it is one way for you to easily visually see that that field is the basis of an IF condition for the web service. So if this condition stays as is, it means that in your form, you need to have a field called IF_International_Article_Number (exact name) and it will look to the entry in that field to know whether to run that section of the web service or not. Now the real field in your form is probably going to be just plain International_Article_Number and not IF_International_Article_Number. So what you could do in that case is say that the default value of IF_International_Article_Number is the value of International_Article_Number.  I've included some snippets from the XML mapped script and the form (not your specific script or form, obviously!). 



    I hope this makes sense! Again, this is just one way of handling this, so I am merely giving you one option.

    Thanks!




    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------



  • 5.  RE: Creating Materials on a loop?

    Posted 05-13-2021 16:07
    Got it, thank you!  This makes perfect sense!  I appreciate your help!

    ------------------------------
    Krista Zinna | Master Data Specialist
    Timken Company |
    ------------------------------



  • 6.  RE: Creating Materials on a loop?

    Posted 08-31-2021 12:02
    Hallo Jennifer,

    ich habe ein Skript was in einem Formular wiederholt werden muss. Dieses Skript habe ich schon importiert. Wo kann ich prüfen, ob ich das Kontrollkästchen zum Generieren eines sich wiederholenden Abschnitts aktiviert? Und wie kann ich es nachträglich ändern, wenn ich es nicht aktiviert habe?

    Gruss Jana


    ------------------------------
    Jana Kuschmierz | Leitung VID
    Rigips AG | 0041628877034
    ------------------------------



  • 7.  RE: Creating Materials on a loop?

    Posted 08-31-2021 12:45
    I'm sorry, I don't speak German.

    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------



  • 8.  RE: Creating Materials on a loop?

    Posted 08-31-2021 15:26
    Ok, I used a translator and I think I understand what you are asking.

    If you have already imported the transaction script, you can't make it repeating after the fact. You will have to delete and then reimport it, or import it again as a separate version (change the name) and check that one as repeating.  

    Thank you


    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------



  • 9.  RE: Creating Materials on a loop?

    Posted 09-01-2021 01:06

    Hello Jennifer

     

    Thanks yes your understand right.

    O.k. then I reimport the script.

     

     

     

    Freundliche Grüsse

    Jana Kuschmierz
    Leiterin Verkaufsinnendienst

    Tel. direkt: +41 62 887 70 34
    Mobil: +41 79 127 07 74
    jana.kuschmierz@rigips.ch

    _____________________________

    Rigips AG
    Gewerbepark – Hintermättlistrasse 1 – 5506 Mägenwil – Schweiz
    Tel. +41 62 887 44 44 –
    www.rigips.ch

     

     

    Es gelten die Allgemeinen Geschäftsbedingungen der Rigips AG, abrufbar unter rigips.ch/agb.