how to display duplicate record as an FYI

Question

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------------------------------

LauraThacker · Answer

You need to convert the TextList to Text by wrapping it in the To Text() function.

ToText(GetFieldValues(GetRecords("{6.EX.'"&[Manager name]&"'}"), 10))

------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------

Sign up

Login to the community