Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Automatically change a multi-text field upon the input of date

Hi all,

I'm trying to do an automatic change of Text-Multiple Choice based on the date entry.

For example,

[Text-Multiple Choice] has 4 options -> 1st/ 2nd/ 3rd/ 4th

If [Date 1] is filled, change [Text-Multiple Choice] to 1st
If [Date 2] is filled, change [Text-Multiple Choice] to 2nd
If [Date 3] is filled, change [Text-Multiple Choice] to 3rd
If [Date 4] is filled, change [Text-Multiple Choice] to 4th

Additionally, [Date 2] should have precedence over [Date 1], [Date 3] over [Date 2]........

Right now I want to use the Kanban report to track some of the processes going on, I can only choose the card groups based on [Text-Multiple Choice]. Furthermore, the formulas for Date fields are only based on "today", "day(s) in the past", "tomorrow", etc.

Any help would be appreciated!

Thanks.
Forms
Formulas and functions
Quickbase Automations
  • JordanMcAlister's avatar
    JordanMcAlister
    Qrew Captain
    7 years ago
    I don't think Multiple Choice has a formula field version, but you could set it as a formula text with this formula (not tested):

    If(
    not IsNull([Date 4]), "4th",
    not IsNull([Date 3]), "3rd",
    not IsNull([Date 2]), "2nd",
    not IsNull([Date 1]), "1st"
    )

    In this case, it will check [Date 4] first and if its filled in, it will output the text you want in place of "4th."

    If you still wanted it to be a multiple choice field, you could set up an automation or action for this where when [Date *] gets filled in, input "1st, 2nd, 3rd, or 4th" in your multiple choice field, but that won't have the precedence requirement, so I think the formula text is your best bet if you want it to be completely automated.