search

gristlabs / grist-core

Grist is the evolution of spreadsheets.
https://www.getgrist.com/
Apache License 2.0
7.18k stars 320 forks source link

Conditional filtering and list format for Reference&Reference List - dropdown list #453

Open Vladimir-Va opened 1 year ago

Vladimir-Va commented 1 year ago

Hello, Grist team. Created a test table with > 80000 records when using this data as source for a few M2M tables, reusing data becomes very difficult, according to the proposed methods, creating an additional field and using it as a header, for example: https://github.com/gristlabs/grist-core/issues/249 For orders: '{Type}/{Model}/{Year} - {PartNo}'.format() For invoices: '{Type}/{Model}/{Year} - {VIN}'.format() For cargo: '#{invoice} | {Invoice_year} - {Type}/{Model}/{Year} - {VIN}'.format() With each new cascade, it grows.

  1. We have a wonderful tool conditional style I propose to consider the possibility of using this principle to add multiple conditional filtering for dropdown list Reference&Reference List fields.

Judging by the forum this problem is acute.

  1. Add HTML field for formating dropdown list selector. Utilization https://github.com/gristlabs/grist-core/issues/208
Vladimir-Va commented 8 months ago

Another implementation found Cascader in the next implementation of airtables. Also a working and simple option.