- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2024 05:34 AM
Hi all,
I want to create an automation which creates a new record in Table B (=record B) upon the creation of a record in Table A (= record A).
The title of the automatically created record(s) B should be coming from a multi select field in the record A BUT if multiple (n) things are chosen in record A then I want also n records and the titles should contain only one of the selected option.
So as an example:
I can choose "Red", "Blue" and "Yellow" in record A. The automation then should create 3 records in Table B:
One titled "Red" one titled "Blue" one titled "Yellow" and NOT 1 record saying "Red, Blue, Yellow".
Is this even possible?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2024 06:59 AM
Yeah it is, you could create an automation that'll take the multiple select field's values and use it in a repeating group like this:
Which would result in this:
Link to base
You mentioned that you want the automation to trigger when a record is created in Table A, and so I assume the multiple select field is fully populated on creation of the record in Table A? If that's the case, you'll notice that in my automation it's set up to trigger when the checkbox field is checked, but you can just change it to "When record created" and it'll work fine
