How to update list item

Hey there,

how can I update a list with a multidropdown? I have 2 databases. One for courses and one for the categories. I want that the categories in the courses database get updated when I delete something. How can I do it?


Whatever action deletes the “something” can also trigger the courses to update the categories list. or you can do a DB trigger whenever the “something” is deleted, update the courses…

1 Like

Could you support me? I am new and struggling then hours :rofl:

If I have understood you correctly, you could also replace the “Categories” field in the Courses table, which is currently of the “List of texts” type (I assume), with the “List of categories” type. If you then delete a category, it will also be removed from the list.

The default value in this case would be
“Search for Courses:each item’s Categories’s Categories”

I want to have a database for categories so that when somebody creates a new category that it will be displayed as default in the multidropdown. The category items should be stored aswell in the courses category field list. The problem is when I delete a category the courses category field does not get updated.

How can I delete a category item from the courses category field that is not selected in the multidropdown?

If I understood correctly, you want that when you update the categories it gets updated in the courses too.

What is not super clear to me is why you would want that.

1.Let’s say you create a new category. In that case it makes sense that it’s now available when you create a new course but it doesn’t really make sense for it to be added to every course previously created.

2.Now let’s say you delete a category, does it mean that a course created with this previous category is not offering it anymore?

Just asking questions here. I’ll walk you through how to achieve the above behaviours.

  1. If you want a category to be added to every course as soon as that category is created you will need to:
    -create an API workflow that take a course and a category as a parameter and adds a category to the list of category of the course.
    -Schedule this specific API workflow on a list (in that case on all the courses) and give it the category you just created as a parameter.
    -this can be schedule right after you created the category

  2. If you want the category to be removed from all of the courses list when you delete it you need to:
    -create an API workflow that take a course and a category as a parameter and removes a category to the list of category of the course.
    -Schedule this specific API workflow on a list (in that case on all the courses) and give it the category you just created as a parameter.
    -this can be schedule right before you delete the category

Hope it helps!

1 Like