AnsweredAssumed Answered

How can I script?

Question asked by jiang_aq on Mar 16, 2017
Latest reply on Mar 16, 2017 by dale_allyn

For example:

 

Company        PO#

Nike                P001

Nike                P001

Nike                P001

Adidas            P008

Adidas            P008

Puma              P034

Puma              P034

 

If I want to add one record, choose "Nike" as company name, PO# will be "P001" automatically

if choose "Puma", PO# will be "P034"

if add a new company, says "Apple", the po# will be "P035" incremented by 1 from "P034"

 

How can I achieve it in simple way?

Outcomes