Hi Community!
I've got a really quirky problem that I can't see to figure out.
I have a custom page with a gallery containing a few comboboxes. The gallery items are a local collection (colTimesheetLines)
On each combobox there is an onchange event firing which patches back to colTimesheetLines. Each combobox patches different fields, but they generally look like this:
Patch(
colTimesheetLines,
LookUp(colTimesheetLines,GUID=ThisItem.GUID),
{
'Work Hours': Self.Selected.Value,
FinishTime: DateAdd(DateTimeValue(Text(dteTimesheetDate.SelectedDate,ShortDate) & " " & TimeValue(ThisItem.StartTime)),Self.Selected.Value*60,Minutes)
}
);
The defaultItems are different for each combobox too, but generally they look like this:
LookUp(Sequence(61,0,0.25),Value=ThisItem.'Work Hours')
In development, this all works well, the collection is updated and the comboboxes all show the correct information.
In production however, when I change one combobox, they others blank out. It also doesn't seem to be consistent. The underlying collection is correctly patched, and i've verified this by using labels instead of comboboxes for a few of the fields to confirm the data changes.
See 2 x attached GIFs, one in development where it works as expected, and one in production where the comboboxes lose their values.
I'm at a complete loss as to why this is happening.
Anyone have any ideas?
