Hello,
Great new feature but can’t make it work for a reference list.
I have a reference list listing some years. 2025, 2026, …
I have a form for another table asking the user to fill up the year Reference field.
I tried adding “?Year=2026“ or “?Year.Year=2026“ or “?Year=Year[6]” but the field does not get filled up.
Any idea on how to make it work?
What’s the type of your year column being referenced ? I could make it work with `Year=2026` when Year.Year is a string (so, “2026“) but not when it is an integer. My feeling is that you can only accept text values from URLs for now. my feeling was wrong, it’s just a bug, see below.
indeed, it is an integer…
Actually, ?Year=2026 should work for a “Reference List” column – as long as the column is configured to show the year, even if it’s numeric. In other words, if you are seeing “2026” in the choices, you should be able to use it as a URL parameter.
But I do see a bug with this for a Reference (single) column. Will fix. If you are seeing an issue with Reference List too, could you share more details (or a document that shows the issue), since I’m not able to reproduce in that case?
Yes, sorry, this is what I was describing. Haven’t tested with ReferenceList.
sure, let me create a doc
Here is the Grist
Test reference list for pre-filled form - Grist
And the form not working as per intended:
https://docs.getgrist.com/forms/gzsQcfV4T3JFiuLBnBxtDA/7?Year=2025
Perfect. So this is indeed a field of type “Reference” (rather than “Reference List”). I can reproduce this, and a fix is coming. Until then, change the type of the “Year” column in the “Year” table (not the “Request” table) to text, and it should work correctly.
Dear @dmitry-grist , can you confirm that this will be fixed in the next update? There is no Github issue to follow so I need to make sure… Thank you
I believe it is already released. Could you try again please, and let me know if anything is still not working as you expect?