Forum Discussion
KaisaJanzen
7 years agoQrew Cadet
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-text
The 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 "useremail@xxx.xxx", the sender is actually "formmailer@xxx.com" 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 "formmailer@xxx.com".
The 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 "useremail@xxx.xxx", the sender is actually "formmailer@xxx.com" 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 "formmailer@xxx.com".