Form - references ID showing in Google Sheets instead of Name from dropdown selection

[ccscorpioo2015]

Hi Guys, a few weeks into APPSheet and for the most part it has been pretty smooth sailing thus far, however this one particular issue I am having problems I just can't seem to get my head around. So, for this question I have put together a simple Google Sheet tied into a sample APPSheet database to show everyone what I am trying to do. 

To reference my image below, I have made a Google Sheet with two tables. The two table are “Companies” and “COMType”. The Companies table has company names along with a company type that when inside the APP environment is used as a Dropdown selection referencing the “COMType” table to select a company type. So far no problem, I have made the proper reference to “COMType” table & ”Company Type” column within the company table in APPSheet and then the dropdown when tested shows all the possible company types to choose from. When I select a type from the dropdown, like for example “Life-Safety” all the possible types show up properly and once one is picked, it shows up correct within the app screen under “Company Type” as “Life-Safety” great.

The problem now comes up when I go to my Google Sheets side of things and under “Company Type” within the “Company Table” instead of “Fire-Safety”, Showing up in this column, it instead displays the ID number “COMTYPE001” from the “COMType” table. I have learned now that when you reference ID from the record the column that is set as Label will be what is shown within the dropdown and within the APP environment, but it will at the same time return the ID number in place of the Label data within your spreadsheet.

Can anybody tell me in simple terms if and how it is possible to have my “COMType” data that is selected and displayed from my dropdown show up the same within my Google Sheets database instead of being changed back to the ID data.

Thank you all in advance for your consideration and help with this inquiry.

[TeeSee1 · Accepted solution]

You cannot change that.

If you want to store the label on the underlying google sheet, you need to create an additional column to store the label by setting in the app formula something like [Company Type].[Company Type]

[TeeSee1 · Accepted solution]

You cannot change that.

If you want to store the label on the underlying google sheet, you need to create an additional column to store the label by setting in the app formula something like [Company Type].[Company Type]

[ccscorpioo2015 · Accepted solution]

Yes, TeeSee1, that worked. Adding a second Ref column in tandom with the column you data you need to reference correct it for me. I see now how refs function now. Thank you so much for your assistence.