‘{ENTITY DATA:Birthday Party:Paid Deposit}’ > 0
[=TN(’{ENTITY DATA:Birthday Party:Paid Deposit}’)] != ‘0’
[=TN(’{ENTITY DATA:Birthday Party:Paid Deposit}’)] > ‘0’
[=TN(’{ENTITY DATA:Birthday Party:Paid Deposit}’)] != ‘’
is never be True I guess because one side is text the other one is number.
‘{ENTITY DATA:Birthday Party:Paid Deposit}’ != ‘0’ This one should fired if NOT 0 in Paid Deposit field.
[=TN(’{ENTITY DATA:Birthday Party:Paid Deposit}’)] > 0 This one should fired if Paid Deposit field > 0.
Read this in the morning again, you may have typo somewhere.
In the rule all constraints (in every actions) will be evaluate all at the same time before any action taken.
When rule first executed, Entity Data still null because ?prompt was not executed yet. So, constraint evaluate with null data or whatever previous data store in the field.
This is 100%, you can’t set a value like entity data is 1sr action and have a constraint on 2nd action using that field as constraints are worked out at rule start… The constraint in 2nd rule will be based on the initial value before any actions are run.
As @sukasem said to do that you would need to split it a seccond rule, even just an execute auto command without value as the 2nd rules action constraints will then be evaluated at that point.
I have “create account transaction document” action
in the “amount” field:
big monstrous formula
[=F((TN('{REPORT ORDER DETAILS:([O.Total]/[OS.cou]).Sum:(OS.empl1={ENTITY NAME}) AND O.Total>0}')/100*TN('{REPORT ENTITY DETAILS:EC.Pay Rate percent of sale:(EN={ENTITY NAME})}'))+(TN('{REPORT ORDER DETAILS:([O.Total]/[OS.cou]).Sum:(OS.empl2={ENTITY NAME}) AND O.Total>0}')/100*TN('{REPORT ENTITY DETAILS:EC.Pay Rate percent of sale:(EN={ENTITY NAME})}'))+(TN('{REPORT ORDER DETAILS:([O.Total]/[OS.cou]).Sum:(OS.empl3={ENTITY NAME}) AND O.Total>0}')/100*TN('{REPORT ENTITY DETAILS:EC.Pay Rate percent of sale:(EN={ENTITY NAME})}'))+(TN('{REPORT ORDER DETAILS:([O.Total]/[OS.cou]).Sum:(OS.empl4={ENTITY NAME}) AND O.Total>0}')/100*TN('{REPORT ENTITY DETAILS:EC.Pay Rate percent of sale:(EN={ENTITY NAME})}'))-TN('{ACCOUNT TRANSACTION TOTAL:Нарахування зарплати:{ENTITY NAME}}'))]
and it creates a transaction without any problems that I need, but only if the result of the formula is not 0.
if 0 then it opens the standard transaction creation form (which is not needed)
and having chosen different options, I cannot find the correct syntax so that a transaction is created (or not)
exemple.
custom constraint: '[=F ... ]' != '' '[=F ... ]' > '0' [=F ... ] > 0 [=F ... ] != 0
not work
It would help to know the expression your comparing to.
If you quote either side of the != Comparason it should force string value. So generally we quote because we are looking at non numerical values like states or tags etc.
When it’s numerical it would depend on the output of the expressions as if it returned identical number in any format it would work but as string values 0 in format of 0 and 0.00 are not identical.
The TN(’’) wrap forces the contained expression to be evaluated as a numerical.number value and should also make a null value 0.
Using this is a must for large/smaller expressions as you can get a ==/=! Expression to work while treating numbers as stings however larger smaller 100% need numbers.
Without seeing for full expression it’s hard to say.
