hide a record from a gallery by a boleean toogle

[Richard95]

I have a SQL View that doesn't contain any columns regarding boolean values, what I would like to know if there is any way to do it is that by inserting a Toogle and depending on its false or true value, it hides that record from the gallery. but obviously being a view it would not modify any value in the Database, it would be only visual for the user

Thanks for the attention.

[bnerd]

Create a collection using data from SQL and a column for your toggle control. Set your gallery items to the collection. You can then filter collection based on the toggle value. 

Hope this helps.

[Richard95]

Hello, could you explain me a little more I think I did not understand very well the collection with SQL data

[bnerd]

You need to create a new collection with your data plus an additional column for your toggle, something like:

ClearCollect(
    mySQLRecordsWithToggle,
    AddColumns(
        SQLTableName,
        "ToggleSwitch",
        false
    )
)

 mySQLRecordsWithToggle collection should now have all your SQL data plus one additional column for the toggle, set to false. 

You set your gallery items value to mySQLRecordsWithToggle.

When users change the toggle to Checked, you can run filter something like to get only those records for which hide toggle is not checked (false).

Filter(mySQLRecordsWithToggle, ToggleSwitch.Checked = false)

Hope this helps.

[Richard95]

From what I see if or if I had to create a table and not work with a view to be able to do that

[bnerd]

---

@Richard95 wrote:

From what I see if or if I had to create a table and not work with a view to be able to do that

---

You should be able to use the View just as you would the table.

[Richard95]

I already created the column and set it to False for all values, now how do I make changes in that record when I activate toggle2?

[bnerd]

Hi @Richard95 

first of all create a collection using the sample I gave your above. Then set gallery Items to Filter only those items for which ToggleSwitch value is false.

Filter(<your collection name here>, ToggleSwitch = false)

You toggle control needs to have DisplayMode set to Edit so you can flick it as you browse your items. 

On the OnCheck for the Toggle control you add Patch function to update collection and set the value of the ToggleSwitch column to true, something like this:

Patch(
    <your collection name here>,
    ThisItem,
    {ToggleSwitch: true}
);

This will flick make the item hide from the gallery soon as you switch the toggle to true.

Hope this helps.

[bnerd · Accepted solution]

Just tested it successfully with a table titled tblRooms in my app.

Hope this animated gif can illustrate better what I did - 
Toggle button to remove items from the gallery

But looking at this, toggle button doesn't really make sense much because the item disappears before you can see the toggle switched on. You might be better off with a button titled "Hide" or similar.

[Richard95]

Hello, thank you very much, I am beginning to understand a little more, but I still do not understand very well this part of creating the Collection