Ref column autofilled but not in spreadsheet

[SKETCHwade]

Hello all,

I have a table called service schedule.

This shows equipments details.

Then a table called service history this records each service.

Service schedule does a lookup on the spreadsheet side to find the latest service.

Anyway, the equipment is the reference column in service history.

If I hit add here I want to be able to enter a new service.

This works perfectly and feeds back to update the service schedule.

As you can see after pressing the add button everything is autofilled so no one can make a mistake.

The equipment column is filled. Here is the columns settings. I havent set a formula or initial value.

Now the issue is that when I save this it does not use the equipment contents in the spreadsheet.

Ive never seen a columns contents not get carried over into the spreadsheet. its not a virtual column.