Unable to set values to empty fields & wrong column getting updated

Appsmith Support
1

I’m currently using this to update a column (Status) in a google sheet.

{
    "rowIndex":{{Table1.selectedRow.rowIndex}},
    "Status":"Completed"
}

I have a Menu Button and calling this through one of the button options inside, I’m getting multiple issues when attempting to change the values in the Status field through this method.

  1. I can only change values to the cells with existing data, I can not set any Status value to rows where Status Column is blank/empty.

  2. When I update a status on an existing cell like explained in the first point, it is only changing the first row’s status which was displayed in the table widget. And not the correct row I selected to update. Which is very odd.

  3. Some time I get “Execution failed with status 5005 : Unable to parse row index” error as well. It randomly happens.

Can someone help me to fix this issue please?

2 
{
    "rowIndex":{{Table1.selectedRow.rowIndex}},
    "Status":"Completed"
}

Using triggeredRow instead of selectedRow seems to have fixed the issue. Doing tests to see if any of the order issues are still occurring.