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.
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
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…