I need to know how i ask to run script when new record is created and define if name
in:
var response = await fetch('https://api.agify.io/?name='+name);
is equal to Prénom
used from table else only change records only for this person.
I give you a screen of my table
// query for every record in "trombinoscope"
let table = base.getTable("test");
let view = table.getView("Donnée brut");
let query = await view.selectRecordsAsync
(
{
sorts:
// sort by "Prénom" in ascending order...
{field: "Prénom"},
]
}
);
let records = query.records;
// print ID & "Prénom" from each record:
for (let record of query.records)
{
let name = (record.getCellValueAsString('Prénom')) ;
let response = await fetch('https://api.agify.io/?name='+name);
/*fetch('https://api.agify.io/?name='+name) ;*/
/*console.log((await response.json()).age);*/
let agifyAge = (( await response.json()).age);
let records = query.records;
for (let i=0 ; i<records.length ; i++ )
{
/*if ( name == ((await response.json()).name) )*/
await table.updateRecordsAsync(
{
id: recordsei].id ,
fields :
{
"Age estimé" : agifyAge ,
},
},
]);
}
/*console.log(await response.json());*/
/*let json = JSON.parse(await response.json());
console.log(jsono"age"]);*/
}