basic lookup

[giovanni]

Hi,

 

This is basic but I don't seem to find it. I must be using the wrong search terms! 

 

I have a table with 2 columns: name->value and I would like to build a workflow where the user enters the name and the workflow looks up the possible values.

 

for example: for a table like this:

 

1 burrito -> mexican

2 burrata->italian

3 taco->mexican

 

if the user enters

**Keyword** bur,

the workflow will show the top 2 values, and upon enter on the first one, will copy "mexican" to the clipboard.

 

Can you guys point me to a workflow that does that or something similar? Sorry if this is too trivial.

 

Thanks!!

Giovanni

 

 

 

[jdfwarrior]

Hi,

 

This is basic but I don't seem to find it. I must be using the wrong search terms! 

 

I have a table with 2 columns: name->value and I would like to build a workflow where the user enters the name and the workflow looks up the possible values.

 

for example: for a table like this:

 

1 burrito -> mexican

2 burrata->italian

3 taco->mexican

 

if the user enters

**Keyword** bur,

the workflow will show the top 2 values, and upon enter on the first one, will copy "mexican" to the clipboard.

 

Can you guys point me to a workflow that does that or something similar? Sorry if this is too trivial.

 

Thanks!!

Giovanni

 

Which part specifically are you having issues with? All? I don't know of one right off that does such a thing (searches a table) to provide as an example. How is the data formatted? By table, are you meaning that it is an Excel sheet? CSV, TSV, JSON or something else would be easier to parse than an excel sheet. You could also store the data in an sqlite database. That would make the searching pretty easy,

[giovanni]

Which part specifically are you having issues with? All? I don't know of one right off that does such a thing (searches a table) to provide as an example. How is the data formatted? By table, are you meaning that it is an Excel sheet? CSV, TSV, JSON or something else would be easier to parse than an excel sheet. You could also store the data in an sqlite database. That would make the searching pretty easy,

Thank you for getting back to me! I totally missed your reply. 

I solved this by modifying the great AreaCode workflow (https://github.com/dklem/Alfred2-AreaCode).

My table is in a text file and the two columns are separated by ':'. Looking for a key will return a list of matching keys, and upon enter the value is copied to clipboard. Very handy!

Thanks

Giovanni