B1 Validation Item trigger - Pass row number to Macro
Completada
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
-
Comentario oficial
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
-
Thank you for your request.
The development team have now added it to our internal planning-system for evaluation.
[Internal Id: 27441] -
Thanks Rasmus,
How do you use that in conjunction with a SET statement in a Macro?
Thanks
Oliver
-
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.
-
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
-
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
-
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.?.
-
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) ...
-
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.
-
Hi Gopal
I'm afraid that is not something we have :-(
-
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.
-
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.
Iniciar sesión para dejar un comentario.
Comentarios
12 comentarios