Share
Report
2I am making an application to book desks for the office, I have Table1 with the list of desks, and Table 2 with the reservation of desks (user, desk, date). I want people to choose the date, desk and insert their email to make their reservation and show if the desk is available or not for the selected date and user. I put this code on the label destined to show if the desk is available or not but it does not work and I cannot solve the problem, can you help me? Thanks
If(
IsBlank(
LookUp(Tableau2; Text(Desk = SelectDesk.Selected.Desk)&& Date = DatePicker1.SelectedDate)
);
"Available";
"Not Available"
)
IsBlank(
LookUp(Tableau2; Text(Desk = SelectDesk.Selected.Desk)&& Date = DatePicker1.SelectedDate)
);
"Available";
"Not Available"
)
Categories:
All responses (
Answers (
