How do I can restrict or at least display same/ Similar Item name already added to database. as i have huge list of Item and recreation of Item is more likely possible.
Set item as Unique in Customize Form.
But what if we provide double space or bit differ in spelling like use of ‘ee’ in place of ‘i’??
Is there any way we can display matching name while type-ing item name so one can verify where name is there or not
No it wont work. The Item Name field does not search hence it wont be possible. I believe it has been kept such to make sure user dont select existing name. Your best bet is Excel with few rules. Else you can write a script if you know how to do it.
Once information is cleaned you can re-upload the file the file. Choose
Update Existing Record to ensure system writes to existing Item and not creating new.
Same items can be merged as well. Click Menu > Rename > check Merge and chose with which item this item should be merged.
Thanks for guiding me.