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
• [X] On a self-hosted instance

Instance information (when self-hosting only)

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