Help

Asking for help with lookup in two tables and write combined in new table

Topic Labels: Scripting extentions
1062 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Diederik_Dam
4 - Data Explorer
4 - Data Explorer

Hi

I am creating an extended project planning tool. So i create an graph for the project in which the workload per week in presented.
For this I use data from a couple of tables (team, standaard uren (standard hours), Init en activiteiten (activities))
In order to create the graphical load per week I need to create subfases per main fase (hoofdfase)

What i am trying to do is retrieve the fase + number of weeks in order to write these in the table activiteiten and also teammember from teamleden. I managed to get to work through test2 … But now stuck.

Anybody willing to help? or maybe if you need more info, please let me know.

//let

let fases = [{

fase: "Voorbereiding",

startDate: startdatumV,

endDate: endDateV,

weeken: duurV,

id: records[0]

},

{

fase: "Campagne",

startDate: startDateC,

endDate: endDateC,

weeken: duurC,

id: records[1]

},

{

fase: "Nazorg",

startDate: startDateN,

endDate: endDateN,

weeken: duurN,

id: records[2]

}];

// await

fases.forEach(async (f) => {

   for (let j = 0; j < f.weeken; j++){

    console.log(j);

    console.log(duurV);

    console.log(duurC);

    console.log(duurN);

    console.log('test1');

    let subfases = standaard_uren_tabel.selectRecordsAsync();

    let teamlid = team.selectRecordsAsync();

    console.log('test2');

    let subfase = undefined;

    subfase = subfases.records.filter(rec => {

        return rec.getCellValue("Fase").name.localeCompare(f.fase) && parseInt(rec.getCellValue("Fase nummer")) === (j + 1);

    });

    let functie = teamlid.records.filter(rec => {

    return rec.id.localeCompare(parentRecord.id);

     });

console.log(‘test3’);
console.log(subfase[0].name);

    console.log(functie[0].name);

    let startDate = null;

    let endDate = null;

    if(j === 0){

        startDate = f.startDate;

        endDate = addWeeks(removeOneDay(f.startDate), (j+1));

    } else if (j === f.weeken-1) {

        startDate = addWeeks(f.startDate, j);

        endDate = f.endDate;

    }else {

        startDate = addWeeks(f.startDate, j);

        endDate = addWeeks(removeOneDay(f.startDate), (j+1));

    }

    console.log(subfase);



    await activiteit.createRecordAsync({

    "Hoofdfase": [{ id: f.id }],

    "subfase": [{ id: subfase[0].id }],

    "Start datum": startDate,

    "Eind datum": endDate,

    "Projectleider": [{ id: parentRecord.id }],

    "Uren per week": parseInt(subfase[0].getCellValueAsString(functie[0].getCellValue("Functie").name))

    });

}

})

0 Replies 0