I would like to set up an RFID card reader system for my fitness center that will be linked to a database.
I would like to have the time when a customer scans their RFID card saved in the corresponding customer line and change his status from something like “Inactive” to “Active”.
You are correct, the video is similar to what you would like to do. In his video though he does not explain how he is getting the data from the card reader. Its possible that his card reader integrates with excel but it is not mentioned how.
Do you know what brand/model card reader you are using? Maybe ask the company or your IT person that maintains your card reader if there is an API you can access.
Once you know where to get the data and what format it is in you can start to see if you can put it into Airtable.