Your exactly right. This has been a feature request of mine for a while. Please go to the feature request app and upvote:
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Relational data in the app should use Unique Key / Row ID as choice value | 5 | 677 | May 12, 2020 | |
| Choice Component - multiple selections | 65 | 8995 | December 24, 2022 | |
| Choice Component - allow key display pairs | 14 | 2038 | April 7, 2020 | |
| Multirow Choice Component (aka Chips UI) | 157 | 8897 | October 8, 2021 | |
| Understanding how CHOICE interact with Sheets | 8 | 873 | January 17, 2024 |