How might I go about checking an external collection (Airtable) to see if a record already exists? If it does exist, I’d like to show some information about it.
I’m assuming that would be some sort of custom action?
You would need to create a text field in the User’s collection to hold the current value of the scanned QR code (call it Current QR or whatever), then show a list of the external records from Airtable and use a filterByFormula query to filter the records by whatever the"Current QR" field in the Logged in user’s records is.