Button to pull randomized content from a table with multiple filters applied

Hello! I’m trying to build a meal planner for personal use. Here’s the link, hopefully there are no issues accessing it MealPlan

I’d like to create a button that every time you click, brings a randomized row from a particular column in a table, after applying a couple of filters. I found a great solution to always add a NEW randomized item exactly like I want to implement here. But my beginner brain trying to add another filter to the already long(ish) formula obviously broke it!

So basically, I want to pick a random recipe from the ‘Doable’ table in my ‘Recipes’ tab, after filtering by the ‘Meal’ column, so that I can have separate buttons to get Breakfast, Lunch and Dinner ideas! The ‘Selected’ flag can help avoid repetition.
Also, I want to use the ‘Clear Week’ button to clear my Weekly Meal Plan table, and at the same time uncheck all the cleared recipes in the ‘Selected’ column in ‘Doable’

Apologies if this seems like a straightforward addition to the existing solution, really grateful for any assistance from the community!

@Scott_Collier-Weir Hi Scott, I was wondering if you’d kindly help out with this please? I’m trying to make changes to your very helpful contribution on an earlier post.

Much appreciated, thanks a ton!

Hey @Abhijit_Mahishi , thanks for reaching out! For building help, our Experts Directory is the best resource for that. Our experts can be found here!: Hire a Coda expert, connect with a Coda expert - Coda

If you are looking for general Coda training, we host live weekly demos that I’d love to invite you to. You can reserve your spot here!

In addition, as you start to get more familiar with Coda, below are some resources you’ll find helpful:

  1. Coda Courses for video courses to build along with our experts
  2. Coda Guides for a library of guides to level up your Coda docs and skills
  3. The Gallery tab for inspiration and templates

Please let me know if there’s anything I can do to support you during your Coda journey!

Happy building!

1 Like

Hi Shaina, just wondering if there is no way to get help from the community without hiring experts? I’m an individual user trying to use coda to organize personal information, not building for an org or professional team :slight_smile:

Hey @Abhijit_Mahishi

I hope you’re well. I took a look at your doc, and just wanted to encourage you - you’ve built a really useful tool. I made a copy to solve the issues you brought up, and ended up taking a little creative liberty in the solution. I hope it inspires you to take your doc to the next level. Feel free to Copy Doc and incorporate anything you like into your own version.

I’ve added a “What’s Changed” page to run through the updates I made, and help explain the solutions in a bit more detail. Take a look, and wishing you all the best with the rest of your build.

Jono

3 Likes

@Jono_Bouwmeester you honor your family name. Not only by building and improving, but also by explaining what you did and why. Cheers, Christiaan

2 Likes

Haha, your comment brought a smile to my face. Thank you, @Christiaan_Huizer. High praise from someone I have so much respect for.