Table A is a connected table synced with Gmail. Most of the email addresses are harvested from the body via the very helpful formula you authored here:
https://community.quickbase.com/quickbase/topics/formula-help-with-truncating-textThe report link plays very nicely with this formula field.
Some of our submissions do come directly from the sender, in which case using the from address as the key field would be terrific.
However, because a significant portion of our emails are forwarded via a third party, even though they are set up to display "
[email protected]", the sender is actually "
[email protected]" and QB syncs the sender or "from" field as the same. Using the formula you created, I can still glean the requisite email address, but I'm afraid the from address would contain several repeated instances of "
[email protected]".
