Multidropdown auto-populate

Hi all!

I’ve been searching for a solution for this for days and thought maybe now is my time to ask (rather than throw my computer out the window).

I am building a place to store education notes and books, and part of this is tagging the note or book with its category (ie. Science, Maths, Business). I’ve also created it so that you can set it as ‘you want to read it’ or ‘you have read it.’

Here’s my issue:

  • I’ve created the Categories using the Multidropdown input and set it so that you can see the category next to the notes and books.
  • When it’s moved from ‘want to read’ to ‘finished reading’ I want to carry through the existing Categories, but allow the user to change it if they want.
  • I just can’t seem to find a way with the Multidropdown input to automatically transfer the Categories between the database view of Want To Read to Finished Reading.

Am I missing something really easy here or is it not possible?

Thanks

Can you provide the setting of your multidropdown input?
It should not be complicated

And also maybe a screenshot of your DB setting where you store the multidropdown values

Thanks for getting back to me @Jici , I didn’t think it should be hard!

Here is the multidropdown:
Screen Shot 2021-02-16 at 10.41.53 am

Regarding the database, I am only storing the Category next to the User. Then on the book state (Want To Read and Finished Reading), I also store the category as a text field.

Hope this makes sense!

The placeholder is more a text to display when this is empty. You should use the Default value to set the current data instead. Be sure that the Parent group contain all information your need

You should store the categories into a field of type “Categories” and not in a text list (don’t forget to activate this is a list option)
You can always use a text list if you want but it’s better to use the correct type if you are using options set or Data type

Hmmmm ok, I think I get what you mean. I’m just going to be out for an hour but I’ll try and sort it out when I’m back, and will let you know.

Thanks for your help!

1 Like

Yep, I’ve got it sorted now thanks @Jici. I had to leave it as text (list) because I want the user to be able to type their own new category.

But I’ve managed to work it out using both data types on the notes.

Thanks!

1 Like