I’m not sure whether Shortcuts or Scriptable (or both?) could handle going into a spreadsheet like I need for this task, so I didn’t drop it in either sub-forum.
I’m a teacher, and when I receive an email from a student, I like to follow my school’s guidelines of CC’ing their parents. This is fine on my Mac, because I just pop open the spreadsheet and grab their parents’ emails. On my iPhone, this task feels much more arduous. Is there a way to use Shortcuts, Scriptable, or any other tool to take the “from” email address, search for it in a spreadsheet, and grab the other associated items in that row?
Does it have to be a spreadsheet, or would a text/CSV file suffice?
You could have an automation on your Mac that periodically exports a plainer version to somewhere (e.g. iCloud, Dropbox), that could then be read on iOS by either app you mention, and you could match using regex.
It would be possible to do this in Shortcuts.
Run the shortcut to get a list of students.
The shortcut then uses a dictionary to copy the emails to the clipboard.
It’s a bit more fiddly, but you can either program the dictionary into the Shortcut, or use a txt file lookup. I did something using this technique to pick a random student that I could share if it sounds useful.
Time spent getting familiar with regular expressions will pay dividends in the future allowing you to process text quickly, enabling you to do things you otherwise would have no idea how to approach, etc.
A few suggestions:
Read through a few tutorials written by different people.
Do use a tool to help you try stuff out. Search this forum and you’ll find plenty of recommendations.
Do not try and learn it all at once. RegEx is kind of a programming language in its own right and no one sits down and tries to learn an entire language in a single sitting. Learn enough to solve your first problem then come back later to learn more.