How to make a function search for an empty google sheet cell?

here i have this function that is supposed to search for an empty cell in a google sheet, and update the value in the newest created row to the text input’s text.
image

the problem is that the cells don’t get updated
image

what should i fix in the code?

First we need to know what is actually retuning with that ‘get value’ block. Do a test with a button and call a known empty cell and have the return go to a label. If its coming back ‘null’ then you need to put your ‘get value’ block in the logic box like this:
test1

If that dosnt then we can dive deeper.

Do this:
image

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.