Discussions

Expand all | Collapse all

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

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

    Posted 02-12-2019 04:10
    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.


  • 2.  RE: Automatically change a multi-text field upon the input of date

    Posted 02-12-2019 14:25
    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.