Summarize Email field in Table Relationship

Question

Hi everyone, I have a table of contacts that I am using for a spec credit registration app. The nature of the app is it is a new app connected to my main ERP app called Team Elite. In this spec credit app I have a table called Spec Credit Program. It has a relation to the Companies table in my ERP app (Team Elite). In the Companies Table I added a new relationship to my contacts table so that I can select the contact I need to send the spec credit registration too.

The issue is I need to get the email addresses (field in the contacts app) UP to the Companies table and DOWN to the Spec Credit Program table in the other app. I cannot figure out how to create a combined text list of email addresses up on the companies table. How do I summarize email addresses in the relationship?

The app structure is:

Companies (Team Elite) < Contacts (Team Elite)
Companies (Team Elite) < Spec Credit Programs (Elite Spec)

Table Name (App) <=one to many relationship of Table Name (App)

------------------------------
Ivan Weiss
------------------------------

markshnier__you · Answer

npThe combined text summary field will summarize any text field. When you have a situation where you need to roll up words from a field that is not actually a text field just make a Mirror field like [email (text format)]
with the trivial formula of just[email]
you can just roll up that text field in the upper direction and of course in the down direction you can just use a look up. Note also that if you need to get a combined text summary field rolled up from a grandchild to a parent then up to a grandparent,&nbsp;the other field type that can be used in a combined text summary field is actually a combined text summary field.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

ivanweiss · Answer

Thanks Mark! &nbsp;Do I need to do anything to insert a comma or semi colon to have it work with emails in the future or can just make it a combined text summary?------------------------------Ivan Weiss------------------------------

markshnier__you · Answer

I need to understand what you intend to do with that list of emails and if these are users to just random emails.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

ivanweiss · Answer

Not users, I want to create a mailto button so that it will draft a new email with those emails repopulated------------------------------Ivan Weiss------------------------------

markshnier__you · Answer

I think that if you just convert the combined text field to textToText([my combined text field])you will end up with a semi colon delimited string which the mail to command will accept OK.&nbsp; Not sure if you will need the formula to remove spaces as well as the separator is actually&nbsp; space semi space.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Summarize Email field in Table Relationship

5 Replies

Related Content

Relationships functional question

email notification error

Tables and Relationships

Cross-app relationships

New email notification beta has arrived

Recent Discussions

%%rid%% has ceased working on mobile - be advised

Is it possible to manually trigger a connected table refresh using an API call?

Formula URL - Edit then Add

Logging causes dynamic rules to not work

Get Record IDs from Report Link