I am new to Appgyver and am exploring it, reading the docs and watching the videos. The exercise I am doing is simple (I thought). I want to put an input component on a page , the user types in a value, the value is looked up in a database and a message is displayed on whether it is found or not. Simple.
I have successfully hooked up to Airtable (got one table there with a couple of records), and successfully created a page in Appgyver with a input component and a button.
When tapping the button I have discovered that you cannot use Get to retrieve a record unless you have the ID, which the user would not know. Instead I have to use GetCollection with an Airtable function called filterByFormula to give me a 1 record collection. That seems to work.
But I cannot figure out how to get to the properties (fields) of my 1 record collection. I have watched the tutorials but they all use the strategy of displaying a list, which will give an ID to use to with a GET. Records retrieved with a GET, gives access to the data fields.
So far, to the button I have attached a flow component, GetRecordCollection - that works, it seems to retrieve the correct data. Then attached to the GetRecordCollection is an Alert component to display the value of a field from the data.
And here is the brick wall. The field names are not available in my data variable. The data variable is an object and will not drill down to the fields. How do I make the fields available?
I feel like I am conceptually wide of the mark, so what is wrong with my approach to this simple exercise?