Thank you all. I learned a lot. My table will have columns in no particular order.
Date with time, location (single select), hive number (single select) and notes (multiple options). I will probably merge the location and hive number. There is no reason for two columns. And notes with multiple options are there because there is a lot less typing this way and all entries are the same for easy analysis.
The main filter will be. Filter all entries and display entries with my town 1 (location and hive number) and sort them in ascending order. So I will have a general idea of what happened with a particular hive in the past. Before the next inspection.
I abandon the idea of using a barcode. Merging location and hive number is easier and less fuzz.
The only problem now is that Airtable doesn’t work without an internet connection. In some remote location in our country, there is only EDGE mobile network and this painfully slow. The normal mobile network is 4G.
Is there a way that to use an Airtable without a mobile network so that data is stored locally and in the cloud? In this case, the mobile network will be only used for syncing data. And not for running the app.
