Hi,
I am trying to add one more IF code, which validates the data from "MyRequest" collection list, ie if the Totalslides value + slidecount (Datacardvalue6) value > 200 then give error "no occupancy". But it is submitting the form without checking the condition. Not sure what is going wrong.
If(
DateValue2.SelectedDate < Today() Or Weekday(DateValue2.SelectedDate) = 1 Or Weekday(DateValue2.SelectedDate) = 7 Or DateValue2.SelectedDate > varDate,
Notify(
"Please select a date within 3 business days",
NotificationType.Error
),
If(
(LookUp(
MyRequest,
DLDate = Text(
DateValue2.SelectedDate,
"[$-en-GB]dd/mm/yyyy"
),
TotalSlides
) + DataCardValue6.Text) > 200,
Notify("No Occupancy"),
If(
CountRows(DataCardValue12.Attachments) < 1,
Notify("Attachment Missing"),
SubmitForm(FormNewRequest)
)
)
)
