I came back here to say that I found the possible solution.
Just set the search pointer to start 1, because 0 = end.
It is counter intuitive, as usual with Airtable, but it goes like this:
FIND (“linked_record_id”, Column, 1)
Airtabl...
I came back here to say that I’m still in trouble.
The method mentioned above does not work when the ID is in the middle of other IDs.
For example, in the field that references the IDs of the linked records, if I have recX, recY, recZ, I cannot find ...
I managed using OR (FIND (" linked_record_id ", Column)> 0)
I believe this is less performative, as it is a string comparator on the server.
Only when I have many records will I be able to know the impact of this.
I was surprised to learn that Airtab...
Chester_McLaughlin:
essa abordagem é potencialmente sujeita a erros porque você usa correspondência parcial de strings. Você deve primeiro consultar a tabela Roles e, em seguida, usar JS para construir um array de RECORD_ID () do Player associad...