Tables: Fill in the Blank fields can't be used on Advanced Formula

  • Profile Image
    Asked on February 05, 2021 at 02:09 PM

    Having trouble translating FITB fields to formulas. I have two FITB questions (single choice and dropdown - so, fixed possibilities) which translate to the submissions table, but, when I try to use that data in a formula it doesn't show up as a possibility, even when I expand the column.

    Ultimately, what I want is to install what essentially would be "if" statements, i.e. if

    date = 2/6 and time = 12P a different column would show "s1"

    2/6, 4P = s2

    2/7, 12P = u1

    2/7, 4P = u2

    I feel like I can figure some of this out if i was able to use the data from the FITB question. Please assist!

  • Profile Image
    Answered on February 05, 2021 at 05:22 PM

    Let me escalate that as a feature request so hopefully, that will be considered in the future updates. I can also replicate it in the cloned form too, the Fill in the Blank Fields can't be used in the Advanced Formula. We'll update you here once this is implemented.