thanks for reaching out @boston85719
@realtimb6 do you plan to do the data on a fixed day of the week for each company?
I feel like a calendar would be nice for this. but
it also sounds like a performance review app I’ve put together that uses a timeline chart. I upload the data of performance scores in a once per week manner. then I view the data in a timeline chart.
do you have a visual example of what you are trying to build, either from your app or another on the internet?
using a calendar, you could simply filter the calendar events for each given company, save sales data as a calendar event
this is the possible event model in terms of total editable fields. each of the starred fields could hold a piece of information or even a reference number to another database entry that has lots more pieces of information.
it will not find the closest date if the date you select has no events to see.
I fee like the easiest solution would be to create a list of dates in which data was submitted, filtered by the relevant company. I would use that as the data source for a drop down.