How to create a table that only shows the changes

[vinnie]

My main table is called ProductsTable.

Accessing Changes: To see all the changes made, use ProductsTable.changesetArray.

Creating a New Table: This changeset array is the starting point for your new table.

• Delete Unwanted Columns: Remove any columns that come from the new table.
• Add New Columns: Click the + button to add new columns.
• Automatic Recognition: As you make changes, Retool will detect them and set things up for you. See the video for more detail.

Important Notes:

• Primary Key: Whatever you choose as the Primary Key in your original table will appear in the changesetArray. In this example, it's "ID."
• Column Source vs. Label: The original table might have columns labeled one thing, but its actual source might be something different. This will be in the changesetArray, not the original table column label. In this example, the source (from my API query) for the Description column in ProductsTable is actually short_description.

This video should help demonstrate - Creating a Record Update Table in Retool - Album on Imgur