Conditional Field Rule

[[email protected]]

Hello,

I know there is a function avail, but cannot remember where. Even though I dislike field rules, they would work well for me in one application.

Essentially, I would like to do is place a conditional to execute a field rule that is tied to a particular form.

For example, if the viewed form is "Invoice Issue" then the conditional rule would subtract, etc.

Else if the viewed for us "Invoice Return" then the condition would just be an add back to stock

Has anyone used conditionals like this in Alpha9 ?

[Stan Mathews]

Re: Conditional Field Rule

You probably want to code one of the events for your forms (or an object thereon). Code would be specific to the form being viewed.

[[email protected]]

Re: Conditional Field Rule

You probably want to code one of the events for your forms (or an object thereon). Code would be specific to the form being viewed.

So that would mean that the field rule in this instance would be Qty_In_Sto that would be in the product table would relate to the form object, in this case "Qty" form the invoice issue. Let me try that. Thanks

[[email protected]]

Re: Conditional Field Rule

Stan,

I'm having problems in the field rule conditional, as it only allows for me to select the conditional values for that set. How would the format look for a conditional on the field rule for the Invoice Items Qty:

Would it be "formview(invoice_Issue)" ...the name of the current object that is loaded for the conditional to fire on?

[Stan Mathews]

Re: Conditional Field Rule

I'm lost as to what you mean.

I was thinking of coding, say the onchange event, for a form field object.

On the "Invoice Issue" form you would replace the current value in the Qty_In_Sto field with its current value - the form field value.

On the "Invoice Return" form you would replace the current value in the Qty_In_Sto field with its current value + the form field value.

No field rule involved.

If you already have a field rule in place and are trying to "conditionalize" it, we'll have to look at it a different way.

[[email protected]]

Re: Conditional Field Rule

Ok, then maybe that is where I should try.

I was trying the field rule directly from the Product table to execute conditionally. However, even passing a global to the table so it knows in the same table(Product) to add Qty or subtract Qty based upon that that field rule condition.


Unfortunately, the database does not seem to like a field rule tied to a global variable, so the conditional is bypassed and I just get a field rule error. I've attached the screen and the Field Rule...

[Stan Mathews]

Re: Conditional Field Rule

Tell us more about what you are doing.

Apparently you are working on some variation/modification of AlphaSports. You are adding a returns form that mirrors the invoice form functionality? If you manipulate the sign of the quantity of the returned item the current field rule will suffice (subtracting a minus is a plus).

[[email protected]]

Re: Conditional Field Rule

Thanks Stan, that is exactly what I'm attempting to do. In fact all I need to do is set now is the initial entry qty field value to a minus, and that should do it.

Simple enough..

Thanks,

Ryland