Hey Michael

Thank you for your purchase, and sorry for the late response.

Unfortunately, something like this is not possible with the plugin's built-in features. The ID is being added in rows, not columns, and there's no PIVOT option in wpDataTables, so you couldn't do that either.

You would need to create a Pivot table in the database; then prepare a MySQL view (a stored query), which will return the data from that Pivot table, call it e.g. “view1” and then build a wpDataTable based on a simple query like “SELECT * FROM view1″.

However, I am not sure that this would help you out, but you can try.

Hi again Michael

I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.

Tables linked to an existing data source are not database tables (all except for MySQL Query-based tables), so there's no way to query them.

Gravity Forms' entries are stored in the database, but they are split into several database tables, and wpDataTables' integration add-on for Gravity Forms constructs a dynamic MySQL query in the back-end which pulls the data from the forms. This query is not accessible, nor is it alterable, so you can't use it.

If you know your way around MySQL, you could construct your own query which would pull the data from Gravity Forms' database tables, but this is not a simple task.