Store lookup values as tags [Apr 15]

Discord-Discussions
1

: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

2

:raising_hand_man: wkw replied

could u mind elaborate a bit?

3

:raising_hand_man: wkw replied

for lookup sample, please check out https://docs.nocodb.com/setup-and-usages/lookup

4

:raising_hand_man: vishal.gandhi replied

i would like to store multiple tags in a row

5

:raising_hand_man: vishal.gandhi replied

e.g. expense table

Category - Restaurant

Tags - out ; april

6

:raising_hand_man: vishal.gandhi replied

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

7

:raising_hand_man: vishal.gandhi replied

and these tags could be stored in a master table

8

:raising_hand_man: wkw replied

lookup on hasManyCells will be available in the next release

9

:raising_hand_man: wkw replied

if i understand correct,

expense table → lookup table → tag table

your structure s like this right?

10

: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

11

: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

12

:raising_hand_man: wkw replied

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

13

:raising_hand_man: vishal.gandhi replied

any documentation i can refer to

14

:raising_hand_man: wkw replied

the one i sent u

15

:raising_hand_man: wkw replied

^

16

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs