CRUD application using Metabase - Filtering on text fields

Hello,

I'm a happy user of Metabase (version 0.46.6).

Following Build a basic CRUD app with actions, I was able to build a dashboard to update one of my database table, using the ID field of the said table. Fine.

Now, I would like to do the same but with filtering on a text field.

Basically, a simple version of the table is :
Id (as integer)
Name (as text)
... other fields.

What I would like to do is to have a filter where I choose, by entering some text, a unique line. Then, use a basic action "update" button, to change some values on the "selected" record.

I tried the following :

  • Delete the ID filter, add a text filter and link the action button to the text filter : not OK
  • Keep the ID filter, add a text filter, link them together, and link the action button to the text filter : not OK (same with the action button linked to the ID filter).

Do you have some advices ? Or maybe it is not possible at that time ?

Thanks for your help.

Emmanuel.