Forum Discussion
BlakeHarrison
4 years agoQrew Captain
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/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------