Need help regarding fetching data

[Masoom (Ayan Ansari)]

Hey Koders I need some help regarding fetching data from Airtable. Here is what is want.
I have 4 column in my Table. Each column has 50 cell filled data. What is want is Get only 10 cells data from all column (P.S Fetched Data should not be repeated). I hope you get it what is said. If you have any issue with my query please let me know.

[dora_paz (Dora)]

Do you want to get 1-10, 11-20…till 50 or every time to get 10 random items ?

[Masoom (Ayan Ansari)]

@dora_paz

get 10 random items

Yes I want random items
If A1(Column A Cell 1) is picked then i want B1,C1,D1

[Still-learning (1-2-3-4...)]

1. First get all data from airtable using dictionary method, after getting data’s show first 10 data’s only from the result,
   Upon clicking any button or upon refresh try to get another set of values…

Error Using Airtable's component Get All Rows

That kind of error is obtained when you try to get data from a Json and the logic you use to extract the data does not match with the structure of the json Here is an example of how you can get data from Airtable using the GetAllRows block (with this block you get a Json in the response content) using dictionaries Note: In airtable it is easier to get each column and then work with those data as lists This is my Airtable structure: [imagen] We create the variables for each airtable column.…

[Masoom (Ayan Ansari)]

No That’s not gonna work.

[Still-learning (1-2-3-4...)]

Sounds crazy… may be another will be there but I always suggest this method only to show the members or you can use vsh to show list of datas

[dora_paz (Dora)]

Something like this ?

[Still-learning (1-2-3-4...)]

@Masoom

That’s not gonna work.

Did you try that method? If so can you show your work?

[dora_paz (Dora)]

Once you have made one random list you can get all others lists data according to the index in first list

[dora_paz (Dora)]

If you wish upon refresh to be sure that no item will be included in random list again you have to use tinydb to store first random list and then check whether item is in that list or not

[Masoom (Ayan Ansari)]

yes thats gonna work but there is something i want to tell. Suppose I have 4 column A,B,C,D. Each of them have 50 data.
If i’m picking 10 random cell data from column A (Let’s suppose A1,a33,A4,A8,A10,a18,a17,a39,a13,a12) and stroing in a variable . So I want to get same 10 Random Cell from Column B,C,D and store them in different variables

[dora_paz (Dora)]

Will data from B,C,D columns use the same index as A for axample A3 → B3,C3,D3 or will it be A3, B25, C32, D4? If is it second case then you will have to do the procedure of each column separetely

[Masoom (Ayan Ansari)]

@dora_paz

A3 → B3,C3,D3

Yes Same as it

[Masoom (Ayan Ansari)]

If Column A Index these 10 random cells A(Column A) =a1,a33,a4,a8,a10,a18,a17,a39,a13,a12, Then Column B,C,D should also picked same cells like these
Column B =b1,b33,b4,b8,b10,b18,b17,b39,b13,b12
Column C =c1,c33,c4,c8,c10,c18,c17,c39,c13,c12
Column D =d1,d33,d4,d8,d10,d18,d17,d39,d13,d12

[dora_paz (Dora)]

I recall a procedure created by @Italo which is perfect for what you want

Unique random numbers

Example Blocks

"Procedure - credits to @Italo