Hi All,
Hoping someone can help me out. I am trying to create a clickable floorplan for desk booking using buttons over the top of desks in a floorplan. The idea would be to disable the button if the Date/time was already booked and the colour would signify if the desk was laptop ready or had a workstation at it. All of this is populated in a SP List of desks and a second list deals with the bookings.
I know it should be easy but I am struggling to get the formulas for the Button to look at a single record in the SP list for the conditions, every post I think is close involves a gallery and the floorplans are dynamic and not always linear. Can anyone help?
Hi @RhysJWA
Set the Icon Color property to
If(ThisItem.IsSelected,RGBA(255,25,50,1),
With({_item:SPList},
If(!IsBlank(LookUp(_item,Office.Id=ThisItem.ID&&Employee.Email=UserInfo.Email)),
RGBA(80,0,80,1),
IsBlank(LookUp(_item,Office.Id=ThisItem.ID)),
RGBA(0,128,0,1),
RGBA(255,0,0,1))))
Office - Lookup to Another SP List where Desk information present
Employee - Person Record type
I know many videos available for floor/desk booking. Here is the video I worked for one of the customers. It has a few color coding for Selected, Available, Not Available, and Current User.
Thanks,
Stalin - Learn To Illuminate
User | Count |
---|---|
172 | |
90 | |
74 | |
69 | |
58 |
User | Count |
---|---|
215 | |
160 | |
98 | |
92 | |
73 |