Tulip Docs

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

Name	Description
Table	The Tulip Table from which the record can load values and into which the Tulip Table can store values.
Placeholder	The name of the record as it will appear inside the trigger editor.
Places Used	The 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.

Name	Description
Clear All Record Placeholders	Clears all placeholders in an app, does not affect the related Tables or Fields. Resets all placeholders, similar to completing and app.
Clear Record Fields	Given a record name (placeholder) a user may clear the record, making all fields blank.
Clear Record Placeholder	Remove the connection between a record placeholder and a record. The placeholder will now be empty.
Create Record	Given 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 Record	If 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 Record	Given 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 Record	Choose a Linked Record field within a specific record placeholder, and then choose the record ID to link to that field.
Load Record	Given 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 Record	Choose a Linked Record field within a specific record placeholder, and then choose the record ID to unlink from that field.

Tests

ID	Name
QA-T98	Record Placeholders : 04 - Load Table Records Trigger, and Table Record Widget
QA-T99	Record Placeholders : 05 - Create and Load Table Record Trigger
QA-T100	Record Placeholders : 06 - Table Data Tab
QA-T101	Analytics - Table Analytics
QA-T102	Record Placeholders : 01 - Add a record placeholder to an app
QA-T103	Record Placeholders : 02 - Edit a record placeholder in an app
QA-T104	Record Placeholders : 03 - View the table for a record placeholder
QA-T134	Record Placeholders : 08 - Delete Record Placeholder
QA-T234	Variable Widget : 08 - Table Records Can be Styled
QA-T243	Embedded Tables : 03 - Connect an embedded Tulip Table to a Table record
QA-T514	Timer Widget : 03 - Target Time with Table Records and Static Values
QA-T517	Input Widgets : 08 - Linking Tulip Table Records
QA-T538	Table App - Run the 'Table App' application
QA-T568	Dev Mode - Variables and Table Records
QA-T596	Widgets - Record History Widget
QA-T709	Record Placeholders : 01 / Record Placeholder Validation works
QA-T710	Record Placeholders : 02 / Record Placeholders' names must be unique and can't be left blank
QA-T923	Embedded Tables : 03 / Only matching record placeholders can be selected
QA-T981	Analytics - Table Analytics (cloned)

Requirements

No requirements