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.
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?
Yes the issue could be we are referring to the Recipient’s Last Feed.
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
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.
@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!