Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Creating an automation that separates multiple dates into corresponding records in a different table

Topic Labels: Automations
310 0
Showing results for 
Search instead for 
Did you mean: 

Hi there,

In an opportunity table I have made a look up field that collects multiple delivery dates of a product into a single cell.

When a condition is changed in the Opportunity Table (to ‘opportunity won’ or ‘sale’) a record is created in the Delivery Schedule Table based on the dates from that cell In the Delivery Schedule Table. The number of records created should correspond to the number of dates from the cell in the Opportunity Table.

But no records are created when there are more than one dates.

Is there a way around this somehow?

0 Replies 0