B1 Validation Item trigger - Pass row number to Macro

Completed

Oliver Syner

• July 18, 2019 14:56

Hello, 

Sorry if this already exists but I couldn't find anything on it. 

It would be convenient if when you trigger a validation at the Item level, you could pass the row number of the field you have just triggered into the Universal Function. This would be very handy in say the set function so you could set the value of another field on the same row.

e.g. when you Leave the "Item Code" field in row 3 it would trigger the B1 Validation which would then update a UDF of your choosing on the same row, row 3.

Many Thanks 

Oliver Syner

Vote

0

• Official comment

  

  Rasmus Jensen

  • July 19, 2019 18:30

  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

   

   
• 

  SSP Automation

  • July 18, 2019 14:58

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

  Oliver Syner

  • July 23, 2019 15:24

  Thanks Rasmus, 

   

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

   

  Thanks

  Oliver
• 

  Rasmus Jensen

  • July 23, 2019 16:59

  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.
• 

  Oliver Syner

  • July 24, 2019 07:59

  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
• 

  Rasmus Jensen

  • July 24, 2019 08:42

  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
• 

  Gopal Rathore

  • July 08, 2020 22:20

  Hello Rasmus,

  How can I select the current row in a line loop. I'm trying to auto select batches of all lines items in a picklist in a function button click.?.
• 

  Rasmus Jensen

  • July 09, 2020 06:36
  • Edited

  In a Line Loop, each loop will automatically use the currently looped line when using the normal $[$item.col.type] syntax (it reacts as if you were on the line) ... 
• 

  Gopal Rathore

  • July 09, 2020 09:19

  My problem is I want to auto-select the next row in sequence at the end of the allocation of batches for the current line item. We have syntax for FIRST, LAST, LAST-1., SELECTED but not PREVIOUS or NEXT. I'm looking for PREVIOUS and NEXT options.
• 

  Rasmus Jensen

  • July 09, 2020 09:57

  Hi Gopal

  I'm afraid that is not something we have :-(
• 

  Gopal Rathore

  • July 09, 2020 10:10

  On the Batch Selection screen, we have to select the next item row to Auto Select the batches and for this purpose, I was looking for a macro command of this kind. It will enhance macro functionality if you can introduce these two options also in the Item, column, row command.
• 

  Gopal Rathore

  • July 09, 2020 10:12

  For your information, I was trying to use DoubleClick(Item.RowHeader.0.NEXT) command. Since it didn't work, I have to simulate this functionality by writing a Dynamic Code Univeral function.

Please sign in to leave a comment.