I am building a subscription center with the webform pay and the webform mysql views. When building a view, or looking at the database view it does not contain all the payment information fields separate. What it creates is a concatenated field that contains the name, credit card number, expiration date, payment amount all as one field. I cannot use it this way. Is there an easy way to expand this module to build the view correctly even though the form does not contain all those as separate fields? I have looked at the webform results in the database and it is storing the information separate. I think the issue is that the field is called payment information so it just combines everything.

To duplicate this issue:
Download webforms version 3
weforms pay version 6.x.1.0-alpha3
webform mysql views 6.x-1.2

Create any form with webform pay. Then submit some data. Use the webform mysql view and you will see in a view that the payment information is all concatenated together.

Comments

quicksketch’s picture

quicksketch
he/him
commented

Apparently this module would require special functionality for Pay components, similar to the special functionality (I think) that was introduced in #1026208: Grid component values not displayed in a usable fashion for Grid components.

cafuego’s picture

cafuego commented

By far the easiest way to do this is I think is to use the views_customfield module and add a PHP Code field with a bit of code to explode the serialized webform_pay data.