I have been a user for a few years love your product, it has been a gamechanger for me at work and life. My question is I have a contact list I use at work on a excel sheet, that I have to copy and paste from. Since the organization always has position changes. Is there a way to make a shortcut, that takes fragments of each row and column from the excel spreadsheet? That way it turns it into a shortcut to use outside of excel like on outlook. That way no matter what changes are made to the document it will always paste the most up to date contact info on the To: area when sending a email.
If you copy from the Excel sheet, then we can read the clipboard in Text Blaze and process it to find the first/latest cell containing an email. Here's a simpler example from Google Sheet: Pull Data From a Google Sheet
If you can describe the specific way in which you are manually extracting the To: email field, we can help build the snippet for you.
I can't use DataBlaze due to sensitive info as this is a corporate spreadsheet. Essentially this specific excel has a list of contacts broken down by location, area, the position they are in, the name and the email address for the person. These are all in separate columns, what I do is I mainly copy from the column where the emails are located and filter the spreadsheet to show a specific location I want to choose my emails from. I would copy the emails from that specific part of the spreadsheet that covers the location I want to notify. Then these emails are pasted into a new email reply in the To: area of Outlook. So I want to just shortcut all of that, and have TextBlaze pull data from that spreadsheet in Excel, and be able to organize separate shortcuts for each location.
I created this snippet for you. It's a bit complex because it does a lot of list related manipulation.
All you have to do is copy all of the data from your spreadsheet (cmd+c) including the headers.
The only thing that's hard coded is the column name "email". If your column name is different, you'll need to update the snippet (it's the last command).
{note}{raw_data=map(split({clipboard},"\n"),(x)->split(x,"\t"))}{headers=raw_data[1]}{data=slice(raw_data,2)}
{table=map(data,(x)->[headers[i]:x[i] for i in seq(1,count(headers))])}
Filter: {formmenu: values={=headers}; name=filter} = {formmenu: values={=unique(map(table,(x)->x[{=filter}]))}; name=filter_value}
Awesome Dan, let me see if I can make something out of this. I will also add that the corporate spreadsheet changes from time to time, with different individuals leaving and changing positions. So I would want my shortcut to draw from that spreadsheet, no matter how many changes we make to the document. That way were also pasting the up to date information, everytime we use a shortcut.
What do I do in this situation, is it something I can edit? Also what would be a way for it to only utilize data from just a source document in Excel mainly. Since we don't use Google Spreadsheets. Mainly in a way thats coded, so it pulls from the document without me having to copy the whole thing. That way when the doc updates, it reflects in the shortcut when a email is changed or moved?
I tried the snippet shared by Dan by copying data from Excel and it worked for me. Did you make any changes to the snippet? If yes, please share the snippet here along with an example spreadsheet if possible. Currently, we do not support loading data directly from Excel, but you can do it from a Google Sheets as explained in this post:
If you need further help on this, please let me know.
