Is there a way to run an automation where I can find the next empty cell in a column?
I am trying to run an automation where the next empty cell in a column is found and then copy some value from another table over to that empty cell. For example, I have a table with usernames and passwords and another table with names and empty columns for usernames and passwords which will be copied over from the other table.
I know there is a FInd Records action where I can look for empty cells, but that action returns all empty cells and not only the first empty cell.
I think I can get this to work by creating a third linking table where I can automate creating new rows with values from both tables but I am sure there is a simpler way to just find the first instance of an empty cell on a column.