Switch toggle per row value not column

Hi everyone!

I’m relatively new to Glide so I apologize in advance if this question is elementary. I’ve been trying to implement multiple switches on the same page, with each changing a different row value in my sheet. However, each switch is connected to the same column, so if I change the value of one switch, the rest change as well. I’ve resorted to splitting up the values per column however this takes up a lot of unnecessary space. Attached, is the image of my “ideal” case where each value in the column can be changed independently of the others, and my “non-deal” case is where I have to set each value apart in their own column. Please let me know if there’s a way to perform this functionality. Thank you so much for your help!

Thanks,
Kirit

ideal sheet

When viewing details or editing a single item, you are only working with one row. Multiple columns would be ideal and preferred in this case.

What it sounds like you want is a one to many relation. If you have a relation from that order sheet to another sheet that containes columns for the order and each individual food item, then you can use the relation to create an inline list and apply the checkbox style so you can individually check each item. But each order would need the same did items repeated and you would have to figure out how to prepopulate the rows when an order is created. An alternative is to use the form button to create each did item row.

I think what you are trying to do is create a single detail on multiple rows. That’s not how database work, so what you are attempting is not possible. If you create multiple columns instead, then that will save on your row count.

Hi Jeff, thanks so much for getting back to me! I’ll definitely look into relations. I was trying to model my app similar to the one on the Switch & Checkbox tutorial page. Based on your description, I’m assuming the tutorial page’s app was built on a one to many relation.

1 Like