Batch Apply Sequential Numbering to Metadata Fields (Title / Copy Name / Caption) in Lightroom Classic

Hello Adobe Community,

I have been using Lightroom Classic for the past two years and have learned a great deal from it. I am currently working on a project where I need to batch edit metadata for a large number of photos (over 5,000 images).

Specifically, I want to apply a sequential numbering system to the following metadata fields:

• Title
• Copy Name
• Caption

My requirement is to assign values in a sequence format, for example:
Edit-1, Edit-2, Edit-3, and so on, similar to how file renaming sequences work in Lightroom.

The goal is to automatically generate and apply this sequence across all selected photos without manual input for each image.

I would like to know:

• Is it possible to create a sequential numbering system directly within Lightroom Classic for any of these metadata fields (Title, Copy Name, or Caption)?
• If not, is there any recommended workflow, plugin, or workaround that can achieve this efficiently?

Any guidance would be greatly appreciated, especially for handling this at scale.