Filter by one column and show another?

  • joncwhall

    (@joncwhall)


    9 years, 8 months ago

    Hi,

    Is it possible to filter by one column and show another with the CFDB shortcode?

    I want to show the result of another field from the most recently filled in form.

    So, filter by max ‘Date’ or ‘submittime’ but then show the corresponding ‘Field’ result.

    Any help would be greatly appreciate 🙂

    Thanks,

    Jon

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    9 years, 8 months ago

    Use “filter” to select the entries you want. Use “show” to indicated which fields to display.

    Thread Starter joncwhall

    (@joncwhall)

    9 years, 8 months ago

    Hi Michael,

    Thanks for that, but so far I can only get doing that to find the max of the shown value, not the hidden one.

    I currently have:

    [cfdb-value filter=”Submitted Login=$user_login” form=”Assessments” function=”max” hide =”submit_time” show=”Percent”]

    And I would like that to find the max submit_time and show the corresponding Percent value.

    Is this possible?

    Thanks,

    Jon

    Plugin Author Michael Simpson

    (@msimpson)

    9 years, 8 months ago

    [cfdb-value form="Assessments" show="Percent" filter="Submitted Login=$user_login" limit="1" orderby="submit_time DESC"]

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Filter by one column and show another?’ is closed to new replies.