Need help with field mapping

[ext_bks]

Hi all,

I am thinking along the lines of applymap but I am uncertain how to achieve this. My datasource is excel file and the tables something like this:

Table Project:

Project ID	Project Status
Proj A	?
Proj B	?
Proj C	?

Table Tasks:

Project ID	Tasks	Task Status
Proj A	Proj A-Task 1	Complete
Proj A	Proj A-Task 2	In Progress
Proj A	Proj A-Task 3	Not Started
Proj B	Proj B-Task 1	Complete
Proj B	Proj B-Task 2	Not Started
Proj C	Proj C-Task 1	Complete
Proj C	Proj C-Task 2	Complete

I would like to add a new column called Project Status in Project Table, by looking up Task Table. If All tasks related to a project is marked as Complete, then my Project Status will be complete. If It is a mix of Complete, In Progress and Not Started then Project Status as In Progress, and if everything is Not Started then Project Status as Not Started

So the result in Project Table will be:

Proj A - In Progress

Proj B - In Progress

Proj C - Complete

Appreciate you help very much!

Thanks!

[Seyko · Accepted solution]

Hello,

Use the example in attachment. It should work, normally.

cordially.

[ext_bks]

Hi Seyko,

Thank you, your app works great! Does exactly what I wanted but in my app somehow it's not working. I've sent a private message with my code.

Thank you very much!