Need help with field mapping

ext_bks — Sat, 16 Nov 2024 21:13:08 GMT

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!

Re: Need help with field mapping

Seyko — Tue, 19 Mar 2019 15:52:08 GMT

Hello,

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

cordially.

Re: Need help with field mapping

ext_bks — Wed, 20 Mar 2019 00:20:25 GMT

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!

topic Need help with field mapping in App Development

Need help with field mapping

Re: Need help with field mapping

Re: Need help with field mapping