Extract date in a calendar format from a multiple select field

[SophieULB]

Hello,

 Table 1= I have a list of workshops and a multiple select field "date" which allows me to record all dates when this workshop will be organized the next year. Each line has a unique workshop linked to several dates.

I have another table, table 2 or program, where each line is built by a workshop given at a fixed date.

I would like to automatically fill in the table 2. That is to say I would like to create a new record in table 2 when a date is added in the multiple select field of table 1.

Is this possible? (I manage to create the record, but not to extract the value of the date entered in Table 1 to fill the calendar field of Table2).

Many thanks for your help!

[Sho · Accepted solution]

Hello, @SophieULB 

There is a data integrity issue when generating records with multi-select.
With this method, if a schedule change occurs and a date is deleted and a new date is added, the old date will remain.
So the record added to Table 2 should be made a link record to Table 1. This will maintain consistency and allow for various operations.
If you need a UI to add the records from Table 1, you should consider a button or other method of linking the input form to Table 2.

[TheTimeSavingCo]

If I were you I would convert the multi-select field to a single select, and have the automation to create the record use the value from the single select field for the Date field and also clear out the single select field. 

In Table 1, I would then add a lookup field to display all the dates of the linked records.  This way you can see all the workshop dates in Table 1 like you want, and creating them in Table 2 is still easy to do via the single select value change

[SophieULB]

Many thanks for this idea. I can have several date per workshop so I think the best will be the proposal from Sho.