--- title: "Create a Table for Station Messages with Query and Aggregation" slug: "create-a-table-for-station-messages-with-query-and-aggregation" updated: 2026-03-23T18:19:42Z published: 2026-03-23T18:19:42Z canonical: "support.tulip.co/create-a-table-for-station-messages-with-query-and-aggregation" excludeFromSearch: true --- > ## Documentation Index > Fetch the complete documentation index at: https://support.tulip.co/llms.txt > Use this file to discover all available pages before exploring further. # Create a Table for Station Messages with Query and Aggregation [Embedded content](https://scribehow.com/embed/Create_a_Table_for_Station_Messages_with_Query_and_Aggregation__v1w3tDqxQpG-V6IYf0NWUQ) Learn how to create a new table in Tulip to store station messages. This guide walks you through setting up a query to find the most recent messages and defining an aggregation to easily access them. 1. Click "Create Table" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/8feed10f-7f5e-4607-bfdb-22d8b022414c/ascreenshot_ac173da717424f0a81302dffc5bed949_text_export.jpeg) 2. Type "Station Messages" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/b1c1470b-ff1f-48bc-96a6-a75d84f10d9e/ascreenshot_4b954fc73749437492b110813bd08d2f_text_export.jpeg) 3. Click "Create" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/4f12252d-29e3-49d2-b519-80e85072c32d/ascreenshot_3b8ca19062974325845506a0e7770f22_text_export.jpeg) 4. Click here. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/989593f2-eed5-4481-b70e-c207b587d823/ascreenshot_b40af576031e4fc3a4570bed4b5905d5_text_export.jpeg) 5. Click this text field. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/c927d1a3-a9a9-44a9-a4e5-c15255e1e4e0/ascreenshot_030aee67bdc84c0b8d15f5ba84735699_text_export.jpeg) 6. Type "Source Station" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/8fcbbfd7-223e-4d8a-af63-503e90d6b94d/ascreenshot_4221a987f5d5478cb96cf67e329dd979_text_export.jpeg) 7. Click "Save" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/74a9ad67-a222-48e0-8b46-5778cc370190/ascreenshot_05c604076c21414cb0f2e1b20d12c0f5_text_export.jpeg) 8. Click this icon. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/f2580f40-a710-4d5a-bb52-22f460af64a8/ascreenshot_e66a77224f9e4830a976646992dd9ff5_text_export.jpeg) 9. Type "Destination Station" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/d5f9f013-078c-4624-af74-b86ae53f5762/ascreenshot_20e622551d7442abb36e7fb25b9c3f4a_text_export.jpeg) 10. Click "Save" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/8e955c1c-0819-4cd7-8c2a-9756d001606e/ascreenshot_81a82676cf434ce9892cdb1347715da1_text_export.jpeg) 11. Click "Queries" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/3e8fec0b-42c3-463c-a609-c69821ea049d/ascreenshot_e8b4dfae29af460faa4642fb27419453_text_export.jpeg) 12. Click "Create New Query" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/9a2bf252-594d-4002-b34c-7dc0966ad5d1/ascreenshot_91f158f6ef004a12b00d0e65139b13e3_text_export.jpeg) 13. Click the "Query Name" field. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/867c2f95-45d7-4838-b924-8853cade9c99/ascreenshot_207060ab38ea4a76a7b8c477411dead3_text_export.jpeg) 14. Type "Most Recent Messages" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/96cfc06a-5236-4535-823b-70927ae4ea9d/ascreenshot_4e51225204494ac68d997aafa1d3864e_text_export.jpeg) 15. Click "Filters (0)" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/67f5d708-9f78-428e-b767-3a5dde2809af/ascreenshot_442c8921f5674fac8dc03e091b9aa2db_text_export.jpeg) 16. Click "+ Add Filter" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/01ee9bfb-0189-4fc2-b509-f2699d8e27be/ascreenshot_45f43a1fee58469d8b04873e389e53c9_text_export.jpeg) 17. Click "ID" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/dd17dc4a-2ebf-4c2e-a0db-e464374865d1/ascreenshot_87f3ba454191410291166849f9ce3df5_text_export.jpeg) 18. Click "Destination Station" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/2e5515c5-ee1f-4fae-9e06-3f8705d3e582/ascreenshot_3ac7bd43322548b58990482b020eec63_text_export.jpeg) 19. Click "Static value" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/9f4e5491-5263-43ea-b223-1ef2c6570a00/ascreenshot_07538815854646a58099c5613a006818_text_export.jpeg) 20. Click "App input" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/3d7ad590-be7e-42ee-b706-87a7c71e912f/ascreenshot_389f6c8f7f314c60b0de2ed72573d545_text_export.jpeg) 21. Click "Sort (0)" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/3d5b03c3-81b2-4794-a87f-9683ec133d6a/ascreenshot_de469f6a887e402fbd1057a2d05e8778_text_export.jpeg) 22. Click "+ Add Sorting Method" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/836fcda8-fb6a-4c8b-b251-fc058277370e/ascreenshot_a185a72b4cac47658896d37ec7e9b48d_text_export.jpeg) 23. Click this icon. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/3d1688a5-a99f-4fcc-9511-d6cae1e0a583/ascreenshot_02a3541ec9f9400cba80ed87aa0381cd_text_export.jpeg) 24. Click "Date Created" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/0bd176b5-6c32-49a2-b0de-278ebecef855/ascreenshot_e02cc072d167416d89a5dcf9787c3264_text_export.jpeg) 25. Click "Sort oldest to newest" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/9e8bff21-61fd-433d-b34f-04334f2fed9d/ascreenshot_d3f876f53fdb40d4808c63a8f250ec07_text_export.jpeg) 26. Click "Sort newest to oldest" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/bfb8a8be-27d9-4013-a011-446c614cfcb9/ascreenshot_29249a723ff34238beac115ce07882c9_text_export.jpeg) 27. Click "Limit (1000)" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/59f636c9-d1af-44de-98e2-82d5da0d9b40/ascreenshot_4b84e6c5cd674828b1a8e30caf8dfcf6_text_export.jpeg) 28. Click this text field. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/6fe349c1-e974-45a2-8f03-9fea819230f7/ascreenshot_fc5336d35afa4d749981965e3ba9bf57_text_export.jpeg) 29. Type " [[Backspace]] [[Enter]]" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/51cd1d25-5041-4ccf-b4bc-75f04c9a0fa0/ascreenshot_4f2b0ee971794976bd91b9c176b9c9f9_text_export.jpeg) 30. Click "Save" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/99d927bc-f608-44ac-8e1a-4096cdca01c3/ascreenshot_27b48b3bcd4542db8dbf66a19dff5759_text_export.jpeg) 31. Click "Aggregations" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/8dde38f1-b5ae-48fa-96ea-7f057500828a/ascreenshot_84284bb62ebf497892ddc25ad8f224a7_text_export.jpeg) 32. Click "Edit" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/b6e9e6c6-20be-4636-b8cd-5325386657ef/ascreenshot_163fb80fdc2845269ef612653babd48d_text_export.jpeg) 33. Click "+Add aggregation" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/2a79bd73-5ff0-4cd7-8a78-a003f395a2f1/ascreenshot_74a7d19f9cb6423ea2c4558154b7b1ad_text_export.jpeg) 34. Click the "Aggregation Name" field. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/f6ba2be0-d33b-4270-9a23-7fb962cc91e9/ascreenshot_b6bd30ee71c743858602529adfed0e20_text_export.jpeg) 35. Type "Most Recent" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/a4a80324-1cab-434d-a40e-55faa4e5733e/ascreenshot_2f9dcf0248424f9882f63ddcb8054d78_text_export.jpeg) 36. Click "Select an option" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/849aae61-d006-499f-873c-7f14efc08e9f/ascreenshot_a2f4cfa5daf146fd83bdc4200e1aa615_text_export.jpeg) 37. Click "Mode" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/aa9422b7-b7af-4e1b-b946-088f8f3500e5/ascreenshot_3ebb652b2bf14725ba69b51f9400903b_text_export.jpeg) 38. Click "Select an option" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/36649a3a-dfed-4a0e-ac95-4fe38f1292fd/ascreenshot_654a3bfff36a42aeb1e17f6a40a7384d_text_export.jpeg) 39. Click "ID" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/f32ff8a2-d6e9-4eff-ad79-47aa3120152a/ascreenshot_dff90b67021d494abaae9cbc90fc91d1_text_export.jpeg) 40. Click "Save" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-23/6b458a6e-5429-421d-ab0a-58e4760071d3/ascreenshot_45e1959ee1c24d9eaf734f727dae46b7_text_export.jpeg)