Some questions on functionality for my case

Hi all,

I have a pretty particular case that i need a solution for.
I own a small retro game store where i buy and sell games on a few locations (ebay, webshop, in the store itself etc…) .

So there have been occasions where i sell a game in the store or at a convention.
Forget the same game is online (on ebay or another POS).
And the same game get’s sold online.
Now most items i have are unique and i don’t have a large stock of them.
So i end up having to cancel the online order, very annoying and something i wan’t to avoid as much as possible.

Now i have created a list of the items i have online with airtable, based on the barcodes that are on these pieces. So when there is a new item that arrives in my stock i scan the barcode, enter the title, and when i put it online i have a checkmark ‘online’.

The idea is when i sell the game at a ‘real-life’ location (convention or shop) i use the ‘find’ function, scan the code and if it shows op in the list with checkmark ‘online’ i mark it as sold. And when it’s sold the game moves to the ‘sold’ list. So at the end of the day i can see what games i have sold in a list and get them offline and adjust the quantity i have in stock.

A bit hard to explain but it’s actually all pretty simple.

And i actually managed to get something like this working with airtable. Now it’s all still a bit ‘clunky’.
For example the steps i have to take to sell an item (press the find button - scan - mark result as sold - next game) are a bit time-consuming. I have some background in filemaker and there i would be able to just create a button ‘sell’ scan the barcodes and when they are scanned they are automatically marked as sold.

What i’m basically asking is if functions like this are a possibility with airtable (creating buttons with functions etc). And if not, maybe someone has any tips on making the flow of what i’m trying to achieve a bit better.

And are there things with a pro subscription that would help me get my solution better? (f.e. certain blocks).

Thanks in advance and have a nice day!

There are currently no functions for making buttons in AirTable. Would it be possible for you to create a public copy of the AirTable you’ve currently made, Scrubbing any personal data and putting in a few sample records?

I’d love to take a look at what you have and see if I can help.

Hi Jordan! Thank you for your reply.
I’m not totally sure on how to make by base public?
Does the following work?

Blockquote https://airtable.com/invite/l?inviteId=invqtWHCk7T8D2MAZ&inviteToken=65145fbdfa86bf71ed00f2bfb4e374ff6e091a2da8525fdd871ddf491789e82a

Thanks in advance!

Hi Samuel, you should watch this episode of BuiltOnAir Podcast:
https://builtonair.com/boa-podcast-s02e06-sherman-sanders-board-game-master/

It’s a very similar use case and he shares a bit of how he manages his game store.