TULIP DOCS (LTS4)Record History Widget
The Record History widget allows you to view the history of any table record that has been loaded into an app that is running in the Tulip Player.
It is commonly used to view the history of batches, materials and subassemblies.
You can view one record at a time within the widget.
A Tulip user will typically build an app called "Review and Approval" that is meant for another Tulip user from the quality department.
The member of the quality team will view the history record for a recently completed batch, and then sign their approval. This will complete the app and log their official approval.
So, this widget is commonly used in combination with these other features:
Since records can be modified in both the Player and the Tables admin interface, the Record History Widget includes events from both sources.
Fields
These fields are used to customize the widget within the App Builder
| Name | Description |
|---|---|
| Linked Placeholder | The record placeholder that will populate the widget when used in the Player |
| Enable Printing (optional) | A boolean option that determines whether the record history can be printed within the Player |
| From Date (optional) | The earliest date to show updates to record history in Player |
| To Date (optional) | The latest date to show updates to record history in Player |
Data Recorded
These are the data that are recorded any time a table record is updated. Every data point will be shown in the widget whenever a new record is loaded.
From Table Admin Interface
| Name | Description |
|---|---|
| User Name | Name of the user that updated the record |
| Type of Change | Whether the user created, updated or deleted the record |
| Changed Fields | The fields that were changed before the user pressed "Save" |
| Changed Values (Old) | The values in the record before the change |
| Changed Values (New) | The values in the record after the change |
| Timestamp | The datetime when the user pressed "Save" |
From Player
Note: The user must complete the app in order to capture all data points related to that run of the app.
Note: Only variables that are marked as "Save for Analysis" in the Variables dialog in the App Builder will be included in this summary.
| Name | Description |
|---|---|
| User Name | The user that opened the app in the Player |
| App Name | The app where the record was modified |
| Version | The version number of the app that was being run |
| Station Name | The name of the station where the app was run |
| Step Name | The name of the step where the record was modified |
| Step Open Timestamp | The datetime when the step was opened |
| Type of Change | Whether the user created, updated or deleted the record |
| Changed Fields | The fields that were changed with each trigger that was run |
| Changed Values (Old) | The values in the record before the change |
| Changed Values (New) | The values in the record after the change |
| Record Change Timestamp | The datetime when the trigger was run that modified the record |
| Variable Name List | The list of variables with values at the time that the app was completed |
| Variable Values | The value of each variable at the time that the app was completed |
| Variable Update Timestamp | The timestamp that the step was changed after variables were modified. |
| Signature Name | The text label of the signature form that was filled out during the same run of the app |
| Signer | The username and ID of the user that signed the Signature Form |
| Signature Timestamp | The timestamp when the user changed the step from the Signature Form Step |