Native Grist forms: pre-filled fields + dynamically filtered Reference List

Ask for Help
1

Hello,

How can we use Grist to send a form with pre-filled fields and dynamically filtered fields based on those pre-filled values?

For example, I have a Reference List column whose available choices depend on another column, which may be a Text or Reference column.

In the regular Grist table view, this works as expected thanks to the choice/filtering condition. However, in a native Grist form, all possible choices are displayed, even when a filtering condition is defined.

Is there a way to make the form respect these conditions, so that the available choices are filtered dynamically based on the pre-filled field values?

2

Hi Clemence,

There is a way to prefill fields from the URL (Form - Grist Help Center). If you go to the form page > select the field you want to edit > and go to the field option menu, you should see “accept values from URL” at the bottom. If you choose this, you can prefill that field using a URL parameter in the link itself. You can see a demo form using this functionality here - Owner_Dog_Filter - Grist

Unfortunately, as far as I am aware, there is no way to filter a Reference List on a Grist form. But I agree that would be super helpful!