Show a customer's purchase

1. Update Container 4:

Action Item:

• Click on the text14 box and change the value to:

  • ##### Recent activity since last purchase

Retool sample users page

2. Update table3:

Action Item:

• Click on the table below text14 and make sure it says table3.

• Under the Data section in the far right nav bar, update the field to display the results from CustomerPurchases by putting {{CustomersPurchases.data.results}}:

Retool sample users page

3. Under the resource query, CustomerPurchases, update the Body section:

Action Item:

• Under the Body section, make sure it's JSON.

• Add parameters key with the value [ { "name": "userid", "type": "string", "value": {{table1.selectedRow.data._id}} } ]

Retool sample users page

4. After you're done, click on a row in table1 and Run the CustomerPurchases query:

Retool sample users page

5. When you’re done, the table should be populated. I highlighted the Data section and table3 to show you what it should look like:

Retool sample users page

NOTE: You can find us on the Rockset Community if you have questions or comments about the workshop.