Hi,
I used Reza's tuturiol to build this editable grid. It actually has an onchange property where it selects a button.
OnChange for Duration control:
Select(btnUpdate)
btnUpdate Code:
Patch('Checklist Details',ThisItem,{
Title: txtTitle.Text,
'Event Date': EventDate.SelectedDate,
'Event Zip': txtEventZip.Text,
'Required Meals': dpdRequiredMeals.Selected,
'Event Duration (HH:MM)': Value(txtDuration.Text)//,
//'Per Diem Rate': Value(txtPerDiemRate.Text)
//'Per Diem Total': txtPerDiemTotal.Text
//'Total Attendees': txtTotalAttendees.Value
});
If(
IsBlank(
LookUp(
colAddMealsUpdates,
ID = ThisItem.ID
)
),
Collect(
colAddMealsUpdates,
ThisItem
)
);
UpdateIf(
colAddMealsUpdates,
ID = ThisItem.ID,
{
Title: txtTitle.Text,
'Event Date': EventDate.SelectedDate,
'Event Zip': txtEventZip.Text,
'Required Meals': dpdRequiredMeals.Selected,
'Event Duration (HH:MM)': txtDuration.Text,
'Per Diem Rate':Value(txtPerDiemRate.Text),
'Per Diem Total': Value(txtPerDiemTotal.Text),
'Total Attendees': txtTotalAttendees.Value
}
);
ClearCollect(
colPerDiemRate,
Table1
);
With(
{
// Perform the lookup once to get the relevant row in collection
Meals: LookUp(
colPerDiemRate,
ThisItem.'Event Lookup:Event Zip Code'.Value = 'Zip Code'
)
},
// Use Switch to determine which value to retrieve
Switch(
dpdRequiredMeals.Selected.Value,
"Breakfast",
Meals.'Breakfast ',
"Light Refreshments",
Meals.'Light Refreshments',
"Lunch",
Meals.Lunch,
"Dinner",
Meals.Dinner
)
)
Duration Default property:
ThisItem.'Event Duration (HH:MM)'
