Re: Can I use "suggested values" from the current ...

sales_bikefix · 08-06-2019 07:12 AM

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

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

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

I"m like…

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.

Can I use "suggested values" from the current column