Restrict duplicate phone numbers

[mahalakshme]

Need:

• Restrict duplicate phone numbers to 5. If two farmers have the same name, then don't count them as duplicates
• This card includes some minor implementation work as well, to make sure end-to-end it works efficiently.

Suggested technical approach:

• Add a custom query that returns the no of individuals with same phone number but different first name and last name than the ones in the request. For farmers with same name and same mobile numbers should not be counted as 2.
• Make validation rule async(for both mobile app and DEA) - refer this . Suggest doing in form element or form element group rule unless we are sure it will cause performance issues.
• From the mobile app validation rule, call /executeQuery api and show the error stating 'Number of times this mobile number can be used has exceeded than the allowed limit' if the number of duplicate mobile numbers with different names exceed 5. This error message should be translatable.
• If API call doesn't go through, then show the error 'Switch on your internet connection.' This error message should be translatable.

AC:

Implement the above need by identifying a suitable technical approach.

[petmongrels]

For implementation team to use. tested with this.

https://gist.github.com/petmongrels/6bd7c4bae474a0b820063eab1b4fa7ea

[petmongrels]

Validation rule is not supported in the data entry app currently.