# How to Merge 2 Template

**URL:** <https://community.glideapps.com/t/how-to-merge-2-template/57096>\
**Category:** Ask for Help\
**Created:** [January 25, 2023, 9:30am UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096 "2023-01-25T09:30:04Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [January 25, 2023, 9:30am UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/1 "2023-01-25T09:30:04Z")

</div>

Dear Community and Support!

We are working on creating a list of Email Notification Alert for a Feed New Post via JSON string which is created by Glide template.

 ![Notification List](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/1394e3b5f20f8b061406a3f4faf6a13d7dfe5773.jpeg)

The Feed Post has a fix set of info: Feed Post ID, Title, SchoolName, Sender Name etc. of which all are in one Feed Table.

 ![Feed Post Message ID and Info](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/343a5476a9e939287212dfb332e25b1efaf65830.jpeg)

The recipients are in another table with info required: Recipient Name, Email, Whatsapp etc…

 ![Recipient Contact info](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/05b7cae72bec214928d00dce93b25c38f1dd24e4.jpeg)

We have merged the Feed Post info with the Recipient Info, however the Feed Post info are not correct because we use the Single Value - Last Record of the Feed info to merge with the Recipient Table before doing a Lookup back to Feed Table

 ![Merge Feed Info with Receipient Info at the Recipient level using Last Feed details](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b890561911ecd64702037f7c30ca28e12aa06c5b.jpeg)

As such whenever we click on send notification, the Feed info may not be pointing to the current feed

 ![different Feed Post Id - Info](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f70a8c4d397414aecc88d2bc66b6e56122c89422.jpeg)

Is there a good and effective way to merge the template from a 1 Feed ID (Info) to many Recipient ID (Info0)?

Any help and suggestion will be deeply appreciated.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 25, 2023, 9:47am UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/2 "2023-01-25T09:47:11Z")

</div>

> [@pepewaio](#):
>
> We have merged the Feed Post info with the Recipient Info, however the Feed Post info are not correct because we use the Single Value - Last Record of the Feed info to merge with the Recipient Table before doing a Lookup back to Feed Table

Difficult to say without getting a closer look at your tables, but I would have thought you would need a single relation + lookup instead of a single value.

---

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [January 25, 2023, 11:24am UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/3 "2023-01-25T11:24:05Z")

</div>

@Darren_Murphy Hi Darren, thanks for your prompt reply

Yes i can share with you the details if you have time …

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 25, 2023, 11:26am UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/4 "2023-01-25T11:26:23Z")

</div>

Is this the EduTalent Team?

Looks like I still have access to that team. If you can tell me which App this is and which tables are involved, I can probably take a look.

---

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [January 25, 2023, 12:04pm UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/5 "2023-01-25T12:04:48Z")

</div>

Hi @Darren_Murphy Darren, thanks for your reply.

Have sent you a message on the new app. Thanks.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 25, 2023, 2:58pm UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/6 "2023-01-25T14:58:22Z")

</div>

@pepewaio - just looking at this now…

I want to make sure my understanding is correct, can you confirm the below please?

- the issue is with the `Feed/Recipient Last Feed Notify Route` column in the Family table, yes?
- the purpose of that column is to check if the selected recipient received their last notification via email, yes?
- you are using a single value → last through a relation, which I expect would give you the correct result.

Can you please confirm if my understanding is correct, and perhaps explain a bit more why the results you are getting aren’t what you want?

If my understanding isn’t correct, can you help clarify a bit more?

Also, can you give me an example of a record (row number in the Family table will do) that isn’t giving the desired result, and tell me what you would expect to get for that record?

---

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [January 26, 2023, 2:46am UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/7 "2023-01-26T02:46:54Z")

</div>

Hi Darren.

1. Yes the issue could be we are referring to the Recipient’s Last Feed.
2. The purpose of the column is the retrieve the Recipient’s Contact info to be merged to the selected Feed Post (for sending notification)

Hope the following will be clearer:

We are setting up a Send Notification Button for the selected Feed Post. This button will will send out an email to **all** recipient. This will need the Recipient’s contact information (which is residing in Staff / Family Table).

The Notification button is created at the The Feed Post table. This table has the Feed Post data, and each post has many recipients (using Recipients emails as IDs). Pls refer to Recipient → Final Merged Recipient List

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/283a456bbebf00573ca86d8438bdfb48ed3fa7ca.png)

What we are trying to achieve is to consolidate a list of JSON strings for this Feed ID + all the recipients contact details. However as depict below, some of the recipient’s Feed Post ID is incorrect.

 ![wrong feed post id](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/6/c6105fb2e323fb813f48579d3cb7bbefdb4e51be.jpeg)

At your suggestion using Single Value - Relation, we have now tried to use a FeedID for Notification (User Specifc) column at the Feed Table.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c90468f9d1075210ab25d7500c2fe25f4d919439.jpeg)

At the Staff Table, how should we set this up since the Staff could have more than 1 Feeds table?

---

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [January 26, 2023, 11:59am UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/8 "2023-01-26T11:59:43Z")

</div>

@Darren_Murphy Thanks Darren for the superb help + guidance… you make it so easy, fun and open up much more possibilities then i have previously imagine Glideapp can do… Cheers!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 26, 2023, 12:05pm UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/9 "2023-01-26T12:05:50Z")

</div>

So I take it that my suggestions did the job for you?

Happy to help 👍

---

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [January 26, 2023, 12:13pm UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/10 "2023-01-26T12:13:00Z")

</div>

Yes it did the work well and fast! Thanks once again!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [January 27, 2023, 12:13pm UTC](https://community.glideapps.com/t/how-to-merge-2-template/57096/11 "2023-01-27T12:13:57Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
