Record select field shows correct value briefly, then switches to primary field with infinite loading

Application Builder
, ,
1

Hi,

I’m running a self-hosted instance of Baserow 2.0 and I’ve run into a strange issue with record select fields.

My application allows users to process invoices. The relevant tables for this issue are:

  • Invoice Headers

  • Invoice Rows

  • Ledgers (Grootboekrekeningen)

Both Invoice Headers and Invoice Rows contain a linked field to the Ledgers table.

Previously I used a dropdown field to select a ledger in the Invoice Headers table, but I want to switch to a record select field because of the improved search functionality.

Table setup

In the Ledgers table:

  • The primary field is a custom Ledger ID (this is not the Baserow internal row ID)

  • I have separate fields like:

    • Code (e.g. 7200)

    • Description (e.g. Revenue)

  • I also have a formula field that combines Code + Description into a single display value

In the Invoice Headers table:

  • I created a lookup field that references this combined formula field from the Ledgers table

The problem

When I configure a record select field to show that lookup value:

  • On page load, the correct value (Code + Description) is shown for a split second

  • Then it switches to the primary field (Ledger ID) and shows an infinite loading spinner

Another strange behavior:

  • When I open the record select dropdown, all options are shown correctly (Code + Description)

  • But when I select an item, the selected value in the field shows only the Ledger ID, not the combined Code + Description

The actual selection and saving works correctly. If I select a value and save the record, the link is stored correctly and everything works as expected. The issue is only with displaying the correct value and the infinite loading state.

This setup works perfectly when I use a dropdown field with the same lookup configuration.

Screenshots

I will add screenshots below of:

  • The infinite loading state

  • The record select field configuration

  • The (old) dropdown field configuration

Question

Is this a known bug or limitation?
Is there a way to force the record select field to use the lookup/formula value as the visible label instead of the primary field?
Are there any known workarounds?

Or am I just missing something?

Thanks in advance for any help!

image
image919×242 10.7 KB

image
image384×875 40.6 KB

image
image382×767 35 KB

2

I’ve added a video showing what happens when I reload the page (I’ve changed the primary field to “code” so it show the code as placeholder, but still not the code + description)

3

I’ve also added a record selection field in the invoice rows. Here it does not display any default value, although having the same default and placeholder values as the bottom selection field (See screenshots). It only displays it after selecting something.

image
image1824×839 78.1 KB

image
image371×858 40.2 KB

image
image392×772 36.5 KB

4

Anyone that can help?

5

Hi,

It is indeed a known limitation. Only the primary field is shown to ensure the readability of the selected item(s), especially when multiple items can be selected.

A work around is to use a Text or Repeat element to show the full text of the selected values above or below the Record selector .

I wasn’t able to simulate the issue with the ongoing spinner, but can you try to remove the Placeholder property and check if that solves the issue?

6

Thank you for your response. I’ve applied the workaround. Could you share any updates on the status of this issue, or an estimated timeline for when a fix might be available?

7

Hi, we have no plan for this feature yet but you can follow the status of the issue here: Add suffix support to the record names endpoint. · Issue #4592 · baserow/baserow · GitHub