Promo Inventory on Website

[bssmaster8]

I am trying to create a base/table to track promotional inventory on a website.

• There is a set amount of inventory at any given time
  • 3 Hero Images
  • 3 Banners
  • 5 Tiles
• My goals
  • track which promotions we have running at a given time 
  • Track the usage of each promotional element
  • Limit usage of a given element if we are oversold

Currently I have a table with the following fields

• Name
• Start Date
• End Date
• Placement (Multi Select with each element)
• Details (Long Text)

[TheTimeSavingCo]

re: track which promotions we have running at a given time 

What issues did you face with doing this?  This is difficult to help with as it's quite tied with your business logic, so if you can talk about the problems you're having that'd be useful

---
re: Track the usage of each promotional element

I'd recommend a table where each record represents the Start <> End usage of a single element for this, and a table where each record represents a single element:  

---
re: Limit usage of a given element if we are oversold

This one's tricky.  You're going to need to either eyeball the usage yourself via a Calendar / Timeline element before creating the records, or create a system to help you check whether new sales you make have any conflicts with existing usage and then reject stuff

[bssmaster8]

Sounds like I am on the right track. I currently have a table with each record being a promotion with start and end dates. Now it sounds like I will need another table with records being each element then link the promotion to the element.

Where things get tricky is I then want to be able to limit each element to only 1 promotion at a given time. So something would need to move them on and off. Additionally I would like a way to alert me if I'm trying to add too many promotions to a given element at a specific time. Maybe a formula?

[TheTimeSavingCo]

re: Additionally I would like a way to alert me if I'm trying to add too many promotions to a given element at a specific time. Maybe a formula?

Hmm yeah, I can't think of how to do this with a formula I'm afraid.  I'd either eyeball it with a Calendar/Timeline view or write a script for it