Tulip Office Hours 07JUN2021 [Table Queries and Aggregations and Microsoft 365 Excel Library App]

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 of the Library, the M365 Excel Unit Test App.

here’s the agenda:

  • June App Competition
  • Table Queries and Aggregations: 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: 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:

we look forward to seeing you there!!

hello all, the recording for the Spanish Office Hours can be viewed here:

topics covered:
0:00 June App Competition
9:00 Table Queries and Aggregations
12:00 Incrementing a Table Record from an App
30:00 Generating Unique ID’s in a Table
40:00 Using LEFT() Function to Create Unique ID’s

hello all, the recording for this week’s Office Hours can be viewed here:

topics covered:
0:00 Introductions
3:00 June App Competition
4:00 Table Queries and Aggregations Demo
9:00 Incrementing Table records from App
12:00 Tulip Library Apps - M365 Excel Unit Test Demo
23:00 Questions - Table Filters
28:00 Questions - Table Records
39:00 Getting Started with Tulip Vision Webinar