Hi, so I’ve been trying for 2 days now to do this.
I have a table in AirTable Spreadsheet. I want to go through all the cells of the first row of the table.
I want to find the first cell that is empty.
This how one of my many attempts looks like.
instead of this
can you try one of these below. dont forget to include setting ‘app stop’ to 1
or
Thank you! It’s still a small adjustment, it doesn’t change much. Unfortunately, the program still doesn’t work.
So you are searching each cell of your table for an empty spot?
What do you want to do when you find that spot?
When I find the cell, I want to edit that cell (I want to add text to it);
I can still go through the other cells, but I do not want to edit any of them.
For example, if cell 1 contains text, cell 2 contains text as well, but cells 3 and 4 do not contain any text, I want to edit cell 3 such that it contains text. Cell 4 should remain unchanged.
I’ve got an idea for this. I’ll get back to you later on this
I don’t have your airtable set-up and am preparing for an exam so I couldn’t fully test this.
can you try this out?
Still not working. This code detects the first cell of each row as being empty even if it’s not.
I wonder if this was removed, any difference
Remove the else condition
Then if no luck, switch out the text empty block with a logic block and check does the object =null
Sorry, I think it was my fault - I did not copy your code correctly (probably). Your code works perfectly. Thank you!
I think the issue lies with the fact that the variable row count, there’s no reset every time the button is clicked. Essentially The set cell block is trying to find a Row that won’t exist after the first run through. What you would want to do is add a set row count to zero block every time you press the button before you do any of the other actions following button click
@hi1 Hey! I’m glad this code worked out for you! Awesome work implementing it yourself!
{i renamed this post slightly for search optimization}
