Change icon color

Like (0) Share

Report

Posted on 4 Jun 2022 14:42:17 by kinghnvn

Hi @StalinPonnusamy

For Waypoint icon, I want to change the icon color from red to green as available desk when user check out a desk.

Could you please help to edit the code?

If(ThisItem.IsSelected,RGBA(255, 191, 0, 1),With({_item:colOfficeBookingForThisDate},If(!IsBlank(LookUp(_item,Office.Id=ThisItem.ID&&Employee.Email=UserInfo.Email)),RGBA(255, 255, 0, 1),IsBlank(LookUp(_item,Office.Id=ThisItem.ID)),RGBA(54, 176, 75, 1),RGBA(255, 0, 0, 1))))

Thank you very much.

Categories:

General Questions

All responses (5)

Answers (1)

Verified answer

jorge.daniel 1,430 Super User 2024 Season 1 on 04 Jun 2022 at 16:39:09

Like (1)

Report

Re: Change icon color

Pacthing a Yes/No depends on you datasource and on the context:

Patching a sharepoint a record in a gallery: Patch ( Desks, Gallery.Selected, { 'Available': true } )

Patching a dateverse a record in a gallery: Patch( Desks, Gallery.Selected, { Available: 'Available(Desks)'.Yes} )
kinghnvn on 04 Jun 2022 at 16:05:06

Like (0)

Report

Re: Change icon color

Hi Daniel,

CheckIn and CheckOut refer to the person using the desk, right? -> Yes, that’ right.

What I would suggest is to Patch the column Available on the desk table (I am assuming you have a Desks table) whenever a user checks-in or out. -> Could you please show the code for reference?

Many thanks.
jorge.daniel 1,430 Super User 2024 Season 1 on 04 Jun 2022 at 15:57:13

Like (1)

Report

Re: Change icon color

CheckIn and CheckOut refer to the person using the desk, right?

On the other hand, Available is a property of the desk. What I would suggest is to Patch the column Available on the desk table (I am assuming you have a Desks table) whenever a user checks-in or out.
kinghnvn on 04 Jun 2022 at 15:50:28

Like (0)

Report

Re: Change icon color

Yes, I have two columns CheckIn (Yes, No) and CheckOut (Yes, No).
Could you please advice more details?
jorge.daniel 1,430 Super User 2024 Season 1 on 04 Jun 2022 at 15:44:06

Like (1)

Report

Re: Change icon color

Hi,

You could consider having a Available Yes/No column. That column cloud be patched accordingly to show its status. Then the color manipulation would be really simple.

Regards