Conditional Record Creation

[MarkEdward68051]

Please specify a sub-category when posting your topic.

• Get Answers for topics that you need help with

I have a simple app that is growing and one of my suppliers has introduced a charge that is conditional so i need to adapt.

If I sell product A or product B, charge C is added to the invoice but if I have A and B then C is only added once.

How can I create a conditional record workflow so that only one charge of C is added?

I can easily create a record but it will process it twice.

I need an IF A or B then C condition. Is this easy to do?

It’s very late and my brain stopped working.

Thanks in advance!

[PeterJurgen]

Since we don’t know how you structured your data, but generically, something like this:

Invoice Header table:

• Flag field

Invoice Line Item table:

If Line Item = A OR Line Item = B
    // Check the Parent.Flag field
    If Parent.flag = False
        Add Charge = $25
    Else
        Parent.flag = True
    End if
End if

But you’ll have to work it out in the context of your app.

[MarkEdward68051]

Hi Peter,

Thanks for the reply. That looks like code so I’m not sure how to apply that.

I have a table and the applicant selects a product (a or b) and adds it to the order.

It creates a new connected record for each product added.

The logic needs to be in the conditional record rules in submission. Is there an “IF” option there?

Otherwise the connected records are added to the total and there isn’t an obvious way to add only one charge.

I can do it using Make but that isn’t ideal.

[PeterJurgen]

Mark,

I don’t think you need code. I built a down and dirty sample very quickly. I was lazy so I only created rules for when Item = A. You will need to duplicate Rule 2 & 3 for Item B.

Note: The “B” in the titles has nothing to do with Item B. Just don’t want you to be confused by that.

Here it is by the pictures:

Hope this helps!