Can I use "suggested values" from the current column

[sales_bikefix]

and if not, is there a work-around?

[MultiTech]

Like… include again what I just entered?

Maybe, but I think the system might not like it. What are you shooting for?

[sales_bikefix]

“give me the list of all the ones I have added before but let me add another one”

[MultiTech]

If your column type is an enum or enumlist, there’s an option to remember previous options and allow new ones:

[sales_bikefix]

Can I do another field which takes the values from this column and filters them according to the values in this row. "Show me all the (unique) values in the “Model” column which match the “Make” that I just entered (and let me add one if its not there).

[sales_bikefix]

I am trying to use this
SELECT(Bikes[Model], ([Make] = [_THISROW].[Make]), TRUE)
But it returns everything

[MultiTech]

Oh I think I see what you’re wanting.

You want to be able to enter a list into a column (let’s call it Column_1), then pull a unique list from that into another; right?

So: [Column_1] = {“Orange”, “Blue”, “Green”, “Blue”, “Yellow”}

and in [Column_2] you want: {“Orange”, “Blue”, “Green”, “Yellow”}

right???

Unfortunately that’s not possible, there is no UniqueList() function (or something like that).

[Steve]

sales_bikefix:

SELECT(Bikes[Model], ([Make] = [_THISROW].[Make]), TRUE)

That should work, unless there are rows in the Bike table with blank Make column values, in which case those models would also be included.

Try this instead:

SORT(
  SELECT(
    Bikes[Model],
    AND(
      ISNOTBLANK([Make]),
      ([Make] = [_THISROW].[Make]),
      ISNOTBLANK([Model])
    ),
    TRUE
  )
)

[sales_bikefix]

That still returns all the values, although they are sorted with the ones I want at the top which is sort of useful.

What I want is if I have small/red, small/blue and large/green as existing records, when I have entered small in the new record the next field offers me blue and red.

Its all about entering bikes for repair where we get common combinations of make/model.

[Steve]

Please provide a screenshot of your spreadsheet that includes the make and model columns.

[MultiTech]

sales_bikefix:

although they are sorted with the ones I want at the top which is sort of useful.

Hmmmm… this is interesting. Of these ones that you want, are they naturally in this order?

Or is it like: There are 3 that I want and the formula put those three at the top, even though there’s others mixed in between?

---

Perhaps you should try turning off the auto-complete other values:

If you’ve got that formula in the suggested values, with this turned on I think it would behave like we’re seeing.

So maybe turn off the auto-complete other values???

[sales_bikefix]

Here it is…

[Steve]

Hmmm… I don’t see anything amiss there. How about a screenshot of the View Data screen from the table’s entry in the Data > Tables tab?

[sales_bikefix]

Do you mean this?

[Steve]

Thanks.

I don’t see anything wrong that would cause the behavior you’re describing, so let’s take a step back and confirm we’re on the same page.

When the user is presented with a Bike form, the user should choose a Make from a drop-down menu. When the user goes to select a Model, the drop-down menu should present the list of models associated with the selected Make in existing rows of the table, and allow the user to add a Model value not already included in the drop-down.

Yes?

[MultiTech]

Steve:

so let’s take a step back and confirm we’re on the same page.

I"m like…

sales_bikefix:

What I want is if I have small/red, small/blue and large/green as existing records, when I have entered small in the new record the next field offers me blue and red.

This should be really easy, very straight forward. There’s got to be some communication disconnect or something.

[Steve]

I think @MultiTech_Visions is on to something.

[sales_bikefix]

Yay! Fixed it!

Thank you both for your help.