Separate options in a list in different records

Hi everyone.

I have a huge problem.

I made ma data base using multiple options in a list, with a date for the choosen selection in the list.
Problem is, I figured out now that I need to have one different record for each option selected in the list. So I have to create as many records that there are options selected in the list. And I have do to so for around 150 records …

For exemple :
the record
1 | Banana, Apple, Orange, Kiwi | 02/04/2020
have to become
1 | Banana | 02/04/2020
2 | Apple | 02/04/2020
3 | Orange | 02/04/2020
4 | Kiwi | 02/04/2020
Please, tell me there is a solution to my problem …

Hi @Antoine_Morin,

There is indeed a solution. What I would do is the following:

  1. Assuming the data is is in the primary field (if not, then skip this step) Duplicate the field so that you have more options.

  2. Now in the new field, use the Link to another record, choose create new table. Deselect the option of Link to multiple records.

  3. Lets say that the data that you want to actually see is the date, then use a formula to make the primary field in the original table equals the date field

  4. Now you have a new table, where the primary field is the item and the second field is the date. You can now unlink the fields and delete the old table if you want (given that all the data needed is now in the new table)


I don’t understand, this will not create multiple records ?
At the end, I have to manually create new records …