Action - filter db data

[WimDC]

Hi,

I’m totally new to Flipabit and trying to discover its possibilities.

I’m using Google Sheet as database and could already make a page with 2 table widgets (see image)

• one table with the first letter of the name-field
• one table with the full list of names

Now, I want to create an action that filters the second table when one of the letters in the upper table is clicked (so clicking on “W”, must only show the names “Wim”, “Willy” and “Walter”.
I could find an action filter db data , but I don’t know how to start building this action.

Databases with the fields > see images
The first table (with the letters) contains the field letter_zichtbaar from the database beginletters

So I think the filtering has to be something like if *letter_zichtbaar* is clicked then filter db *namen* where left(naam,1) = letter_zichtbaar

Wim

[Vladimir_PV]

Table relationships - связи таблиц

you need to get the username from the “A” database by the key from the “B” database нужно получить имя пользователя из базы «A» по ключу из базы «B»

[Michael]

You need to use Filter data custom action with operator LIKE. To select all values that start with a letter, add a percent % symbol to the letter.

See the example get_names_by_letter.pma (31.2 KB)

[WimDC]

Nice solution ! Thanks !!