Search
K
Comment on page

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.