How to set lookup-field

Baserow Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What do you need help with?

Hi,
With the docs (Lookup field) I could “partially” understand how to set up a look-up-field.
“Partially”, because it seems that the link-to-table field only manually can have values (row per row).
In my first project, I have a MAAND-column (formula month(field(‘datum’)) giving the month-number from my date.

2025-04-24_1
2025-04-24_11078×279 23.2 KB

In a second table (“maanden”) I have those month-numbers, together with the long and short names

2025-04-24_2
2025-04-24_21079×470 17.3 KB

As users will add rows to the main-table, I would like to show the month-names AUTOMATICALLY.
So somehow I would like the column “maanden (link naar tabel)” automatically have the same values as the column “MAAND”.
Or use the column “MAAND” to lookup as shown in screenshot 3

2025-04-24_3
2025-04-24_3615×435 27.6 KB

Or is there another solution?

Please attach screenshots or videos if they help illustrate your question.

2

Hi,

A lookup field is always related to a link to table field. So if the link to table fields is empty, the lookup field will be empty.

In your use case, you would need to enter the values from the column MAAND into the column maanden (link naar tabel)

But I think your use case could be solved easier using a formula field. If you add a column with the formula datetime_format(field('datum'),'Mon') it will show you the first 3 characters of the month. When using datetime_format(field('datum'),'Month') it will show the full month name.

3

Thanks @frederikdc for the info of a lookup field.

I tried earlier the formula datetime_format, but the result is the English month name and I want the Dutch names…
Now I also tried with datetime_format_tz(field('datum'),'Month', 'Europe/Amsterdam') but also the English names…

4

@olgatrykush

Can you ask the team to add “SET_LOCALE” to the datetime_format-formulas; Airtable seems to have this option : Supported SET_LOCALE Locale Modifiers | Airtable Support :wink:

5

Hey @WimDC, I’ll discuss it with the team :raised_hands:

6

Hey @WimDC, thank you for sharing the reference — it’s always very helpful! Good news — we’ve approved your feature request and plan to add it to Baserow. While there are some technical challenges in our system that make this tricky to implement, we think we can make it work in the future. :slightly_smiling_face: