Adding info to records without erasing the former info

Hi,

via a Form, I want to add a piece of information to a record in my database. The property is called “Offers” and I want people to be able to add what certain restaurants offer. However, when the form “updates the record,” it erases what used to be there and replaces it with the info in the form.

Is there a way the former information is kept and amended by the info in the form? Like I have “Fish, Pork, Chicken” in the property, somebody wants to add “Beef,” so the new record reads “Fish, Pork, Chicken, Beef.”

Of course, I’d like a simple, fast solution for that, but even if you know a way around it, please, share it with me :smiley:

Thanks :slight_smile:

Hi!

not sure if this is what you meant but see the video link if its something similar to what you need?

this is how i structured the collections
restaurant:


dishes:

hope this helps!

1 Like

Thanks a lot! I though it would be something with nested lists…

Thank you again; however, it brings me to another question. I think I read somewhere I cannot search within many-to-many lists. So, I have a way to add “beef” to the offer of a restaurant, but I cannot filter through it in a search in my app. I use another “property” to filter restaurants and offers, but this one wouldn’t (of course) update when I update the “offer” as it’s a different property.

Do you think there is a way I can transfer the nested list (the offer) into a plain text (beef chicken pork), and this text use to update the “property,” through which I can filter? Otherwise, I would need to manually update this “searchable property” whenever somebody add anything to the “offer list.”

Is my question clear or should i rephrase it? :smiley: (I know it’s not easy to comprehand probably)