Clear multiple rows with a button (meal planner)

[Nicole]

Hi all,

I am trying to make a dinner planner in Glide and desperately need help please.

I have a table with 7 rows (Monday-Sunday) with a Meal column. Each day is shown in a card collection, and I have set it up so when you tap a day, you enter a meal, and it updates the table correctly.

What I am trying to do is add a single “Reset meals” button below that resets all 7 meals at once (clears the Meals column).

I cannot do this - no matter how many ways I try set up the pathways and page, I can only ever ‘set column values’ to columns in the ‘Users’ table. I have tried:

• Workflows (again, seems limited to Users table)
• Relations
• Look ups

Is there any way I can do a single “Reset meals” button that just deletes the meals from the column with 1 button?

Any help would be greatly appreciated - I feel so out of my depth right now! Pics below to hopefully help. Thanks so much.

[ThinhDinh]

This is a user-specific column, so a loop workflow isn’t going to work, we rule that out first.

From your Users table, you can have 7 single value columns to get back 7 whole rows of this Meal table (from first > 0-based index, so we have 0 until 6).

Then, you create an action with 7 set column values action, targeting 7 single value results above and clear the Meal column.

[Nicole]

Thank you so much!!! Just tried and this has worked perfectly. Appreciate the advice a lot