This has been asked in the past but I did not find an answer that helped so I am hoping someone can help me construct the blocks.
I am wanting to query some data from airtable however, I have many users data coming into the same table because they all use the same app. (no duhh!)
I want to be able to call specific rows based on qualifiers from 2 columns the UserName and TypeOfData.
from those row I want to get data from the behavior counts to create 3 lists of data to be used as paired coordinates to make a chart. I am not sure what blocks to use to do this. Can anyone help.
for example a query may look like: if Client Name=(firstname.lastname@example.org) and data type = (count) produce 4 lists separated by the comma delmiter , list 1=dates, list 2=behavior count 1, list 3= behaivor count 2, and list 4 = behavior count 3
Currently I do this by having the user save data both in LocalDB and airtable. this poses issues if there is data recorded that isnt ‘good’ data and needs to be recorded. The graphs will not be accurate so i have the airtable option as a backup. I also currently do this for the users using google sheets and Integromat to transfer all of my data but this is very ineficient and costs more than it should (especially if i can include this into the app)
I will include a link to my app and some clarifying screenshots.
the app: Thunkable
the airtable i am working in
this is how i query the data using google sheets.
this is how i query data for my graphs using local db