Standardization of names in a flat List

SAshish

Hi,

I have a flat list to maintain the certification records of the employees. Users will make use of that list in order to update the certification. If a user comes up with a new name then that name will get added to the list. But the problem now is that the names are not standardized and as a result we are getting same name certification twice or thrice. e.g., 1. SAP_Certified_Admin & 2. SAP Certified Admin(SPA). (This is just for the sake of example and not a real name)

How can this be made sure that if a user wants to add a new record for certification for SAP Certified Admin then he can only add one of the either names, also once added there should be an error message saying that the name already exist if any other user is trying to add the same record with another name.

jagadishdash

@SAshish

I understand the naming is different but it refers to the same certification. Do they have any standardization certifications? Like these are the 5 certification can only get but name might be different! If that is so we can give them a dropdown selection to select from the standardize certifications.

If it is not the case and can be any certification and name can be anything that we are not aware of so that means we can't handle it directly. One other thing you can think of, there's a text field for the name of certification and need a dropdown beside that to map the exact certification if it's not there in drop down then action to create that specific item in the list.

Let me know if anything else I missed to take care while giving the solution.

Thanks,

Jagadish

SAshish

@jagadishdash

Thank you for the response.

I will give more clarity with 2 points.

1.The situation is as your second case understanding. The certification name can be anything which we are not aware of.

2. There is a module's saved view for user's input where I have already given a text formatted field to add a new certification record, once added there is a dedicated action that pushes the new entry to the backend list. i.e., the certification list. &

Now my question is can we set up some logic where we can restrict the user's entry multiple time for single certification name?

jagadishdash

@SAshish

To your point, We can restrict the User's entry multiple time for single specific certification name by using IFO. But as I understand your problem with different naming refers to the same certification right! in that case it can be anything which we can't restrict.

Just an another thought there, If we can specify/standardize some word within the certification name that must be included or it's kind of identification. Then we can tag to the original name by considering the standardized/specified word.

Thanks,

SAshish

@jagadishdash

Thanks a lot for your input.

Regards,

Ashish

Unknown

This content has been removed.