Submission History Module

[alexh]

So I think the Submission History module is pretty darn useful (and cool).

I do have a question though..

Where is that data stored? I was thinking about pulling the "Last Modified by" name out and printing it on a page. For example, I am going to be using formtools for employees to post press releases on our website, and the php page I created pulls the data out from each submission and prints it on the page.. but it would be nice to put a "Last Updated by: John Doe" at the bottom.

Is this do-able? I guess I just need to know where the data is stored.

-Alex

[Ben]

Hi Alex,

Sorry for not getting back to you!

The Submission History table works by making and maintaining a copy of your submissions form, with a few extra fields in it. If your form ID was 5 (and your DB prefix ft_), your main submission table would be called ft_form_5 and the history table would be ft_form_5_history.

Unlike the main submissions table, the history tables logs multiple records for each submission. Each record logs a particular change to a submission. So that's where your history data is stashed.

If I were you, I'd take a look at the module's functions and see if there's anything in there you can re-use. This function in the /modules/submission_history/global/code/code.php file looks especially promising!

Code:

$info = sh_get_last_submission_history_row($form_id, $submission_id);

- Ben

[alexh]

Thanks Ben! Once I get all my other bugs worked out, I'll see what I can do with this!

Thanks,
Alex

[Hannes]

Hello Ben,

for me the Submission History Module is unfortunately not working in a freshly installed 2.1.0-beta-20110730.
The tables exist in the database but whenever I start the module I get the message:

Code:

Notice: Undefined index: sh___history_id in C:\apache\htdocs\formtools\modules\submission_history\global\code\code.php on line 725

When clicking "Create History Tables" there is no reaction.

When viewing a submission I can see the blue history box which is showing:

Code:

There is no history logged for this submission.

Hope you have a solution for this.

Have a nice sunday.
Hannes

[Ben]

Huh! Good to know, I'll check it out!

Thanks, Hannes!

- Ben

[Ben]

Hi Hannes,

Mind trying upgrading to the latest version of the module (1.1.1)?

Should be fixed now.

- Ben

[Hannes]

Hi Hannes,

Mind trying upgrading to the latest version of the module (1.1.1)?

Should be fixed now.

- Ben

Yep, it's fixed and working perfectly now. Thanks a lot for the fast upgrade.