How to get Multiple Column List or File List From Airtable Sheet by Using One Airtable Block or Procedures
Method 1 : Only for String Column Data List
If your Airtable Doesn’t Contain Files have only Text or Strings
Than Use Simple Block and get Multiple Columns
#Requirements: Drag and Drop Web Component
Method 2 : For String or Files Both Columns List
Here we ca do call all the below Topic
- Get Multiple Column in List Format
- Get File list ,File Name List, Image Thumbnail List
Step 1: First import the Procedure that are available below
(Fixed Doesn’t Change any Value in This Just Download and import)
Sample Airtable Sheet:
Click here to View Airtable Sample Sheet
Step 2: Call all data from airtable block than use the below blocks
Step 3: Here you can call all columns and files by the column Name
(Here you change your Column Name and Get Name Value as Per Need)
For String Text Columns
Column: Enter Your Column Name
Get: list //Column List
Index:0
Example: 1 to 4
For Multiple Files Attachments Column List have Images
Column: Enter Your Column Name
Get: filename //Image File Name
Get: large //Image Thumbnail List
Get: url // Image Medium Size List
Get: full // Original Image List
Index: 1
Example: 5 or 7 : Change Column Name Only
For Multiple Files Attachments Column List have PDF Files
Column: Enter Your Column Name
Get: filename //PDF Filename List
Get: large //PDF Thumbnail List
Get: url //PDF File URL List
Index: 2
Example: 6 or 8 : Change Column Name or Index
All Blocks Returns Data in Column List
If Attechment have Multiple Files in Single Column
Then use index Block 1, 2,…
See Example: 7 or 8 in Above Image
Example: 9
We Discuss how you will get Thumbnail from Files Column with Row 4
Column 1,2 of Both Image or PDF Files.
Note: Attachments each column Should be same file type like Image/PDF or Column Shouldn’t be blank.
Benefits of Airtable Procedure
-
Extract Files Data in List Format
-
It Improve Speed of Get Data.
-
Airtable Data Call Request are Reduced So Your Airtable Sheet Handle Large Users.
(Most of user call Multiple Columns from Airtable by Using Get Column Block again and again at multiple levels it increasing your Data Call Request on your Sheet an Sheet Performance Goes Slow on heavy Traffic) -
One Click get All Column or Files in List Format in (2-3 Second)
-
PDF or Images Thumbnails in Different Sizes in List
-
No need to Upload Thumbnail in Other Hosting or new Column.