Duplicate Entry Formula (Not a run-of-the-mill ask)
Hi, I'm trying to create a duplicate entry "Flag" across my database. The database I'm working with is a database of equipment at my company. Here's the scenario: once we log the equipment in the database, that equipment is tied its room (Room A).
However, in a year or two, there could be a project that comes through and changes out SOME or ALL of the equipment that was in the room (Room A).
The objective is to NOT add ADDITIONAL equipment information to Room A. The data entry team needs a visual indicator that if they enter new data into the database that matches parameters of Room A, they need to pause, find Room A, explore what equipment was already listed, and then overwrite/replace any of the equipment data for Room A.
Room A should ONLY have one set of data tied to it, no matter how many times the equipment may change.
The duplicate flag I need will simply be a flag that screams out: "hey, this room already exists in the database, be careful with what you enter!"
I think this formula will be difficult, because most of the row data for each column will be the same.
The one thing that could be a distinguishing factor is that the L3AV JOB NUMBER would be a 'NEW' number if a new equipment entry for a particular room is added/changed. Maybe I need multiple columns? Conditional formatting? I don't know...In all my ramblings, I'm not sure if I'm making sense. I could probably explain better on a Zoom/Teams call.