# Email (Rules) Partially Support Parent Data? 🫠

**URL:** <https://forums.knack.com/t/email-rules-partially-support-parent-data/17785>\
**Category:** Get Answers\
**Created:** [August 26, 2024, 11:04am UTC](https://forums.knack.com/t/email-rules-partially-support-parent-data/17785 "2024-08-26T11:04:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kris](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@kris](https://forums.knack.com/u/kris)\
**Post date:** [August 26, 2024, 11:04am UTC](https://forums.knack.com/t/email-rules-partially-support-parent-data/17785/1 "2024-08-26T11:04:45Z")

</div>

Maybe I’m missing something here, but in 2015 someone posted a feature request that was still not implemented as of 2023 (wild!):

> [@Connected record fields in form emails](https://forums.knack.com/t/connected-record-fields-in-form-emails/9636):
>
> Ability to use the fields from connected records in emails (form, task).

I’ve just arrived at this exact issue trying to build useful and actionable email notifications for my app.

The use case is fairly basic:

Parent Object (Applications)

- Child Object (Notes)

When someone submits a new Note form against an Application send an email to the Application owner to let them know.

The Parent Object has details such as “Customer Name” and “Application ID”. From what I can see these items can’t be accessed by an Email rule at the child level even though for some reason that Email rule can see _some_ parameters from the parent object properties in the recipients fields.

How is anyone supposed to generate any useful and/or actionable emails if we can’t put the Application ID or Customer Name from the parent application into the Email being sent?

Maybe I’m missing something here, but I was very confused:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/4/4b4be0598fa30ced1d376cc4d4f88efe661ba2ef.jpeg)

---

<div class="post-metadata">

**Author:** ![MichaelWil71217](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/michaelwil71217/32/588_2.png) [@MichaelWil71217](https://forums.knack.com/u/MichaelWil71217)\
**Post date:** [August 27, 2024, 1:27pm UTC](https://forums.knack.com/t/email-rules-partially-support-parent-data/17785/2 "2024-08-27T13:27:04Z")

</div>

I have this same frustration, seems like something simple that Knack should have long implemented by now. It makes the email communications you can generate very hollow. I resulted in including a link in the email for the person to view more details by clicking the link which takes them directly to the details. This is a poor workaround. I also feel they should allow you to create template emails at a higher level within the app and then decide when and where they are triggered.

---

<div class="post-metadata">

**Author:** ![Les](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/les/32/4243_2.png) [@Les](https://forums.knack.com/u/Les)\
**Post date:** [August 27, 2024, 4:30pm UTC](https://forums.knack.com/t/email-rules-partially-support-parent-data/17785/3 "2024-08-27T16:30:23Z")

</div>

Hi @kris,

I understand your frustration here, so I would like to offer a workaround:

If you create a text formula field in the Notes table and pull the connected field values (Customer Name and Application ID) from the Applications table, you can then use those text formula fields in the email body to reference those field values from the connected table.

You can learn more about text formula fields here: [About Text Formulas](https://learn.knack.com/article/r3edi1pk8v-text-formulas)

---

<div class="post-metadata">

**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\
**Post date:** [August 27, 2024, 8:39pm UTC](https://forums.knack.com/t/email-rules-partially-support-parent-data/17785/4 "2024-08-27T20:39:14Z")

</div>

Yes text formulas work to a point. For things like emails we use a combination of text formulas and conditional rules.

This is a tad (a little) annoying as text formulas add complexity when you don’t need that when displaying data that is already connected. Ideally this would work like grids or details views if it’s connected you should be able to directly access it.

Text formulas are very useful in Knack for getting data from objects that aren’t directly accessible from the object you are in. Just be wary of cascading formulas.

Craig.

---

<div class="post-metadata">

**Author:** ![kris](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@kris](https://forums.knack.com/u/kris)\
**Post date:** [August 27, 2024, 9:11pm UTC](https://forums.knack.com/t/email-rules-partially-support-parent-data/17785/5 "2024-08-27T21:11:12Z")

</div>

Hi Les,

Thanks for the work around. The first time I tried this before making this post the output from using a text formula was blank. Your solution and @CSWinnall comment about cascading formulas lead me to investigate the table connection. Looks like I had the formula cascading in the wrong direction so its output in emails was blank. I had my “table connection field” at the parent (Application), instead of child (Notes) level.

With the connection corrected, text formulas are rendering before the email workflow is triggered and so they’re being output correctly which is great.

For anyone wondering this article is a good read: “Which table to add your connections to”

> **[About Connections](https://learn.knack.com/article/do520qb4jz-about-connections#which_table_to_add_your_connection_to)**
>
> Here you will find essential information on how to incorporate connections into your Knack app.

Hopefully this will help someone else who comes across this issue.

Thanks!
