How to set lookup-field

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.

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

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

Or is there another solution?

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

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.

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…

@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:

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