Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Scripting extentions
309 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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