Modify Field Value Based on Duplicate
I have a questions. I currently have a field that concatenates a few fields to create a name field for file exports. Is there a way to have it modify itself if the value in the field is already used? Let me illustrate. Say the main name of the record is "INT. Eastern Side of Grand Ballroom" for a show named Grand Manor. The file field concatenates that to a shorter file friendly name "GM_EasternSideBallroom_v01" where v01 is the version number. If somehow I had a value that duplicated that, would there be a way to flag that duplicate and possibly update the name to add a number or character to the name (for example "GM_EasternSideBallroom01_v01" so that there are no duplicate values?
Thanks, and let me know if you need any clarifications,