No double nominations within the same month rule

[Andyj00]

I have a record producer called 'rap it' that writes directley into 'x_mscrs_rap_it_x_rap_it_award' table.

In the record producer form there is field submitter_rc that auto populates with the current user, field created_time that auto populates with the current date, and nominee_rc which the submitter can choose.

These fields save in the rap it x table under fields submitter, created_time, and nominee.

Now I need the record producer form in the mobile portal where the user is submitting the information to pop up a message and erase the nominee_rc field if the submitter trys to choose the same nominee within the same month if they had previously nominated them.

For example, submitter_rc X cant choose nominee_rc Y in month B because they had done so already.

[Ademir Amaral1]

Hi @Andyj00 

I believe this question is duplicated with this other one, correct?

https://www.servicenow.com/community/mia-forum/cant-nominate-twice-within-the-same-month/td-p/283847...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.