If all you want to do is look up the client's first and last name based on the number, then I would stored the list in a simple text file. If you have that information already stored in a spreadsheet, then you can easily make a corresponding text file simply by copying the range of cells that contain the numbers and names and pasting into a text file (e.g., BBEdit). Then, do a search & replace to turn the tabs that separate the number, the first name, and the last name into a string of characters of your choice that will act as a delimiter. Something like &&& will work well. To search for tabs within BBEdit, for example, search for \t. Put &&& in the replace box, then choose replace all. After the text file is generated, you can create a Prompt for User Input action within KM. There is a very similar macro that I posted here:
1 Like