Likeโฆ include again what I just entered?
Maybe, but I think the system might not like it. What are you shooting for?
โgive me the list of all the ones I have added before but let me add another oneโ
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).
I am trying to use this
SELECT(Bikes[Model], ([Make] = [_THISROW].[Make]), TRUE)
But it returns everything
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).
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
)
)
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.
Please provide a screenshot of your spreadsheet that includes the make and model columns.
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???
Here it isโฆ
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?
Do you mean this?
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?
I"m likeโฆ
This should be really easy, very straight forward. Thereโs got to be some communication disconnect or something.
I think @MultiTech_Visions is on to something.
Yay! Fixed it!
Thank you both for your help.
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |