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!