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...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
This is probably possible with an Automaton, but I suggest the using a Part # override field.  It's just less complicated that way and zero chance of failure.

Then your Part# field will be a formula

IF(Trim([Part # Override]<>"", [Part # Override],
  "P" & ToText([Record ID#]))