How to export with transform function

  • Resolved luntereiner

    (@luntereiner)


    9 years, 1 month ago

    I don’t find/use the right way to use that feature.

    I’ve 3 columns that I want to concatenate. But before I’ve tested with a simple

    last_name=strtoupper(last_name)

    and the excel sheet is empty. Without that transformation, the data are extracted.
    I put last_name=strtoupper(last_name) in the field “transform expression”… where am I wrong ?
    All indications for the transform feature is shortcode oriented no literature for the export feature.
    Thanks for all.

    https://www.ads-software.com/plugins/contact-form-7-to-database-extension/

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

    (@msimpson)

    Transforms work on exports the same as short codes.

    In the short code builder page, you could make an export link:

    [cfdb-export-link form="your form name" trans="last_name=strtoupper(last_name)"]

    Thread Starter luntereiner

    (@luntereiner)

    Ok, but I have to set in the option panel the option “Allow Any Function in Short Codes” to true prior to any export.

    Plugin Author Michael Simpson

    (@msimpson)

    That’s odd because strtoupper should be allowed by default.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to export with transform function’ is closed to new replies.

Tags