Option "Value" not reflecting in recordUpdates

[jason3w]

I have two tables.
'jobs' and 'statuses'
I link with 'jobs.status_id' and 'statuses.id'.
The initial query on the 'jobs' table has a join to bring in 'statuses.name' along with the 'jobs.status_id'.
I then use another query on the 'statuses' table to get all the statuses. This is used for the dropdown in the 'status_name' column with the value as 'status_id' and the label as 'status_name'.
The user can then select a different 'status_name' from the dropdown.
However, when looking into the recordUpdates object, if the user hasn't made a change to the loaded results from the jobs query, the value is the 'stauts_name', but after making a change it is then displaying the 'status_id'.

Is there a workaround so that the status_id can be used in the updateJobs query in this case?
Thanks!

Thanks

[ScottR]

Since you are looking to use the status_name instead of status_id, you could just use item.name in both Option value and Option Name

[bradlymathews]

Ok I think I understand what you are asking. I use this pattern a lot. I bring over the ID and the name and use the name to be lazy when I just need to display it (otherwise you need to do something like {{jobTypes.value.find(el => el.job_type_id===jobData.value.job_type_id).job_type}} whenever you want to translate from the id to the name).

Basically, you need to omit the .name property when you do you update jobs.

Here I am _.picking the fields I want to use in the update, but you could also use _.omit to remove .name