specs/models/M_APP_VER_RECD

Record Placeholder

A record placeholder is a pointer to a record (i.e. row) in a Tulip Table. The connection to the table is made by loading a record by the ID field. Updates to a record placeholder will update the source table in real time. In other words, all changes made in the app will be immediately reflected in the source table. This also applies to changes made to the record from the Table Editor. Changes made in the editor will display in any apps that have the affected records loaded.

Fields

NameDescription
TableThe Tulip Table from which the record can load values and into which the Tulip Table can store values.
PlaceholderThe name of the record as it will appear inside the trigger editor.
Places UsedThe widgets and triggers that reference this Table Record Placeholder. These references must be deleted before the Table Record Placeholder can be deleted.
Save for Analysis?A boolean value that indicates whether the loaded table records will be saved in the app completion record. "On" by default.

Triggers

Record Placeholders can be used in Triggers, similar to Variables. There are also additional clauses and actions that apply only to Record Placeholders.

Actions

The following are possible actions are available from the 'Table Records' menu option within the 'Then' clause of a Trigger.

NameDescription
Clear All Record PlaceholdersClears all placeholders in an app, does not affect the related Tables or Fields. Resets all placeholders, similar to completing and app.
Clear Record FieldsGiven a record name (placeholder) a user may clear the record, making all fields blank.
Clear Record PlaceholderRemove the connection between a record placeholder and a record. The placeholder will now be empty.
Create RecordGiven a record, a user may save that data into the corresponding Tulip Table, therefore creating a new entry in the Tulip Table or updating an existing one.
Create or Load RecordIf an ID does not exist in the table yet, create it and create a new row, otherwise, load the existing row with that ID.
Delete RecordGiven a text identifier, a user may delete a record, removing the entry that corresponds to the record in the associated Tulip Table. It can still be viewed later in the History Widget.
Link RecordChoose a Linked Record field within a specific record placeholder, and then choose the record ID to link to that field.
Load RecordGiven a record name (placeholder) and a text identifier, a user may load the values that correspond to the text identifier from a Tulip Table into a record.
Unlink RecordChoose a Linked Record field within a specific record placeholder, and then choose the record ID to unlink from that field.

Tests

IDName
QA-T98Record Placeholders : 04 - Load Table Records Trigger, and Table Record Widget
QA-T99Record Placeholders : 05 - Create and Load Table Record Trigger
QA-T100Record Placeholders : 06 - Table Data Tab
QA-T101Analytics - Table Analytics
QA-T102Record Placeholders : 01 - Add a record placeholder to an app
QA-T103Record Placeholders : 02 - Edit a record placeholder in an app
QA-T104Record Placeholders : 03 - View the table for a record placeholder
QA-T134Record Placeholders : 08 - Delete Record Placeholder
QA-T234Variable Widget : 08 - Table Records Can be Styled
QA-T243Embedded Tables : 03 - Connect an embedded Tulip Table to a Table record
QA-T514Timer Widget : 03 - Target Time with Table Records and Static Values
QA-T517Input Widgets : 08 - Linking Tulip Table Records
QA-T538Table App - Run the 'Table App' application
QA-T568Dev Mode - Variables and Table Records
QA-T709Record Placeholders : 01 / Record Placeholder Validation works
QA-T710Record Placeholders : 02 / Record Placeholders' names must be unique and can't be left blank
QA-T923Embedded Tables : 03 / Only matching record placeholders can be selected
QA-T981Analytics - Table Analytics (cloned)

Requirements

No requirements