I was trying to fetch data from different column of table and store them in list using single spreadsheet component.
To debug the issue i used alert to see if it execute every piece of code or not.
Unfortunately Only alert Done1,Done2,Done3 are displayed.
Probably this block is not being executed.
Need Support!!
ADDYLIN
(ADDYLIN)
June 12, 2020, 3:51pm
#2
Use multiple Spreadsheets.
1 for each column.
That works.
ADDYLIN
(ADDYLIN)
June 13, 2020, 9:17am
#4
1 Like
ADDYLIN
(ADDYLIN)
June 13, 2020, 9:18am
#5
I am using this way in my project and that works absolutely fine.
1 Like
pepocero
(Pepocero)
June 13, 2020, 3:11pm
#6
What is the structure of your Airtable?
Because if you have empty cells you don’t get data.
If you get the wrong column name it doesn’t work either. “Title” is not the same as “title”.
Check that.
1 Like
is it prone to crashes due to so many components?
I’ll need 8 of such that.
I think only i am facing this problem…
I tried deleting and again using the spreadsheet component but it is not working out.
ADDYLIN
(ADDYLIN)
June 13, 2020, 5:53pm
#9
No it will not tend to crash.
But it can increase loading time for slow internet users.
1 Like
ADDYLIN
(ADDYLIN)
June 13, 2020, 5:54pm
#10
If you don’t mind send me your aia i will make it work for you.
And will tell you your errors/mistakes.
1 Like
pepocero
(Pepocero)
June 14, 2020, 3:04am
#11
I’m telling you that if you have empty cells you don’t receive data and in your table you have the entire Body column with empty cells. And that is the data you are trying to obtain in spreadsheet 2
2 Likes
Here LyricsInLyf (1).aia (249.3 KB)
I just want this block to get executed when all column are saved in list
!
Here the things you require
appMkXR5tnjgKQUE5
keyUy01HQ9d0SENru
Thankyou very much
It worked when i recreated the project and a new airtable base I was having so many empty columns but in previous base there is another issue because it is not working out there even though i filled the column with random text.
BTW you dont have to waste your time on finding error because I recreated the project from scratch and it is now working with only one spreadsheet.
Thankyou for all the afforts you made
This your solution
After getting all rows you can simply use for each number loop.
system
(system)
Closed
July 14, 2020, 5:39am
#16
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.