Store lookup values as tags [Apr 15]

:raising_hand_man: vishal.gandhi asked

Hello

I would like to store lookup value from other table and fields as tags ; is there a tag data type available or only option is JSON , not sure if lookup can be performed for JSON

:raising_hand_man: wkw replied

could u mind elaborate a bit?

:raising_hand_man: wkw replied

for lookup sample, please check out Lookup - NocoDB

:raising_hand_man: vishal.gandhi replied

i would like to store multiple tags in a row

:raising_hand_man: vishal.gandhi replied

e.g. expense table

Category - Restaurant

Tags - out ; april

:raising_hand_man: vishal.gandhi replied

if i want to query by any of the tag ; i should be able to

:raising_hand_man: vishal.gandhi replied

and these tags could be stored in a master table

:raising_hand_man: wkw replied

lookup on hasManyCells will be available in the next release

:raising_hand_man: wkw replied

if i understand correct,

expense table → lookup table → tag table

your structure s like this right?

:raising_hand_man: vishal.gandhi replied

lets consider this example

Employee ID | Employee Name | Project (tags)

8272 | Xyz | 1 2, 3

92828| abc | 4,5

Project Lookup

Project ID

1 A

2 B

3 C

4 D

5 E

:raising_hand_man: wkw replied

"I would like to store lookup value from other table and fields as tags "

then your lookup column would be either multiSelectCell or hasManyCell

:raising_hand_man: wkw replied

if it is the first case, the current version supports it

:raising_hand_man: vishal.gandhi replied

any documentation i can refer to

:raising_hand_man: wkw replied

the one i sent u

:raising_hand_man: wkw replied

^

Autogenerated from discord


Join NocoDB’s community

Discord • Twitter • Reddit • Docs