Existing values in a reference column are not resolved

[audez]

Describe the current behavior

When inserting a value in a reference column, if it corresponds to an existing value of the column selected in "Show column", we observe 2 behaviours:

• inserting via a copy/paste, via the API, by typing text or via a file import: the reference is found
• inserting via a custom widget or a trigger formula: the reference is not found, the cell appears in error

I apologise in advance if this has already been written, but I couldn't find an issue on the matter. Please let me know if it's the case!

Steps to reproduce

1. Create a table with a text column "Name" with a value "Jojo", and another table with a column "Ref" that references the first table and shows "Name" column.
2. In the "Ref" column, insert a new value "Jojo" by a copy/paste or typing the value. See it's auto-resolving.
3. Do the same through the API console or file import. See it's fine too.
4. Do the same with a custom widget (as Action Button) or a trigger formula. See it's not resolving, the value appears in error.

Example inserting by copy/paste, typing (OK) and custom widget "Action Button" (KO):

Example inserting with a csv (OK) or a trigger formula (KO):

Describe the expected behavior

If the value inserted in a reference column corresponds to an existing value of the shown column, the reference should be automatically resolved.

Where have you encountered this bug?

• On docs.getgrist.com
• On a self-hosted instance