Forum Discussion

MattMakris's avatar
MattMakris
Qrew Cadet
4 years ago

How to build a multiple choice field of date ranges based on the start date and end date in a table

I have a content management app that my writers log each piece of web page content they write in. There are two tables that are related to the "Clients" table, so that we can track all of the content we write for each of our clients.

1. Content Allocations
Each record defines the type of content that the client gets each deliverable cycle (monthly) - ie- blog, informational content, social post, etc.

2. Content Deliverable Document
Each record represents a piece of content that the writer published for the client. It is related to the content Allocations. ie- blog content will be logged in the "Blog" record in the "Content Allocations" table.

Here's my issue: I need to add a multiple choice dropdown called "Deliverable Cycle" in the "Content Deliverable Documents" table. The writer would use this to select the deliverable cycle that is related to the content they logged. It would look something like this:

4/1/2021 – 4/31/2021
3/1/2021 – 3/31/2021
2/1/2021 – 2/31/2021
1/1/2021 – 1/31/2021
...

The Content Allocations (parent) table contains "Deliverable Cycle Start Date" and "Deliverable Cycle End Date"  fields. How can I create a dynamic dropdown where the writer could select the appropriate cycle date range?





------------------------------
Matt Makris
------------------------------

1 Reply

  • Instead of a Text Multiple Choice field, I would create a Content Cycles table that would have 2 fields on it - Cycle Start and Cycle End. Cycle Start would be a Date field and Cycle End would be a Formula Date Field - LastDayOfMonth([Cycle Start]). Set the Cycle Start as your Key field and then build relationships to the other relevant tables. You'll probably also want to build a report on the Cycle table that shows a limited number of options as the year progresses and set the drop-down element on your form to use that report.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------