May 26, 2023 06:09 AM - edited May 26, 2023 09:49 AM
I would like to find records whose ID field match a given value, playlistId, in a specific table I defined as playlistsRecords. In other words, I want to find matches in a field, get their record IDs, and if there are no matches to tell me that there are no matches. I've tried "playlistsRecords.includes(playlistId)" without success and suspect I need to rely something like the following:
base('Playlists').find(playlistId, function(err, record) {
if (err) { console.error(err); return; }
console.log('Retrieved', record.id);
});
Any pointers? Past experience?
Solved! Go to Solution.
May 26, 2023 09:08 AM - edited May 26, 2023 09:42 AM
I beieve I figure it out myself, but more elegant solutions are welcome.
Find my solution below:
var numberOfMatches = 0
for (var r = 0; r < Records.length; r++)
{if(playlistId == playlistsRecords[r].getCellValue(idField)) { //If a given record's ID field matches the playlist ID
numberOfMatches => numberOfMatches + 1}
}
if(numberOfMatches < 1) {
console.log('No matches, created new curator record in Airtable')
}
This solution relies on a variable, numberOfMatches, that updates for every record match.
May 26, 2023 09:08 AM - edited May 26, 2023 09:42 AM
I beieve I figure it out myself, but more elegant solutions are welcome.
Find my solution below:
var numberOfMatches = 0
for (var r = 0; r < Records.length; r++)
{if(playlistId == playlistsRecords[r].getCellValue(idField)) { //If a given record's ID field matches the playlist ID
numberOfMatches => numberOfMatches + 1}
}
if(numberOfMatches < 1) {
console.log('No matches, created new curator record in Airtable')
}
This solution relies on a variable, numberOfMatches, that updates for every record match.