How do I choose which field(s) is(are) displayed in a dropdown related to a reference field

[Service_Tmr]

Hi All,
I have one Google sheet, with four internal sheets.
The sheets of concern are

1. “Technicians”, main fields being “tech_id” and “tech_name”.
2. “DailySheets”, fields of concern are “tech_id” and “tech_name”.

“tech_id” in “DailySheets” is a reference into the “Technicians” sheet.

On the “DailySheets” form, I want a dropdown of the “tech_id” field to display the “tech_id” information. Right now it displays the “tech_name”
On the next row I want the “tech_name” to be displayed. ( fixed using “LOOKUP” command)

What is actually happening is that the “tech_id” drop down displays the “tech_name” for selection and does not store the “tech_id” value.

How can I change the dropdown field information and store the “tech_id” values to the “DailySheets” form?

[Marc_Dillon]

Is DailySheets[tech_id] a Ref type column?
Which columns are set as the Key and Label columns for the Technicians table?

[Service_Tmr]

Is DailySheets[tech_id] a Ref type column?
Yes

Which columns are set as the Key and Label columns for the Technicians table?

Tech_ID is a key, and Tech_name is a Label.
I now have a better understanding of what label is.
Also I have more learning to do.

Thanks much

Regards Wayne

[Marc_Dillon]

In that case, name should be showing up in the drop-down list, and id should be getting recorded in the sheet. If you want id to show up in the dropdown list, change the Label column to id.

And to pull the name in after an id is selected, use a dereference expression:

[tech_id].[tech_name]

[Service_Tmr]

Hi Marc
Thanks for the update. I ended up with a virtual column combining the tech_id and tech_name as my label.
It also meant that I could display one less field on the form.
Again, thanks for the pointer.