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

[JS7319]

Let me use an example.

I am capturing all the treatments within a hospital department - each treatment captured will have a NAME for it, TIME TAKEN, a CATEGORY and a DESCRIPTION. The user will be able to create as many rows as they like with these 4 fields appearing for each treatment, so there won’t be any fixed number of rows as each department will have more or less treatments on offer than the other.

How can I set my database up to not only capture this information for each of the treatments, but also each of the 4 fields per treatment?

I thought about using a database ‘list’ but then thought I need to push this data via an API to generate a document, will I come across limitations as I won’t be able to do any complex searches across the list or manipulation of data?

[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.

https://manual.bubble.io/help-guides/working-with-data/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.