AnsweredAssumed Answered

Script help?

Question asked by jiang_aq on Feb 20, 2017
Latest reply on Feb 20, 2017 by philmodjunk

I have a database, for example:

 

Company        Order#

A                     PM001

A                     PM002

B                     QCB00001

C                     DQK001

C                     DQK002

 

I wanna write a script for adding new order:

 

If new order's company = A, then Order#=PM003

If new order's company = B, then Order#=QCB00002

If new order's company = A, then Order#=DQK003

 

Thanks in advance!

Outcomes