# Tulip Office Hours 07JUN2021 \[Table Queries and Aggregations and Microsoft 365 Excel Library App\] **URL:** \ **Category:** General\ **Tags:** office-hours\ **Created:** [June 8, 2021, 4:34pm UTC](https://community.tulip.co/t/tulip-office-hours-07jun2021-table-queries-and-aggregations-and-microsoft-365-excel-library-app/2878 "2021-06-08T16:34:39Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [June 8, 2021, 4:34pm UTC](https://community.tulip.co/t/tulip-office-hours-07jun2021-table-queries-and-aggregations-and-microsoft-365-excel-library-app/2878/1 "2021-06-08T16:34:40Z")
hello all, we’re looking forward to this week’s Office Hours!! this week, we’ll be sharing one useful way to leverage Table Queries and Aggregations in your Apps. we’ll also be looking at an exciting App that was included in [Release 17](https://community.tulip.co/t/library-release-17-may-2021/2698) of the Library, the [M365 Excel Unit Test App](https://tulip.co/library/apps/m365-excel-unit-test/). here’s the agenda: - **[June App Competition](https://community.tulip.co/t/june-2021-app-competition-device-connected-to-tulip/2835)** - **[Table Queries and Aggregations](https://community.tulip.co/t/using-table-aggregations-in-if-statements-on-triggers/2852)**: Table Queries and Aggregations can be used in your Apps to determine workflows for your Apps. in this simple example, we’ll show how you can use the results from Aggregations in the if statement of your Triggers to determine workflows. - **Incrementing Table Records from an App** : information stored in Tables often needs to be manipulated from Triggers in your Apps, in this demo we’ll showcase how you can use “Data Manipulation \> Increment” in your Triggers to easily manipulate information stored in your Tables!! - **[M365 Excel App](https://tulip.co/library/apps/m365-excel-unit-test/)**: this Unit Test App in the Library allows you to connect and pull data from your Microsoft Excel spreadsheet into Tulip. join to learn how install the App so you can get connected to Microsoft Excel!! following the demo, we’ll be opening it up to Q&A. if you have questions, add them as comments here below and we’ll address them in the order in which they were received. if you don’t have specific questions, join the session and view how other users are building apps for their shop floor. please complete one of these forms if you’d like to join Office Hours: - [Wednesday 15PM EST (Spanish)](https://tulip.co/office-hours-es/) - [Thursday 11AM EST](https://tulip.co/office-hours-est/) - [Friday 10AM CET](https://tulip.co/office-hours-eu/) we look forward to seeing you there!! ---
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [June 9, 2021, 7:16pm UTC](https://community.tulip.co/t/tulip-office-hours-07jun2021-table-queries-and-aggregations-and-microsoft-365-excel-library-app/2878/2 "2021-06-09T19:16:04Z")
hello all, the recording for the Spanish Office Hours can be viewed here: [![](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/d/d33f4a79579259ee0d59e4b39df3c3bfa24dfc8f.jpeg "Tulip Office Hours") ](https://www.youtube.com/watch?v=4skYNRv8c8A) topics covered: [0:00](https://www.youtube.com/watch?v=4skYNRv8c8A&t=0s) June App Competition [9:00](https://www.youtube.com/watch?v=4skYNRv8c8A&t=540s) Table Queries and Aggregations [12:00](https://www.youtube.com/watch?v=4skYNRv8c8A&t=720s) Incrementing a Table Record from an App [30:00](https://www.youtube.com/watch?v=4skYNRv8c8A&t=1800s) Generating Unique ID’s in a Table [40:00](https://www.youtube.com/watch?v=4skYNRv8c8A&t=2400s) Using LEFT() Function to Create Unique ID’s ---
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [June 10, 2021, 5:13pm UTC](https://community.tulip.co/t/tulip-office-hours-07jun2021-table-queries-and-aggregations-and-microsoft-365-excel-library-app/2878/3 "2021-06-10T17:13:01Z")
hello all, the recording for this week’s Office Hours can be viewed here: [![](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/b/b1529e6941735efc83a6f70d62eb415fc7a4be28.jpeg "Tulip Office Hours 10JUN2021 [App Competition, Excel App, and Table Records]") ](https://www.youtube.com/watch?v=jZhxAfLzgaE) topics covered: [0:00](https://www.youtube.com/watch?v=jZhxAfLzgaE&t=0s) Introductions [3:00](https://www.youtube.com/watch?v=jZhxAfLzgaE&t=180s) June App Competition [4:00](https://www.youtube.com/watch?v=jZhxAfLzgaE&t=240s) Table Queries and Aggregations Demo [9:00](https://www.youtube.com/watch?v=jZhxAfLzgaE&t=540s) Incrementing Table records from App [12:00](https://www.youtube.com/watch?v=jZhxAfLzgaE&t=720s) Tulip Library Apps - M365 Excel Unit Test Demo [23:00](https://www.youtube.com/watch?v=jZhxAfLzgaE&t=1380s) Questions - Table Filters [28:00](https://www.youtube.com/watch?v=jZhxAfLzgaE&t=1680s) Questions - Table Records [39:00](https://www.youtube.com/watch?v=jZhxAfLzgaE&t=2340s) Getting Started with Tulip Vision Webinar