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.
|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.|
Record Placeholders can be used in Triggers, similar to Variables. There are also additional clauses and actions that apply only to Record Placeholders.
The following are possible actions are available from the 'Table Records' menu option within the 'Then' clause of a Trigger.
|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.|