+5Hello,
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 year (i.e., 2025); if the users wants to change this, they can do so.
I haven't been able to completely figure this out on my own, so I appreciate any help on this. Thanks in advance!
+24My 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
+24You should be able to have a form rule that fills in that field only when it is blank. That way if the user wants to change the value of the form rule won't fire.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
