Yes, definitely a formula field. Just use the current field for the users to enter the Title, and then create new formula text field with the formula
List(" - ", [Evidence Number], [Title])
I don't know how much existing data you have, but for your users who followed your instructions you were going to end up with a duplicate evidence number. If you wanted to, you could tell everybody starting tomorrow they don't have to enter the evidence number, and then you could use this formula instead
IF(Today() >= Date(2023,02,24), List(" - ", [Evidence Number], [Title]), [Title])
Thank you, it worked great!! I didn't think of creating a new field to hold both pieces, but I don't mind having 2 name fields, as the users won't care, and it gets us what we need, and we can adjust our reports to use the new field only.
Thank you again!!! :)
So you wouldn't show both field names on the form. You set the data entry field for the record title to be shown in add or edit mode on the form and then in view mode used to show the formula field where it's combined.
The form lets you control which fields are showing in which moods.
True, I could hide it in view mode, but most of the time when a record is open, users are editing, so its not an issue. But thanks for the tip!
