Hello Brett.

Thank you for your interest in our plugin.

You can certainly create tables from XML, you just have to look out at the format. wpDataTables presently accepts this, and only this, format of XML: A single root node with several child nodes (one level), where each child node will be treated as a row, and the child row attributes as cells. If your software does not return this format you would need to prepare, as an example, some type of PHP adapter to return one of the formats that wpDataTables would accept.

As for calculating the time in between start and date - I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features. Please read our documentation about Formidable Forms integration add-on. There you can see all features and limitations of this add-on.

Could you show me what the form looks like, and maybe I can try and find a workaround for you?

Best regards.

Hello Brett.

I replicated your Form on my end, and I'm sorry to say that doing this is not possible with plugin's built in features.

The form would create two separate columns and conditional formatting between columns is not possible at the moment. You could add a formula column but it only works for integer and float columns, not time, datetime, string, etc.

What you'd need to do to make this possible is to pull the data in a new database table directly from the Formidable database using PHPMyAdmin - basically create a new table in PHPMyAdmin, where you'd convert time to integer, add a new column which would calculate the time difference, and then convert it back to time.

It is very hard to achieve what you're looking for.

Sorry for any inconvenience.

Best regards.