1b.app
Link copied -

Value highlighting

Good afternoon!
In the order, it is required to highlight the lines for which there is not enough goods in stock.
In the "Products by table" setting - what value should be written in the "Highlighting values" field so that all lines with a negative value (from -1 to -9999999999999999999) in the "Balance after shipment" additional field are highlighted?
https://prnt.sc/ufy6ik
Original question is available on version: ru

Answers:

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
No, you can't do that, you can't specify a condition, as you can see, you need to specify a specific correspondence, if the field value = is less than 0, then it is highlighted.
I propose to solve the problem like this:
1) Go to the procedures http://i.imgur.com/LrEDbbJ.png , add a new "Highlight products out of stock" http://i.imgur.com/UgUOjgR.png
2) Open edit actions http://i.imgur.com/ls3R4yi.png
3) Add action http://i.imgur.com/bQp997M.png
4) You should have 2 additional fields for the process product:
- 1st is your balance after shipment
- The second is, so to speak, a switch, which can only have 2 values (we will use numbers - this is how it should be), for example 1 and 2
5) We return to the procedure and configure this way http://i.imgur.com/mdRRE9r.png
6) And the last thing in the product table interface is set like this http://i.imgur.com/d8WkRk1.png
And a small nuance - the "Remainder Fact" field (or whatever you call it), which acts as a condition, must be in the table interface, otherwise the highlight will not work
12.09.2020, 12:26
Original comment available on version: ru

Thank you! Let's try. And so, to specify the value of the specified additional field not "less than 0", but, for example, "from ... and .... to" will not work? Is there such a magic formula?
12.09.2020, 16:07
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

Torbin Elena
Client wrote:
Thank you! Let's try. And so, to specify the value of the specified additional field not "less than 0", but, for example, "from ... and .... to" will not work? Is there such a magic formula?

I wrote above - in the specified functionality there is no such possibility, and otherwise you can’t highlight ...
The above describes a free solution to your problem, so try it, I don’t think you need to invent something else here.
12.09.2020, 16:17
Original comment available on version: ru

Thanks a lot! Everything is working!
Tell me more, please, how can I delete unnecessary procedures (accidentally two identical ones were created)? https://prnt.sc/ugs13l
14.09.2020, 06:26
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

Torbin Elena
Client wrote:
Thanks a lot! Everything works! Tell me more, please, how can I remove unnecessary procedures (by chance two identical ones were created)? https://prnt.sc/ugs13l

Open the procedure http://i.imgur.com/ls3R4yi.png (or click actions - it doesn't matter)
And do this manipulation http://i.imgur.com/dIiK7FH.png
14.09.2020, 11:11
Original comment available on version: ru


Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

Torbin Elena
Client wrote:
Thank you

Then mark that the issue is resolved)
14.09.2020, 16:58
Original comment available on version: ru

This is how and where, tell me, else (we are new)))?
14.09.2020, 17:21
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
You need to tick the correct answer http://joxi.ru/EA4ReqMUObYOvm
14.09.2020, 17:42
Original comment available on version: ru

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment