topic Re: Column with a dropdown list in Discussions

Column with a dropdown list

SunnyR — Sat, 10 Jun 2023 23:18:00 GMT

I have 2 tables, Table 1 is a summary of the parameters obtained from a set of curves; Table 2 is the x and y column of the curve itself. Both are virtually joined using a "primary/Reference key")

I am classifying the curves in table 2 based on its shape and the associated defects.

I want to create a column in summary table-Table 1 which has a drop down list of certain defects.which repeats ( eg: Low F; Low I, Low V etc). So that I can pick and choose the appropriate one instead of typing it( to avoid mistakes- The examples shown here are simple, but I have lengthier descriptions/combinations of some of the above). I also need an option to modify the drop down list box- where I can add new defects like "One Step" or "kink" etc.

How can I accomplish this?

Re: Column with a dropdown list

Jeff_Perkinson — Tue, 18 Aug 2020 18:00:46 GMT

The List Check property is what you're looking for.

Re: Column with a dropdown list

txnelson — Tue, 18 Aug 2020 17:56:20 GMT

If you set the "List Check" column property for the columns in question, you can right click on a given cell and see the Approved values and select the value one wants.

Re: Column with a dropdown list

SunnyR — Tue, 18 Aug 2020 18:34:15 GMT

Thank you. I came across "list check" before, but missed the "add a value" txt box beneath the box where it aggregates all the values. Since I was not able to enter the values there, I was not sure, Thanks for your clarification

Re: Column with a dropdown list

SunnyR — Tue, 18 Aug 2020 18:35:29 GMT

Thanks.