I am making Quiz Mcq’s app with login feature and in which i need to store every quiz test markes in airtable of specific user row . i have 10 columns but i just want to store the list in 3 columns.
When users attempt 1st test than store values in 3 different cells.
Than if user again attempt test than also store the latest data as well as old data in list.
For example
Default cells value
Column1 “blank”
Column2 “blank”
Column3 “blank”
1 : in 1st test
Column1 : [“60 makes got”]
Column2 : [“date 11/6/23”]
Column3 : [“40 mcq’s wrong”]
4 : in 2nd test
Column1 : [“60 makes got”,“40 markes got”]
Column2 : [“date 11/6/23”,“date 12/6/23”]
Column3 : [“40 mcq’s wrong”,“60 mcq’s wrong”]
I have multiple cells changable so here we can use “update row” block.
But how ? because if i just send single value to airtable than it store easily but if i make list of list than it do nothing. Can you show me demo blocks if you feel easy ?
This is practically how you should do it!
Remember to use the correct component for the type of data you will enter, because if Airtable has specified that this column is a selection column and you send it a data from a text component, it will give you a data error!
You worked hard much for me but i know this logic . i don’t want to do this because in this method it will store data to every column of a row. But i want to store this data in only one column.
Like this :
ColumnItem
[“Item1”,“item2”,“item3”,“item4”]
