Auto Save column field data in sharepoint list

Question

Hi,
So this is little complicated to explain but i will try my best.
we have a SharePoint list saved in "edit in grid view" to get the yes/no drop down choice from users to collect some info. its a simple setup where user just need to go on the list and their respective rows and select Yes/no option choice in their column. The command bar is hidden from them to avoid any view changes so there is no "Exit in grid mode" which actually saves the data. The issue is, when users are selecting the choices, whatever they are choosing in the end is not being saved/retained in the list.

I have added another column as a check box so they have the last click on the column to save previous selection but unless user choose another entry in DIFFRENT ROW. their input is not saving and we have always missing last row selection from user. Any logic I can use here or if we have auto save option in list so that as soon as user select the drop down choice it just saves there?

Answer 1

Hi @Audi86 ,

It does not support auto-save, you need to click "exit in grid mode" to save, this is by design.