Galery Header

[dursunzeeee]

How do I add integrated title to gallery like green field

[cds]

wot? 🤔

[Drrickryp]

@dursunzeeee 

You can add a rectangle above the gallery, fill light green, put labels over it with Color black.

[dursunzeeee]

I already did that 🙂
But I want to avoid the alignment every time I add columns to the gallery.

[Drrickryp]

@dursunzeeee 

You could create an empty datatable by using the same dataset as the gallery and simply narrow it down until just the Headers were visible. Put it above the gallery. It would be easy to adjust the width of the column headers as needed in the datatable .  If you added a new column to the gallery, you could add it to the datatable too. 

[Drrickryp]

see above.

[RandyHayes]

@dursunzeeee 

It can be done and it can work fine, there are some caveats. 

BUT...Here is the process:

1) Add a new row at the start of your Gallery.  Based on the last post we interacted on, the would be:

With({_data:
    With({_items: Filter(Menu_Grup; Custom_Grup = Dropdown17_5.Selected.Result)}};
        AddColumns(
            AddColumns(_items;
                "_sum"; Sum(_items; Satis_Miktari);
                "_pop"; Average(_items; Satis_Miktari);
                "_cost"; Maliyet / Satis_Fiyati
            );
            "_costAvg"; Average(_cost)
        )
    )},

    ForAll(Sequence(CountRows(_data)+1, 0),
        Patch(Last(FirstN(_data, Value)), {Seq:Value})
    )
)

This essential creates a zero based index on all of your records (See Idea on this to vote to simplify)

From that, you can check the Seq column to see what it is, and if it is 0, then that is the header.

So, in your Label in your Gallery, something like this:  If(Seq=0, "Title", ThisItem.Title)

And for the Fill:  If(ThisItem.Seq=0, PaleGreen , White)

This will result in the following:

If you need to adjust the size of the label, they will all change accordingly.

NOW...the caveats:

- In your prior posts, you had a tendency to refer to the label text to perform calculations.  As I suggested there, it is better to refer to the underlying data record for the values rather than the labels in the gallery.  However, there are some times that you need to...so, make sure you are always checking to make sure you are not in Seq 0 when you are calculating and getting Values of other labels i.e. Value(Labelx.Text)

Okay...that's actually the only caveat I can think of at the moment.

There is one bonus you get from this...Now all your Rows have a sequence number and you can do alternating coloring of rows if you like.

So, this formula in the TemplateFill property of the Gallery: If(ThisItem.Seq=0, Blue, Mod(ThisItem.Seq, 2)=0, LightSkyBlue, LightCyan) will yield this:

<shameless plug> You can watch for of this concept in my video on alternating row colors.

I hope this is helpful for you.

[RandyHayes · Accepted solution]

For those following this that want to try but, obviously, don't have the same Items property as @dursunzeeee , you can do this with the CustomGallerySample table.

1) Set Items of Gallery to:

With({_items:CustomGallerySample},
    ForAll(Sequence(CountRows(_items)+1, 0),
        Patch(Last(FirstN(_items, Value)), {Seq:Value})
    )
)

2) Add three labels to Gallery. 

    Label1.Text : If(ThisItem.Seq=0, "Sample Heading", ThisItem.SampleHeading)

    Label2.Text : "Sample Image"  (Note, this column will have an image control in it for the other rows)
    Label2.Visible: ThisItem.Seq = 0

    Label3.Text : If(ThisItem.Seq=0, "Sample Text", ThisItem.SampleText)

    For all labels:

       VerticalAlign: If(ThisItem.Seq =0, VerticalAlign.Bottom, VerticalAlign.Middle)

       Underline : ThisItem.Seq=0   

       FontWeight: If(ThisItem.Seq=-0, FontWeight.Bold, FontWeight.Normal)

       Align: If(ThisItem.Seq=0, Align.Center, Align.Left)

3) Add an Image control for the Sample Image column.

     Set the Image property to: ThisItem.SampleImage

     Set the Visible property to : !(ThisItem.Seq=0)

     Set the X property to :  Label2.X + (Label2.Width/2) - (Self.Width/2) (so that the image control moves if you move the header)

4) Set the TemplateFill property of the Gallery to: 

     If(ThisItem.Seq=0, White, Mod(ThisItem.Seq, 2)=0, ColorFade(LightBlue,80%), ColorFade(LightGray, 70%))

End result:

Happy Powerapping!!

[RandyHayes]

Was having problems with the image in the above post, but I resolved it...

[dursunzeeee]

Hi 

I applied what you taught. But  i could not filter by between  two date picker

With({_tits:Gallery5_2};
    ForAll(Sequence(CountRows(Gunluk_ciro)+1; 0);
        Patch(Last(FirstN(Gunluk_ciro; Value)); {Seq:Value})
    ))