Hi All,
I have one Google sheet, with four internal sheets.
The sheets of concern are
โ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?
Is DailySheets[tech_id] a Ref type column?
Which columns are set as the Key and Label columns for the Technicians table?
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
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]
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.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |