You can disregard this...
)
I was using it as an example of where it is working elsewhere in
my app. But I don't think it will work here.
I am fairly sure I have over-complicated things, and this rambling probably
won't make it any easier, but here it goes...
My goal is to prevent the user from being able select an item in a
ComboBox more than once.
Once an item is selected it should be removed from the ComboBox list.
The source data is hundreds of items, so using something like -
ClearCollect(
TestValues,
{ Value: "1" },
{ Value: "2" }...
...at 'OnStart' on screen 'OnVisible' is problematic.
Is there no way for the formula above to refer to an entire column
in a collection, rather than itemizing each value?
If no, I came up with a second option; a warning notification pop-up.
However, I can't get the language right.
The ComboBox 'OnChange' has -
If(!IsBlank(Activity_Description_Fld.Text),
Collect(colActivityComboBoxList, {ActivityName: Activity_Description_Fld.Text,
Activity_intID: Activity_Gallery_intActivityID_Fld.Text}))
The colActivityComboBoxList collection shows the data from the ComboBox 'OnChange'.
However, the warning notification is nested inside the Gallery and the Gallery has no reference to the
ActivityName (which is the key), as I'm not trying to limit the number of Activities that can be created,
only that an Activity type cannot be used twice.
Collect(
colActivities,
{
intActivitiesID: GUID(),
rem: false
}
);
The best I can get so far is the count of item in the colActivityComboBoxList
If(CountRows(colActivityComboBoxList) >1, true)
