How to create incremental number in forms for Purchase Order PO

%3CLINGO-SUB%20id%3D%22lingo-sub-285665%22%20slang%3D%22en-US%22%3EHow%20to%20create%20incremental%20number%20in%20forms%20for%20Purchase%20Order%20PO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285665%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20moving%20from%20G-suit%20to%20office%20365%2C%20and%20we%20are%20going%20to%20use%20forms.%20I%20have%20created%20a%20couple%20of%20forms%20and%20they%20work%20fine.%20Now%20I%20needed%20to%20add%20the%20incremental%20number%20when%26nbsp%3Ba%20staff%20creates%20a%20new%20PO%20a%20new%20number%20is%20generated%20Automatic%2C%20For%20example%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EName%3A%20Test%20Date%2013%2F11%2F2018%20Department%3A%20Sales%26nbsp%3B%20Item%20to%20purchase%3A%20PC%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BPO%20%3A%26nbsp%3B%3CBR%20%2F%3Eonce%20the%20user%20submits%20the%20form%20the%20PO%20is%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-285665%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286300%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20create%20incremental%20number%20in%20forms%20for%20Purchase%20Order%20PO%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286300%22%20slang%3D%22en-US%22%3E%3CP%3EGues%20what%20I%20found%20the%20answer%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EUsing%20this%20formula%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIF(%3C%2FSPAN%3E%3CSPAN%3EA5%3C%2FSPAN%3E%3CSPAN%3E%26lt%3B%26gt%3B%22%22%2C%3C%2FSPAN%3E%3CSPAN%3EJ4%3C%2FSPAN%3E%3CSPAN%3E%2B1%2C%22%22)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, 

 

We are moving from G-suit to office 365, and we are going to use forms. I have created a couple of forms and they work fine. Now I needed to add the incremental number when a staff creates a new PO a new number is generated Automatic, For example: 

 

Name: Test Date 13/11/2018 Department: Sales  Item to purchase: PC       PO : 
once the user submits the form the PO is created.

 

1 Reply

Gues what I found the answer,


Using this formula 

 

=IF(A5<>"",J4+1,"")