Text Field with Current Year
Hello, I'm trying to create a text field called "Reporting Year" where users can only enter numerical values for a year (i.e., 2023). Also, I need the field to be auto-populated with the current yea...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendMy suggestion is to keep this as a numeric field, and reconsider why you think you need to make it a text field. That way the native Quickbase behavior will ensure that only numbers are entered in the numeric field.
then you can make a formula numeric field called [current year] with a formula of
Year(Today)),
And then make a dynamic form rule that says when the year field is blank, changed the year field to the value of the field current year
Hey Mark,
That's a smart idea, I didn't think of that. I just did what you suggested and it now works. 🙏 Now I just have to figure out how to get my form rule to only run when the page loads and not when the user changes what's in the field.