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

Question

I want to fill a Part Number field using the Record ID# as part of that field (i.e. "P" &amp; [Record ID#]). The issue is, how do I save the record, grab the Record ID# and then update the Part Number field for that same record. I have tried using form rules but since there is no Record ID# until the record is saved, that did not work. I think that I likely need to use an automation but if I use "When a user adds a record", how do I run the automation on just the record that is saved?&nbsp;&nbsp;

quickbasecoachd · Answer

The Record ID# does not exist until the record is saved.&nbsp; Just make a formula field."P" &amp; [Record ID#]Are you tryIng to make this the Key field of the table?&nbsp; Is that your issue?

johnljohnl · Answer

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.

quickbasecoachd · Answer

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#]))

johnljohnl · Answer

That does seem like a more direct way to accomplish the goal. Thanks for the advice.&nbsp;

Forum Discussion

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

Related Content

Using Grid Edit to Edit Multiple Records at Once

Record Details

Button to Add Record via Pipeline, and refresh Record

Pipeline to Split Record into More Records Based on Field

Edit Multiple Records at Once with Grid Edit