how to display duplicate record as an FYI
Hello!
I am currently building a quickbase database and would like to display duplicate records when a user enters an employee ID in a lookup field. This display is just to alert the user that this employee already has multiple records in the database, nothing will be done about it. It is just an FYI. I came across formula query and tried to modify GetFieldValues(GetRecords("{6.EX.'"&[Manager name]&"'}"), 10) to fit my needs but the syntax error kept saying something like "expecting text but encountering textlist." I am not a coder and would really appreciate if someone could guide me on how to set this up. Thank you!!!
------------------------------
Nicole Bruun
------------------------------
I am currently building a quickbase database and would like to display duplicate records when a user enters an employee ID in a lookup field. This display is just to alert the user that this employee already has multiple records in the database, nothing will be done about it. It is just an FYI. I came across formula query and tried to modify GetFieldValues(GetRecords("{6.EX.'"&[Manager name]&"'}"), 10) to fit my needs but the syntax error kept saying something like "expecting text but encountering textlist." I am not a coder and would really appreciate if someone could guide me on how to set this up. Thank you!!!
------------------------------
Nicole Bruun
------------------------------
