Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoA multiple-choice field it's kind of the expedient method for offering choices. I get more control if you go the extra step and make it a relationship. You can transition existing data by making the key field of your choices table a text or a numeric field with all the values in your current multiple-choice field.
Then make the relationship to the existing detail record table based on what was your multiple choice field.
Then you can make a report of the valid years and set the form properties for the drop down choice to use that report.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Then make the relationship to the existing detail record table based on what was your multiple choice field.
Then you can make a report of the valid years and set the form properties for the drop down choice to use that report.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
ChrisSwirtz3
3 years agoQrew Member
That's what I thought as well Mark. However, I started this and got stuck. I created a new table called "Year" and created a Numeric field of the same name. Then I created a record for each year starting with 2022 out to 2050 for now. But these are numbers not actual "Years", so when I went to make the report thinking could filter the list to only show records where the Year is during or after the current year, that wasn't an option because I wasn't using a date field. But date fields show more than just the year, so how do I produce just a list or records showing just the year to then use as the list for the drop down on the Parent record? I expect I am missing something simple.
------------------------------
Chris Swirtz
------------------------------
------------------------------
Chris Swirtz
------------------------------
- MarkShnier__You3 years ago
Qrew Legend
I gotta a run now but you could make a checkbox formula field called Ok for report ?
[year] >= Year(Today())
And filter the report where that box is checked.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------