Build a Fishbowl Purchasing Dashboard with AI (Open & Late POs, Top Vendors)
A Fishbowl purchasing dashboard built live with AI: open and late POs and your top vendors, straight from your live database.
Read the full write-up, with the steps and screenshots →
Transcript
Auto-generated from the video. Timestamps jump to that moment in the clip.
- 0:06Hello and welcome. In this video, we're going to be making a dashboard for our purchasing department.
- 0:13So I've got my display, and on the left here I've got Claude, and on the right here I have my
- 0:18quote -unquote TV.
- 0:20And the purchasing department needs a dashboard for them to use inside their office, and we're
- 0:25going to do that for them.
- 0:27The first step is we need to...
- 0:28to adopt this TV into the platform and we've got a code here so I'm going to
- 0:32instruct the MCP to do that. Adopt enable
- 0:38TV code 2BUYAX.
- 0:52Let's call this purchasing.
- 0:57pit TV and and no
- 1:02pages right now
- 1:09okay so this one is what's interesting about this TV is that this this
- 1:14team is
- 1:14in Los Angeles so set the location to Los Angeles
- 1:19California
- 1:31We'll see some weather here in a second when we have our first metric to show.
- 1:35First thing, let's take a look at how many open POs we have.
- 1:38Make a metric for how many purchasers
- 1:44we have open right now.
- 1:53Okay, perfect, we've got our weather, we've got our open purchase orders, let's keep going.
- 2:00I need a metric for how many POs,
- 2:05open POs, are past their due date.
- 2:11Let's see what that gives us.
- 2:19Okay, look.
- 2:20like we've got 40 open purchase orders and 36 of them are past due okay let's
- 2:26let's take a look at how many POs did we issue
- 2:31today
- 2:39oh okay so see it answered me I should tell it that I want to add it as
- 2:45a metric
- 2:46to the T the dashboard to the page
- 2:57okay so we've got six that's good now let's
- 3:03add a chart of vendors add a bar
- 3:08chart of top my open
- 3:13PO dollars
- 3:21Okay, amazing, that looks pretty good, let's continue.
- 3:25Now add a small table listing the oldest
- 3:31past due POs, PO number, vendor,
- 3:37due date, oldest
- 3:46amazing we've got that little table there great and one thing
- 3:51you know and sometimes you know
- 3:53there might be a message that we need to put in front of the purchasing team to remind them
- 3:58something they see every day we could say a and b distribution
- 4:04closing for one month starting
- 4:08december 15th
- 4:12you know, and that could be a message that's just displayed on TVs or all TVs.
- 4:17But it could be something that is just part of the conversation that they'd be having
- 4:21inside a company and you want to remind some other people and, you know, we
- 4:26can do things
- 4:26like this. If this is something that you're interested in your fishbowl and want something
- 4:31for your team, give us a shout. Love to show you how we can get this in front of your team
- 4:36and we'll talk to you soon. Thanks. Bye.
- 4:40Thank you.