Case statements

[tokkajy]

I am using the bps_SE templates and have a challenge on the service order page.

I am trying to populate text in the notes field based on the customer invoiced. How can I use cas statements to populate certain text based on the customer that gets billed?

case "abc company" "put this in the notes field"

case "xyz customer" "put that in the field instead"

any ideas?

[Fitch]

Not sure I understand the problem, but:

Case( company = "abc" ; "this" ; company = "xyz" ; "that" ) // etc.

[comment]

I am trying to populate text in the notes field based on the customer invoiced.

I would have a default note field in the Customers table, and do a lookup from there. This is assuming the note can be modified from order to order - otherwise it can be just placed on the order layout.

[Fitch]

I would have a default note field in the Customers table, and do a lookup from there.

Ah, I see what tokkajy was asking now. Yes, that's much better than hard-coding it into a calculation or script.