Highlighting multiple rows in Gallery

(0) Share

Report

Posted on by CC-19121430-0

240

Hello everyone,

Hope you are well,.

Please could someone assist me, i am hoping to highlight multiple rows in a gallery based on whether a checkbox within the gallery is selected?

Many thanks

Chris

Categories:

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses (11)

Answers (1)

CNT 10,919 Super User 2024 Season 1 on at

Like (1)

Report
Re: Highlighting multiple rows in Gallery

@Appy1 In the TemplateFill property of the Gallery place this code

If(ThisItem.checkbox.Value, Color.Green, Color.White)

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Pstork1 68,295 Most Valuable Professional on at

Like (1)

Report
Re: Highlighting multiple rows in Gallery

Use a formula in the TemplateFill property of the gallery to change the color based on the checkbox. Something like this:

If(ThisItem.checkbox1.Value,Color.Yellow, RGBA(0, 0, 0, 0))

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report

Re: Highlighting multiple rows in Gallery

Hi @CNT

Thanks for your message, i have tried your suggestion and it doesn't seem to be working.

If(ThisItem.Checkbox1.Value=true, Color.Green, Color.White)

It seems to have an error when entered that states "Name isn't valid. - 'Checkbox1' isn't recognized".

There is also the error "Invalid use of "."

Any help much appreciated,

Many thanks
Chris

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report

Re: Highlighting multiple rows in Gallery

Hi @Pstork1

Sorry, it is the same for your suggestion, i am having an error when entering it.

'The function 'if' has some invalid arguments.'
'Name isn't valid. 'Checkbox1' isn't recognized.'

When using the formula provided the rows aren't highlighted unfortunately.

Many thanks
Chris

Was this reply helpful? Yes No
Pstork1 68,295 Most Valuable Professional on at

Like (1)

Report

Re: Highlighting multiple rows in Gallery

Checkbox1 needs to be the name of the column that the checkbox is displaying. Checkbox1 is just a placeholder in my example.

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report

Re: Highlighting multiple rows in Gallery

Hi @Pstork1

Apologies, i havent really used checkboxes before, are you saying that it would need to be related to a column in my data source? similar to how i have using ThisItem.example in the Items property of my text labels etc.

any help is really appreciated, i am still feeling fairly new to creating apps so any help you guys on this forum can give me is great.

Thanks
Chris

Was this reply helpful? Yes No
Verified answer

Pstork1 68,295 Most Valuable Professional on at

Like (0)

Report

Re: Highlighting multiple rows in Gallery

Yes, it needs to be related to an item in your data source. If you just add a checkbox to the gallery template and don't bind it to a column it will check and uncheck for every record each time you check it. The value has to reflect the value of a column in the record or its just a repeating checkbox. And yes it would work just like the ThisItem.somecolumn in your labels.

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report

Re: Highlighting multiple rows in Gallery

Hi @Pstork1 @CNT
Sorry to revive this topic.

I have attempted to do what you suggested, by ticking the checkbox i wish to highlight the row which works, but also change a text input assigned to the particular row on the gallery.

I have added to the Default Property of the Checkbox - ThisItem.'Check Box' which is a column i have added to my excel sheet data source.

Am i missing something else? As currently it changes the TextInput for all records.

Many thanks
Chris

Was this reply helpful? Yes No
Pstork1 68,295 Most Valuable Professional on at

Like (0)

Report

Re: Highlighting multiple rows in Gallery

How are you using the checkbox to change the textinput?

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report
Re: Highlighting multiple rows in Gallery

Hi @Pstork1 ,

This is what i am using for this, kindly providing by @CNT on a separate topic thread.

In the OnVisible of the Screen,
Set(varText, Blank())
In the OnSelect of the button 'set to leaver',
If(Checkbox1.Value = true, Set(varText, "Leaver")); Notify("This Record will be removed overnight - status set to leaver",NotificationType.Information,5000)
In the Default property of the TextInput,
If(IsBlank((varText), Gallery1_1.Selected.Status, varText)

Many thanks for looking at this,
Chris

Was this reply helpful? Yes No