Do I need to use a database 'list' here - how can I set this up in a database?

[lindsay_knowcode]

A typical approach would be to have another table like “department treatments”. Which holds
Department
Treatment (with it 4 fields)

So it would have multiple rows of treatments per Department.

Then design the UI so as each Treatment is added, that treatment is added the DB. (to avoid the backend workflow API to deal with adding lists)

Regards using basic Bubble to do a search across a nested relationships of objects - that is another kettle of fish.

Using Algolia

How to search for "something" that's inside a "list of text" field on my database

Thanks Patricia for this excellent article!! I’ve learned something new!! The problem is that my field (Linked) is a list of text and I cannot use the option :truncated on it! It doesn’t appear as option in the list to choose from. [image] Still, thank you so much for responding to me!!! I really appreciate it!! But I can use it for other things!!!

At least that’s how I’d approach it.