We are trying to access a specific cell value in the code. We are able to query the records and getCellValueAsString. However when we try to call a specific record from a field we get a completely different record from that field and there seems to be no pattern to it.
let table = base.getTable("🌻 Groups"); let queryResult = await table.selectRecordsAsync(); let record = queryResult.records; console.log(record.getCellValueAsString("This Record 🆔")); console.log(record);`Preformatted text`
As you can see we are trying to get the first record in the list, but we actual get the 27th and if we increment the value to the second, we may end up getting the 35th record. However all of the fields within the row that is selected is present.
The reason we want to do it is because we want to update a linked record to a cell while leaving the previously linked records intact.