Hybrid tag: text with number

[vasnt]

Usually tags/labels are text based. I am usually looking for hybrid tag i.e. text with number. & both should be updated independently.
i.e. instead of

i want as below

numbers identify its importance/weightage for that particular row item.

it should be possible to increase/decrease/edit/filter/sorting Number & text -independently easily (by user).
Only in UI/output they should be displayed together as per above snap.

[tea-artist]

You can create a new table to store the tags and convert the first column into a formula. This way, you can freely combine tag rules. When you need to use tags, create a new link field to link with the tag table, allowing for selection.

[vasnt]

numbers shown (2,12,5,20 in above snap) are not formulae generated, instead it is user inputted. & then increased/decreased manually as required. So i guess tag rules may not be useful in this case. This is kind of (hybrid/combinational) UI component. e.g. Just like what twitter has

[tea-artist]

Here is an example, I think it should meet your needs

The Tags field is a LinkField linked with the Tags table

The primary field of Tags table is a formula that combines weights and tags


Now you can easily change the weight in the Tags table and the Main table will update automatically.

[vasnt]

Thanks for detailed info.
This kind of table(shown below) is not suitable due to following reasons

• I want to edit weight in main table, itself, inplace
• Each Tag may have multiple weight

[vasnt]

reiterating

[tea-artist]

I see, but it is not how relational database works.

“Each Tag may have multiple weight”
There will be a unique value check function in the future

[vasnt]

I am not good at database fundamentals.
have you came across any other database in which this kind of feature/component is available (as an alternative to teable) ?

[vasnt]

sample tag/label image just for info: