With(
{
_Existing:
LookUp(
QuoteDataCollection,
'NDIS Support Item' = NDISSupportItem.Selected.Value &&
Ratio = RatioSelector.Selected.Value
)
},
If(
!IsBlank(_Existing),
Patch(
QuoteDataCollection,
_Existing,
{
Hours: _Existing.Hours + (Value(Hours.Value) * QuoteWeeks.Value),
Total: _Existing.Total + Value(Gallery2_3.Selected.Total)
}
),
Collect(
QuoteDataCollection,
{
'NDIS Number': SupportItemNumber.Value,
Service: SelectedService.Value,
Day: FormattedDaysTable,
Occurrence: Occurrence.Selected,
Year: QuoteYear.Selected,
Frequency: QuoteFrequency.Selected,
'Custom Frequency': CustomFrequency.Value,
'Service Start': Text(ServiceStart.SelectedDate, "dd/mm/yyyy"),
'Service End': Text(ServiceEnd.SelectedDate, "dd/mm/yyyy"),
Weeks: QuoteWeeks.Value,
'Start Time': StartTimeSelector_lbl2_2.Text,
'Finish Time': FinishTimeSelector_lbl2_2.Text,
Hours: Value(Hours.Value) * QuoteWeeks.Value,
'NDIS Support Item': NDISSupportItem.Selected.Value,
Ratio: RatioSelector.Selected.Value,
Rate: Text(Value(SupportRate.Value), "[$-en-US]#0.00"),
'Custom Rate': CustomRate.Value,
'Num Staff': NumOfStaff.Value,
Desc: QuoteDesc.Value,
Assigned: AssignedStaff.Value,
Total: Text(Value(QuoteTotal.Value), "[$-en-US]#0.00"),
CompDate: DateValue1.SelectedDate,
UserMail: UserMail.Value,
Hour: HourValue1.SelectedItems,
Minute: MinuteValue1.SelectedItems
}
)
)
);
WarrenBelz
146,552
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional