Showing all data from Airtable

[techbrainz001 (TechBrainz)]

I want to show all data from airtable in the same order what we show in airtable

[Dhayananth_J (Hacker)]

Use Spreadsheet inside storage use ur api and base id
find Api key in: Sign in - Airtable
base id in REST API - Airtable

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

try to use get all rows method, it will give you the same order

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.…

[techbrainz001 (TechBrainz)]

everything is fine…

1. I have 6 fields but it showing only 4 fields in LISTVIEW. and
2. showing VEHICLE and ENAME.

3. mismatches the order from the 4th field onwards.

Here is my block section

here is my database

please help me with those 3 things which I mention above

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

I hope, if you have adjust the list view height, it may resolve

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

@techbrainz001

3 things

If you follow the above method , as said in the previous post, you won’t suffer now like this…

[techbrainz001 (TechBrainz)]

can you tell me how to solve … 2 and 3

[techbrainz001 (TechBrainz)]

i decreased those one but no change

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

If possible share your aia here or pm…

[Kevinkun]

use this extension:

[FREE] KevinkunAirtable extension

V2 Update 2020/12/24 fix bug of “can not update value with space”, now in the formula, use " and " to quote the value with space. add perperty of FetchIdAndTime. if set to true, in the SelectFinished event you will get ‘id’ and ‘createdTime’ for each record. [2020-12-24_200204] add method ‘UpdateById’ and ‘DeleteById’ for update or delete one record, which is faster than by filter.[2020-12-24_200214] v1: Write a short description Why another extension about Airtable?Because this one is di…

edit:
Sorry your question is how to order the fields, not the records.
You may get the records first, then get the field in the order you want by dictionary.

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

@techbrainz001

decreased those one

I told to increase the height… you are storing the value one by ine it seema. If so it needs more height to visible the 4th and 5th…

Instead of using split method use dictionary to take the each value one by one orderly as given in airtable… your 2nd 3rd prob will br over

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

@techbrainz001

add Dictionary

AIRTABLE (1).aia (13.0 KB)

why dont you try this?

[techbrainz001 (TechBrainz)]

please can you help in the blocks section …

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

@techbrainz001

help in the blocks section

But as per your queries , point no 1 , 2 and 3 solved na…

Still anything is there ???

[techbrainz001 (TechBrainz)]

I don’t know how to add Dictionaries…

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

Do you want to help in this app further? In what kind we can help you??

[techbrainz001 (TechBrainz)]

how to add Dictionary in my app instead of SPLIT ??

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

Ref this topic, you will get an idea

Parse JSON file to dictionary

Test.aia (2.4 KB) [blocks (44)] [blocks (45)]

[dora_paz (Dora)]

Try this, split block was replaced

AIRTABLE2.aia (12.5 KB)

[techbrainz001 (TechBrainz)]

i will try…