How can I change a Multple Choice Text Field based on a Date Field?

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

How can I change a Multple Choice Text Field based on a Date Field being populated (Date fiel going from blank to a date)?

Photo of Sam

Sam

  • 10 Points

Posted 5 years ago

  • 0
  • 1
Sam,

You could solve this using a form rule, however it would only be active while adding or editing a record, not while adding or editing multiple records in grid edit.

http://www.quickbase.com/user-assistance/Default.html#form_rules.html


You could create a form rule that says something like:

WHEN: [Date Field] is not equal to <leave the dropdown blank>

ACTION: change [Multiple Choice Text Field] <to the selected choice from the dropdown>

I hope that helps! Feel free to reach out if you need further help. =]
Photo of Sam

Sam

  • 10 Points
Thanks Eric, That did it!!
You're welcome Sam! Glad it worked!