B1 Validation Item trigger - Pass row number to Macro

Completed

Comments

6 comments

  • Official comment
    Avatar
    Rasmus Wulff Jensen

    This is already possible using the $[ROW] or $[CURRENT_ROW] keywords

    In general, you can see all the special keywords that you can use here: https://help.boyum-it.com/B1UP/special-keyword.html

     

     

  • Avatar
    Zendesk Bot
    Thank you for your request.
    The development team have now added it to our internal planning-system for evaluation.
    [Internal Id: 27441]
  • Avatar
    Oliver Syner

    Thanks Rasmus, 

     

    How do you use that in conjunction with a SET statement in a Macro?

     

    Thanks

    Oliver

  • Avatar
    Rasmus Wulff Jensen

    Not 100% sure I understand but if it is to be used as part of a dynamic syntax then you should use the .row dynamic syntax extension. You can learn more about that here: https://youtu.be/sQgN-qb-hvg

    If it is not what your talking about then please give me a bit more context on what you are trying to do here.

  • Avatar
    Oliver Syner

    Hi Rasmus, 

    Sorry, that was a bit vague of me. I have a B1 Validation that triggers when leaving the Item Code field. What I would like to do is then set the values of a couple of UDF's on the same row. I was trying to do this by calling a macro once the validation had been triggered that did a couple of calculations and then used the SET function to set the UDF's value.

    e.g. SET($[$38.U_CUSCODE.0.$[ROW]]|<Value to Set>);

     

    Thanks

    Oliver

  • Avatar
    Rasmus Wulff Jensen

    If you want to set them on same row then you do not need to do anything special

     

    Just

    SET($[$38.U_CUSCODE.0]|<Value to Set>);

     

    ...because if the event happens on line level the dynamic syntax will assume that everything you do on the same Matrix will happen on the same line. 

    It is only if the event happens on header level or you want to anything on non-current lines you need to do something special

Please sign in to leave a comment.