Show details from database


Does anyone know how to solve this?

I have database of telephone numbers and notes and second grid, where new telephone numbers are importing.

In the page that is linked to second grid I have implemented (through relations column and if-then else column) duplications detection function. If telephone number is in the database - there is text field “yes” a I would like to add button with action to display notes from the database, which has been recorded there from the beginning.

So I do not want to search it in the database manually, just show notes from database in the page if duplication is detected.

thanks for all your ideas


So you have a form to add new phone numbers and you don’t want duplicated numbers?

This is a bit tricky since there are a lot of ways to present the same phone number.

Say for a US number, 915-769-5946 and +19597695946.

Do you have a method in place to deal with that?