I have the following problem:
On the app I am working on, there is a list of stones with 5 parameters for each one.
- hard, 2. not crumbling, 3. not sparkling, 4. no pulp 5. white/reddish color
I collect user specific data input for each stone with its 5 different parameters based on the student impression.
In parallel, I have in google sheet an arrayformula for the 5 correct parameters characterizing each stone.
I want to compare (probably with an if condition) the arrayformula of each stone to the input from the student and see whether the student impressions fits the actual stone characteristics. The problem is that I don’t know how to create an arrayformula within the data table of appglide, based on the 5 parameters user-specific input. These user specific data don’t appear in the googlesheet, but only in appglide data. Do you have any idea on how I can overcome this so i can do the comparison within Gsheet only or appglide only or even combining both?