I want to parse text date entries from a single record into calendar date entries so that a calendar view can be used to visualize the dates.
We have our sales records entered by product, so each individual product gets a separate entry, with multiple “dates”. For example: Email Ad | 1/1, 1/2, 1/3 (etc). The “dates” are referencing another table with text records created for each day of the week that product can be sold. I want to be able visualize all of the dates that product is sold on, and see which record it is. So on a calendar I would see 1/1: COMPANY A, COMPANY B 1/2: COMPANY B, COMPANY C (etc)
an example of a sales entry:
I am trying to set up an automation whereby as soon as a product is entered with the dates added, new records for each date are created on another table (so first entry is 1 product with 5 dates, then the automation creates 5 matching records for the 5 dates as individual calendar dates, so the calendar view can be used). So, what I need is a way to parse those text dates as individual dates on a calendar.
Does this make sense? Is such a thing possible?