Set(selectedYear; DropdownYear.Selected.Value);;
Set(selectedMonth; DropdownMonth.Selected.Value);;
Set(selectedDay; DropdownDay.Selected.Value);;
Set(hoursValue; Input_Hours.Text);;
Set(Activities; Input_Activity.Text);;
Set(formattedDate;DateTimeValue(selectedDay & "/" & selectedMonth & "/" & selectedYear));;
If(
IsBlank(selectedYear) || IsBlank(selectedMonth) || IsBlank(selectedDay) || IsBlank(Activities) ||IsBlank(hoursValue);
Notify("Please fill in all required fields before proceeding.";NotificationType.Error;5000);
Switch(
Input_User.Text;
"bperez";
If(
IsBlank(
LookUp(
bperez;
DateValue(Text(Date)) = DateValue(Text(formattedDate));
Proposal
)
);
UpdateIf(
brunoperez;
DateValue(Text(Date)) = DateValue(Text(formattedDate));
{
Activity: Activities;
Hours: Value(hoursValue)
}
)
);
"crivera";
If(
IsBlank(
LookUp(
crivera;
DateValue(Text(Date)) = DateValue(Text(formattedDate));
Proposal
)
);
UpdateIf(
conirivera;
DateValue(Text(Date)) = DateValue(Text(formattedDate));
{
Activity: Activities;
Hours: Value(hoursValue)
}
)
)
)
);;
DateAdd(
ThisItem.YourDateField,
-TimeZoneOffset(),
Minutes
)
Stay up to date on forum activity by subscribing.