In Forms, selecting a reference from a long list (1000+) is not working

[nicolas-imbert]

Describe the current behavior

A bug occur when a user wants to fill a reference field in a form.
If the initial list of references is too long (aka more than a 1000 references), the user cannot select all references in the list.
Only about the first 1000s are shown.
Even when the user try to write the name to look for the reference, the autocompletion do not work.

In this example, there are about 2500 companies in the reference list, but in the form, only the first 1000 companies are shown.
Even if we try the autocompletion, the list is stuck at the letter G (and cannot find the T companies)

Steps to reproduce

1. Create a database of 2000+ records
2. Make a form with a reference of those 2000+ records
3. Try to fill the form with record that are near the end of the 2000+ list
4. You cannot select the last records of this list

Describe the expected behavior

The reference field should be able to show all record in the list.
Not only the first 1000 ones.

Where have you encountered this bug?

• On docs.getgrist.com
• On a self-hosted instance

Instance information (when self-hosting only)

• Grist instance:
  • Version: 1.1.16
  • ANCT self-hosted server

[diogo85]

There's also a bug when using Reference List. It seems that only the first 30 entries are displayed, which limits the usability when dealing with larger datasets.

[nicolas-imbert]

Agreed @diogo85 !
I have just experienced the issue as well.

Reference List and Choice list are badly displayed in forms.
Only about 25-30 entries from the list are shown, with checkboxes.

Imo, it would be ideal to :

• Have the choice to display your Reference List and Choice List as checkboxes (best for small volume of data) or as a dropdown list (best for big volume of data)
• If the List option is chosen, just like the normal Reference, have a bar with prefill and auto-completion, and the possibility to add several references in the same field

[vinyll]

Hey Nicolas, Do you plan to work on this?

[nicolas-imbert]

Hey Nicolas, Do you plan to work on this?

Hi Vincent, I've raised this issue to the developers today.
Lots of work are going on right now, will see if they got time to work on it in a short/mid term.

[mathgim]

Hello,
Is there any updates on that bug please? As Grist usage expands, it becomes more and more important to have a functional form.