Method:Classic General Q&A

Re: Unable to select column in table for dropdown field

Method_Loi — Mon, 21 Dec 2015 17:38:57 GMT

Hey Kupsol,

I realize you were trying to add the dropdown from the customer table instead of the screen designer. You only see blank and recordID because it is only showing unique fields in that list. If you go make the name field unique in the Inverters table then you will have the ability to select name for the drop down. If you make the name field unique then you have to make sure that you have no duplicate names in your name field.

-- Loi

Re: Unable to select column in table for dropdown field

Method_Loi — Mon, 21 Dec 2015 17:08:44 GMT

Hey Kupsol,

I'm not sure why you are only seeing the two options as I tried to recreate your issue and it showed me all 4 options. I have attached a screenshot to show you.

To edit the table, I created a new simple screen, added a grid, turned on the options to edit and add records in steps 5-6.
-- Loi

Unable to select column in table for dropdown field

Kupsol — Tue, 15 Dec 2015 19:24:26 GMT

Hi,

I created a table called "Inverters" with the name and price of each one in two seprate columns. Then I tried to add a dropdown to my Customers screen, clicked use existing table, and chose Inverters, but it would only let me select RecordID, not the inverter name. The only options were blank and record ID. So now in the customer screen I can only select 1 2 3 etc. What am I doing wrong?

Also, how do you edit data that's in a table? One of my inverter prices is wrong and I can't figure out how to change it.