Forum Discussion

EriksonTsang's avatar
EriksonTsang
Qrew Cadet
6 years ago

notification to group from child table

I'd like to create notification and reminder email to certain group of people based on a trigger on the records from my "Project" table.
Within the project table record, I have a related field called "Assigned Company".. Where I have link the "Company" table as a parent table of the Project. Then, under the "Company table", I have a child table called "People", where i list all the people for the company and I have the email information tagged in the individual "people" record.

I'd like to setup a notification email from the project table to send email to the people belong to the company tagged to the project. How should I set that up in QuickBase?

thanks

3 Replies

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    I suggest converting those child records to fields on the Parent Company Record. Then they can be simply looked up individually down to the Project Record and then used in an Open email notification.

    Use the new combined text Summary field to get those email addresses up to the Company Record.

    Then I would use say 10 formula fields to parse out the say 10 Company Contact people email addresses to fields on the company record.

    Post back if you need help with that formula.
  • EriksonTsang's avatar
    EriksonTsang
    Qrew Cadet
    6 years ago
    thanks. I've parsed it out by doing the "left([combined text],";") and then Notleft of the first one to string the next set.. looks like i'm creating lots of field.. Is there a better/more efficienct way to parse it out?

    thanks,

    Erikson Tsang
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    You will need that one Combined text Summary field and then one more field for each person you want to allow for, so if you want to allow for up to 10 Contacts than you will need 10 more fields.