I wonder if it’s possible to use a external list of Catalog number to create these Record Sets?
For example, an external researcher has made a very precise list of around 50 specimens corresponding to his particular research needs. He sends me the list of catalogue numbers by email or by csv. From my side, can I call up this list in one way or another or do I create this record set by manually entering the 50 specimens (knowing that with a Query it is not possible to recreate the list of selected specimens)?
Hi @Marion
Not sure if I understand your question correctly, but you could create a query based on a precise list of 50 catalog numbers by using the in operator in the query builder, and then converting those query results to a record set as shown above. If the catalogue numbers were emailed in a csv (most likely in a column), you can convert them into the format Specify wants in excel using the following (replace A with the column the numbers are in). Then, copy and paste the resulting cell into the input box.[1]
=TEXTJOIN(",",TRUE,A:A)
Alternatively, if you are a fan of the command line, could do something similar with some shell commands ↩︎
That’s exactly it! Thanks a lot @markp !
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.