Jump to content

Case statements


This topic is 4326 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

Not sure I understand the problem, but:

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4326 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.