Forum Discussion

JohnLJohnL's avatar
JohnLJohnL
Qrew Trainee
7 years ago

How do I use the Record ID# as part of a field on that record.

I want to fill a Part Number field using the Record ID# as part of that field (i.e. "P" & [Record ID#]). The issue is, how do I save the record, grab the Record ID# and then update the Part Number fie...
JohnLJohnL's avatar
JohnLJohnL
Qrew Trainee
7 years ago
It will not be used as a Key field but in some cases, the Part Number field will be edited to an existing Part Number. The user can enter an existing Part Number or if left blank, I want to create a Part Number that is a concatenation of the letter "P" and the Record ID#. If I did not need to have an option for an existing Part Number, a formula field would be fine.