I did manage to do it with Automation + script.

Here is the script (sorry for the french table names and missing indentation) :

let inputConfig = input.config();

let posteId = inputConfig[“posteId”];

let postesTable = base.getTable(“Postes”);

let candidatsTable = base.getTable(“Candidats”);

let candidatsPostesTable = base.getTable(“Candidats_Postes”);

let result = await postesTable.selectRecordsAsync();

let postes = result.records;

let poste = postest0];

for (let posteTemp of postes) {

if (posteTemp.id == posteId) {

poste = posteTemp;

}

}

result = await candidatsTable.selectRecordsAsync();

let candidats = result.records

let candidatsPostes = candidats.map(candidat => ({

fields: {

‘Poste’:
‘Candidat’: >candidat]

}

}));

while (candidatsPostes.length > 0) {

await candidatsPostesTable.createRecordsAsync(candidatsPostes.slice(0, 50));

candidatsPostes = candidatsPostes.slice(50);

}

Thanks for the script. Your candidates have no choice but to apply to all companies .

You’re welcome!

In fact, they have

The point is for us, on the recruitment side, to never forget about a potential match between a candidate and a company :winking_face:

Once we have examined all criteria, only a few candidate - company tuples are left and then we ask the candidates.