Forum Discussion
JeffPeterson1
3 years agoQrew Captain
You can use 'another field' as the source of the list. I believe you can just use a formula text or numeric field to generate the list of valid dates and populate the multiple choice field from that.
------------------------------
Jeff Peterson
------------------------------
------------------------------
Jeff Peterson
------------------------------
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
------------------------------
- ChrisSwirtz33 years agoQrew MemberThat'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
------------------------------- 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
------------------------------