AnsweredAssumed Answered

Numbering Portal Records

Question asked by jorcholski3 on Feb 25, 2018
Latest reply on Feb 25, 2018 by erolst

Here is one I've pulling my hair out on for some time now.

 

I have a quote database which auto seralizes the next quote, i.e., 1001, 1002, 1003 etc..  Because the main quote can be comprised of multiple sub quotes, I have a line items quote file (portal) which I also need to auto searlize.  Here's the catch, I need it to happen in this fashion:  When I generate a new sub quote in the line items portal it will carry over the main quote #, i.e., 1001.  However, I need it to come up as 10011 in the first portal row.  If I have a second sub quote it should come up as 10012, 3rd sub quote 10013 and so on.  The process should then repeat itself on the next quote - 1002, sub quotes would be 10021, 10022, 10023 and so on.

 

Does anyone know of a way to acccomplish this?  If so, it would be fantastic.

 

I've attached a sample quote file to help better understand what I'm trying to accomplish.

 

Thanks in advance for any help on this.

Attachments

Outcomes